//
public TAIKHOAN LayTT(string tk)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
string sql = @"SELECT * FROM dbo.QUANLY WHERE TAIKHOAN = @TK";
SqlCommand cmd = new SqlCommand(sql, connection); cmd.Parameters.AddWithValue("@TK", tk);
connection.Open(); SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
TAIKHOAN QL = new TAIKHOAN
{
// Lấy giá trị theo tên cột trong CSDL
TENTAIKHOAN = (string)reader["TAIKHOAN"],
MATKHAU = (string)reader["MATKHAU"],
DIACHI = (string)reader["DIACHI"],
SODIENTHOAI = (string)reader["SDT"],
HOTEN = (string)reader["HOTEN"],
EMAIL = (string)reader["EMAIL"],
};
return(QL);
}
}
return(null);
}
public bool InsertTAIKHOAN(TAIKHOAN TAIKHOAN)
{
SqlConnection connection = new SqlConnection(connectionString);
string sql = @"INSERT INTO dbo.QUANLY(TAIKHOAN,MATKHAU,EMAIL,DIACHI,HOTEN, PHANQUYEN, SDT)
VALUES('" + TAIKHOAN.TENTAIKHOAN + "','" + TAIKHOAN.MATKHAU + "', '" + TAIKHOAN.EMAIL + "','" + TAIKHOAN.DIACHI + "','" + TAIKHOAN.HOTEN + "'," + TAIKHOAN.QUYEN + ",'" + TAIKHOAN.SODIENTHOAI + "')";
SqlCommand cmd = new SqlCommand(sql, connection);
connection.Open();
int result = cmd.ExecuteNonQuery();
connection.Close();
if (result != 0)
{
return(true);
}
return(false);
}
//
public bool UpDateTK(TAIKHOAN us)
{
SqlConnection connection = new SqlConnection(connectionString);
string sql = @"UPDATE dbo.QUANLY SET MATKHAU = @mk, EMAIL = @Email,DIACHI=@dc ,SDT = @SoDienThoai, HOTEN=@ht WHERE TAIKHOAN = @tk";
SqlCommand cmd = new SqlCommand(sql, connection);
cmd.Parameters.AddWithValue("@tk", us.TENTAIKHOAN);
cmd.Parameters.AddWithValue("@mk", us.MATKHAU);
cmd.Parameters.AddWithValue("@Email", us.EMAIL);
cmd.Parameters.AddWithValue("@dc", us.DIACHI);
cmd.Parameters.AddWithValue("@SoDienThoai", us.SODIENTHOAI);
cmd.Parameters.AddWithValue("@ht", us.HOTEN);
connection.Open();
int result = cmd.ExecuteNonQuery();
connection.Close();
if (result != 0)
{
return(true);
}
return(false);
}
