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