public string KTDangNhap(TaiKhoanBO taikhoanBO)
{
cnn.Open();
string sql = "select IDAcc from Account where Account = @user and Password = @pass";
SqlCommand commandForCheckUser = new SqlCommand(sql, cnn);
commandForCheckUser.Parameters.AddWithValue("@user", taikhoanBO.Account);
commandForCheckUser.Parameters.AddWithValue("@pass", taikhoanBO.Password);
commandForCheckUser.CommandType = CommandType.Text;
string userID = Convert.ToString(commandForCheckUser.ExecuteScalar());
cnn.Close();
return userID;
}
public void Them(TaiKhoanBO taikhoanBO)
{
SqlCommand cmd = new SqlCommand("insert into Account values(@Account,@Password,@Name,@Birth,@Picutre,@Slogun)", cnn);
cmd.Parameters.AddWithValue("@Account", taikhoanBO.Account);
cmd.Parameters.AddWithValue("@PassWord", taikhoanBO.Password);
cmd.Parameters.AddWithValue("@Name", taikhoanBO.Name);
cmd.Parameters.AddWithValue("@Birth", taikhoanBO.Birth);
cmd.Parameters.AddWithValue("@Picutre", taikhoanBO.Picutre);
cmd.Parameters.AddWithValue("@Slogun", taikhoanBO.Slogun);
cnn.Open();
cmd.ExecuteNonQuery();
cnn.Close();
}
public string DangNhap(string Acc,string Pass)
{
string kq = "";
try
{
TaiKhoanBO tkBO = new TaiKhoanBO();
tkBO.Account = Acc;
tkBO.Password = Pass;
kq = tkDAO.KTDangNhap(tkBO);
return kq;
}
catch
{
return kq;
}
}
public bool Them(string Acc,string Pass,string Name,DateTime Birth,Byte[] picture, string Slogun)
{
try
{
TaiKhoanBO tkBO = new TaiKhoanBO();
tkBO.Account = Acc;
tkBO.Password = Pass;
tkBO.Name = Name;
tkBO.Birth = Birth;
tkBO.Picutre = picture;
tkBO.Slogun = Slogun;
tkDAO.Them(tkBO);
return true;
}
catch
{
return false;
}
}
public void Add(TaiKhoanBO _taikhoanBO)
{
List.Add(_taikhoanBO);
}