public static int DeleteProfile(HopDongObj qh)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@ma", qh.MaHD)
};
return(ConectToSQL_Datvd.Execute_NonQuery("XoaHopDong", para));
}
public static int DeleteProfile(HeSoLuong qh)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@bac", qh.BacLuong)
};
return(ConectToSQL_Datvd.Execute_NonQuery("XoaLuong", para));
}
public static int UpdateProfile(HeSoLuong qh)
{
SqlParameter[] para = new SqlParameter[]
{ new SqlParameter("@bac", qh.BacLuong),
new SqlParameter("@luongcb", qh.LuongCB),
new SqlParameter("@luongtangca", qh.LuongTangCa) };
return(ConectToSQL_Datvd.Execute_NonQuery("SuaLuong", para));
}
public static int UpdateProfile(HopDongObj qh)
{
SqlParameter[] para = new SqlParameter[]
{ new SqlParameter("@ma", qh.MaHD),
new SqlParameter("@ten", qh.TenHD),
new SqlParameter("@loai", qh.LoaiHD),
new SqlParameter("@ngaybatdau", qh.NgayBatDau),
new SqlParameter("@ngayketthuc", qh.NgayKetThuc),
new SqlParameter("@bac", qh.BacLuong) };
return(ConectToSQL_Datvd.Execute_NonQuery("SuaHopDong", para));
}
public static DataTable GetData()
{
try
{
DataTable dt = new DataTable();
string sql = " select * from HopDong ";
conn = ConectToSQL_Datvd.Connect();
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
da.Fill(dt);
conn.Close();
return(dt);
}
catch
{
conn.Close();
return(null);
}
}