using System;
using System.Data.SqlClient;
using System.Data;
using System.Web.Security;

namespace WebApplication2
{
	/// <summary>
	/// Bank 的摘要說明。
	/// </summary>
	public class Bank
	{
		string account;
		string username;
		string money;
		string password;

		#region 屬性的定義
		/// <summary>
		/// 帳戶
		/// </summary>
		public string Account
		{
			get{return account;}
			set{account=value;}
		}
		/// <summary>
		/// 用戶名
		/// </summary>
		public string Username
		{
			get{return username;}
			set{username=value;}
		}
		/// <summary>
		/// 金錢
		/// </summary>
		public string Money
		{
			get{return money;}
			set{money=value;}
		}
		/// <summary>
		/// 密碼
		/// </summary>
		public string Password
		{
			get{return password;}
			set{password=value;}
		}
		#endregion

		public Bank()
		{
			//
			// TODO: 在此處添加構造函數邏輯
			//
		}
		/// <summary>
		/// 判斷是否存在該用戶
		/// </summary>
		public bool judge(string account)
		{
			SqlConnection con=DB.createCon();
			SqlCommand cmd=new SqlCommand("select count(*) from bank where account='"+account+"'",con);
			con.Open();
			int i=Convert.ToInt32(cmd.ExecuteScalar());
			if(i>0)
			{
				return true;
			}
			else
			{
				return false;
			}
		}
		/// <summary>
		/// 判斷用戶的密碼是否正確
		/// </summary>
		public bool check(string account,string password)
		{
			if(this.judge(account))
			{
				SqlConnection con=DB.createCon();
				SqlCommand cmd=new SqlCommand("select count(*) from bank where password='"+password+"' and account='"+account+"'",con);
				con.Open();
				int i=Convert.ToInt32(cmd.ExecuteScalar());
				if(i>0)
				{
					return true;
				}
				else
				{
					return false;
				}
			}
			else
			{
				return false;
			}
		}
		/// <summary>
		/// 修改密碼
		/// </summary>
		public bool UpdataPassword(string Account,string Newpassword)
		{
			SqlConnection con=DB.createCon();
			SqlCommand cmd=new SqlCommand("update bank set password='"+Newpassword+"' where account='"+Account+"'",con);
			con.Open();
			int i=cmd.ExecuteNonQuery();
			if(i>0)
			{
				return true;
			}
			else
			{
				return false;
			}
		}
		/// <summary>
		/// 注冊用戶
		/// </summary>
		public bool insertUser()
		{
			SqlConnection con=DB.createCon();
			con.Open();
			SqlCommand cmd=new SqlCommand("insert into bank values(@account,@username,@money,@password)",con);

			SqlParameter para;
		    para=new SqlParameter("@account",SqlDbType.VarChar,10);
			para.Value=this.account;
			cmd.Parameters.Add(para);
			
			para=new SqlParameter("@username",SqlDbType.VarChar,10);
			para.Value=this.username;
			cmd.Parameters.Add(para);

			para=new SqlParameter("@money",SqlDbType.BigInt,8);
			para.Value=this.money;
			cmd.Parameters.Add(para);

			para=new SqlParameter("@password",SqlDbType.VarChar,10);
			para.Value=this.password;
			cmd.Parameters.Add(para);
				
			int i=cmd.ExecuteNonQuery();
			if(i>0)
			{
				return true;
			}
			else
			{
				return false;
			}
		}
		/// <summary>
		/// 用戶存款
		/// </summary>
		public bool Deposit(string Account,int MoneyCount)
		{
			SqlConnection con=DB.createCon();
            con.Open();
			SqlCommand cmd=new SqlCommand("update bank set money=money+"+MoneyCount.ToString()+" where account='"+Account+"'",con);
			if(cmd.ExecuteNonQuery()>0)
			{
				return true;
			}
			else
			{
				return false;
			}
		}
		/// <summary>
		/// 用戶取款
		/// </summary>
		public bool FetchMoney(string Account,int MoneyCount)
		{
			SqlConnection con=DB.createCon();
			con.Open();
			SqlCommand cmd=new SqlCommand("update bank set money=money-"+MoneyCount.ToString()+" where account='"+Account+"'",con);
			if(cmd.ExecuteNonQuery()>0)
			{
				return true;
			}
			else
			{
				return false;
			}
		}
		
	}
}