using System;
using System.Data;
using System.Data.SqlClient;
using Model;

namespace Data_Access
{
	/// <summary>
	/// 數(shù)據(jù)訪問層。
	/// </summary>
	public class Identify
	{
		public Identify()
		{
			//
			// TODO: 在此處添加構(gòu)造函數(shù)邏輯
			//
		}
		private bool flag=false;//判斷連接數(shù)據(jù)庫,查詢登陸是否成功的變量
		private bool flag2=false;//判斷連接數(shù)據(jù)庫,更改密碼是否成功的變量
		private bool flag3=false;//判斷連接數(shù)據(jù)庫,查詢注冊用戶名是否存在的變量
		private bool flag4=false;//判斷連接數(shù)據(jù)庫,判斷注冊是否成功的變量

		#region 驗證登陸是否成功
		public bool loginIden( LoginEntity data)
		{

			try
			{
				Helper lian=new Helper();
				lian.Connect();
				SqlCommand cmd=lian.conn.CreateCommand();
//				SqlCommand cmd=new SqlCommand();
//				cmd.Connection = conn;   //或者				
				cmd.CommandText="select * from Loginer where UserName=@name and PassWord=@pass";
				SqlParameter pare=new SqlParameter("@name",SqlDbType.NVarChar,50,"UserName");
				SqlParameter pare1=new SqlParameter("@pass",SqlDbType.NVarChar,50,"PassWord");
				cmd.Parameters.Add(pare);
				cmd.Parameters.Add(pare1);
				pare.Value=data._UserName;
				pare1.Value=data._PassWord;
				
				if(cmd.ExecuteScalar()!=null)
				{
					 flag=true;
				}
				else
				{
					flag=false;
				}
			}
			catch(SqlException e)
			{
				flag=false;
			}
			catch
			{
				flag=false;

			}
			return flag;
		}
		#endregion

		#region 判斷修改密碼成功否
		public bool Modifypass(LoginEntity data2)
		{
			try
			{
				Helper lian=new Helper();
				lian.Connect();
				SqlCommand cmd2=lian.conn.CreateCommand();
				cmd2.CommandText="update Loginer set PassWord=@newpass where UserName=@name ";
				SqlParameter pare3=new SqlParameter("@name",SqlDbType.NVarChar,50,"UserName");
				SqlParameter pare4=new SqlParameter("@newpass",SqlDbType.NVarChar,50,"PassWord");
				cmd2.Parameters.Add(pare3);
				cmd2.Parameters.Add(pare4);
				pare3.Value=data2._UserName;
				pare4.Value=data2._NewPass;
				if(cmd2.ExecuteNonQuery()>0)
				{
					 flag2=true;
				}
				else
				{
					flag2=false;
				}
			}
			catch(SqlException e)
			{
				flag2=false;

			}
			catch
			{
				flag2=false;

			}
			return flag2;

		}
		#endregion

		#region  判斷注冊的用戶名是否存在

		public bool UserNLive(LoginEntity data3)
		{
			try
			{
				Helper lian=new Helper();
				lian.Connect();
				SqlCommand cmd3=lian.conn.CreateCommand();
				cmd3.CommandText="select UserName from Loginer where UserName=@name";
				SqlParameter pare5=new SqlParameter("@name",SqlDbType.NVarChar,50,"UserName");
				cmd3.Parameters.Add(pare5);
				pare5.Value=data3._UserName;
				if(cmd3.ExecuteScalar()!=null)
				{
					flag3=true;
				}
				else
				{
					flag3=false;
				}
			}
			catch(SqlException e)
			{
				flag3=true;

			}
			catch
			{
				flag3=true;

			}
			return flag3;
		}

		#endregion

		
		#region  判斷注冊成功否
		public bool RegisterUsern(LoginEntity data3)
		{
			try
			{
				Helper lian=new Helper();
				lian.Connect();
				SqlCommand cmd4=lian.conn.CreateCommand();
				cmd4.CommandText="insert into Loginer (UserName,PassWord,Name,Sex,Age,Tel,Address) values(@username,@password,@name2,@sex,@age,@tel,@address) ";
				SqlParameter pare6=new SqlParameter("@username",SqlDbType.NVarChar,50,"UserName");
				SqlParameter pare7=new SqlParameter("@password",SqlDbType.NVarChar,50,"PassWord");
				SqlParameter pare8=new SqlParameter("@name2",SqlDbType.NVarChar,50,"Name");
				SqlParameter pare9=new SqlParameter("@sex",SqlDbType.Char,2,"Sex");
				SqlParameter pare10=new SqlParameter("@age",SqlDbType.Int,4,"Age");
				SqlParameter pare11=new SqlParameter("@tel",SqlDbType.NVarChar,50,"Tel");
				SqlParameter pare12=new SqlParameter("@address",SqlDbType.NVarChar,50,"Address");
				cmd4.Parameters.Add(pare6);
				cmd4.Parameters.Add(pare7);
				cmd4.Parameters.Add(pare8);
				cmd4.Parameters.Add(pare9);
				cmd4.Parameters.Add(pare10);
				cmd4.Parameters.Add(pare11);
				cmd4.Parameters.Add(pare12);
				pare6.Value=data3._UserName;
				pare7.Value=data3._PassWord;
				pare8.Value=data3._Name;
				pare9.Value=data3._Sex;
				pare10.Value=data3._Age;
				pare11.Value=data3._Tel;
				pare12.Value=data3._Address;
				if(cmd4.ExecuteNonQuery()>0)
				{
					flag4=true;
				}
				else
				{
					flag4=false;
				}

			}	
			catch(SqlException e)
			{
				flag4=false;
			}
			catch
			{
				flag4=false;

			}
			return flag4;
		}
		#endregion
	}
}