public string Add_NguoiDung(Cls_NguoiDung nd)
{
string strMessage = string.Empty;
using (SqlConnection conn = new SqlConnection(strConnection))
{
conn.Open();
SqlCommand cmd = new SqlCommand("insert into Tb_NguoiDung (TenDN,MatKhau,MaNV,MaPQ) values(@TENDN,@MATKHAU,@MANV,@MAPQ)", conn);
cmd.Parameters.AddWithValue("@TENDN", nd.tendn);
cmd.Parameters.AddWithValue("@MATKHAU", nd.matkhau);
cmd.Parameters.AddWithValue("@MANV", nd.manv);
cmd.Parameters.AddWithValue("@MAPQ", nd.mapq);
int result = cmd.ExecuteNonQuery();
if (result == 1)
{
strMessage = nd.tendn + " đã thêm thành công!";
}
else
{
strMessage = nd.tendn + " đã thêm không thành công!";
}
conn.Close();
}
return strMessage;
}
public string Delete_NguoiDung(Cls_NguoiDung nd)
{
string strMessage = string.Empty;
using (SqlConnection conn = new SqlConnection(strConnection))
{
conn.Open();
SqlCommand cmd = new SqlCommand("delete Tb_NguoiDung where TenDN=@TENDN", conn);
cmd.Parameters.AddWithValue("@TENDN", nd.tendn);
int result = cmd.ExecuteNonQuery();
if (result == 1)
{
strMessage = nd.tendn + " đã delete thành công!";
}
else
{
strMessage = nd.tendn + " delete không thành công!";
}
conn.Close();
}
return strMessage;
}
public string Update_NguoiDung(Cls_NguoiDung nd)
{
string strMessage = string.Empty;
using (SqlConnection conn = new SqlConnection(strConnection))
{
conn.Open();
SqlCommand cmd = new SqlCommand("update Tb_NguoiDung set MatKhau=@MATKHAU,MaNV=@MANV,MaPQ=@MAPQ where TenDN=@TENDN", conn);
cmd.Parameters.AddWithValue("@TENDN", nd.tendn);
cmd.Parameters.AddWithValue("@MATKHAU", nd.matkhau);
cmd.Parameters.AddWithValue("@MANV", nd.manv);
cmd.Parameters.AddWithValue("@MAPQ", nd.mapq);
int result = cmd.ExecuteNonQuery();
if (result == 1)
{
strMessage = nd.tendn + " đã update thành công!";
}
else
{
strMessage = nd.tendn + " update không thành công!";
}
conn.Close();
}
return strMessage;
}
