public string Add_ChuyenCongTac(Cls_ChuyenCongTac cct)
{
string strMessage = string.Empty;
using (SqlConnection conn = new SqlConnection(strConnection))
{
conn.Open();
SqlCommand cmd = new SqlCommand("insert into Tb_ChuyenCongTac (MaChuyen,MaNV,NgayChuyen,MaCVCu,MaPBCu,MaCVMoi,MaPBMoi) values(@MACHUYEN,@MANV,@NGAYCHUYEN,@MACVCU,@MAPBCU,@MACVMOI,@MAPBMOI)", conn);
cmd.Parameters.AddWithValue("@MACHUYEN", cct.machuyen);
cmd.Parameters.AddWithValue("@MANV", cct.manv);
cmd.Parameters.AddWithValue("@NGAYCHUYEN", cct.ngaychuyen);
cmd.Parameters.AddWithValue("@MACVCU", cct.macvcu);
cmd.Parameters.AddWithValue("@MAPBCU", cct.mapbcu);
cmd.Parameters.AddWithValue("@MACVMOI", cct.macvmoi);
cmd.Parameters.AddWithValue("@MAPBMOI", cct.mapbmoi);
int result = cmd.ExecuteNonQuery();
if (result == 1)
{
strMessage = cct.machuyen + " đã thêm thành công!";
}
else
{
strMessage = cct.machuyen + " đã thêm không thành công!";
}
conn.Close();
}
return strMessage;
}
public string Delete_ChuyenCongTac(Cls_ChuyenCongTac cct)
{
string strMessage = string.Empty;
using (SqlConnection conn = new SqlConnection(strConnection))
{
conn.Open();
SqlCommand cmd = new SqlCommand("delete Tb_ChuyenCongTac where MaChuyen=@MACHUYEN", conn);
cmd.Parameters.AddWithValue("@MACHUYEN", cct.machuyen);
int result = cmd.ExecuteNonQuery();
if (result == 1)
{
strMessage = cct.machuyen + " đã delete thành công!";
}
else
{
strMessage = cct.machuyen + " delete không thành công!";
}
conn.Close();
}
return strMessage;
}
public string Update_ChuyenCongTac(Cls_ChuyenCongTac cct)
{
string strMessage = string.Empty;
using (SqlConnection conn = new SqlConnection(strConnection))
{
conn.Open();
SqlCommand cmd = new SqlCommand("update Tb_ChuyenCongTac set MaNV=@MANV,NgayChuyen=@NGAYCHUYEN,MaCVCu=@MACVCU,MaPBCu=@MAPBCU,MaCVMoi=@MACMOI,MaPBMoi=@MAPBMOI where MaChuyen=@MACHUYEN", conn);
cmd.Parameters.AddWithValue("@MACHUYEN", cct.machuyen);
cmd.Parameters.AddWithValue("@MANV", cct.manv);
cmd.Parameters.AddWithValue("@NGAYCHUYEN", cct.ngaychuyen);
cmd.Parameters.AddWithValue("@MACVCU", cct.macvcu);
cmd.Parameters.AddWithValue("@MAPBCU", cct.mapbcu);
cmd.Parameters.AddWithValue("@MACVMOI", cct.macvmoi);
cmd.Parameters.AddWithValue("@MAPBMOI", cct.mapbmoi);
int result = cmd.ExecuteNonQuery();
if (result == 1)
{
strMessage = cct.machuyen + " đã update thành công!";
}
else
{
strMessage = cct.machuyen + " update không thành công!";
}
conn.Close();
}
return strMessage;
}
