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);
 }