public Boolean ThemBangLuongCTy(BangLuongCongTy tv)
{
SqlConnection conn = getConnection();
conn.Open();
try
{
string sqlThem = "INSERT INTO BangLuongCongTy VALUES(@MaLuong , @LCB , @PhuCap , @NgaySua)";
SqlCommand cmd = new SqlCommand(sqlThem, conn);
cmd.Parameters.AddWithValue("MaLuong", tv.MaLuong);
cmd.Parameters.AddWithValue("LCB", tv.LCB);
cmd.Parameters.AddWithValue("PhuCap", tv.PhuCap);
cmd.Parameters.AddWithValue("NgaySua", tv.NgaySua);
cmd.ExecuteNonQuery();
}
catch (Exception)
{
return(false);
}
finally
{
conn.Close();
}
return(true);
}
public Boolean SuaBangLuongCTy(BangLuongCongTy tv)
{
SqlConnection conn = getConnection();
conn.Open();
try
{
string sqlSua = "DECLARE @dem int select @dem = COUNT(MaLuong) FROM BangLuongCongTy WHERE MaLuong = @MaLuong IF @dem != 0 UPDATE BangLuongCongTy " +
"SET MaLuong = @Maluong , LCB = @LCB , PhuCap = @PhuCap , NgaySua = @NgaySua WHERE MaLuong = @MaLuong ";
SqlCommand cmd = new SqlCommand(sqlSua, conn);
cmd.Parameters.AddWithValue("MaLuong", tv.MaLuong);
cmd.Parameters.AddWithValue("LCB", tv.LCB);
cmd.Parameters.AddWithValue("PhuCap", tv.PhuCap);
cmd.Parameters.AddWithValue("NgaySua", tv.NgaySua);
cmd.ExecuteNonQuery();
}
catch (Exception)
{
return(false);
}
finally
{
conn.Close();
}
return(true);
}
public Boolean UpdateBangLuongCTy(string MaLuong, long LCBcu, long PhuCapcu, DateTime NgaySua)
{
DataProviderBangLuongCTy dp = new DataProviderBangLuongCTy();
BangLuongCongTy bh = new BangLuongCongTy(MaLuong, LCBcu, PhuCapcu, NgaySua);
return(dp.SuaBangLuongCTy(bh));
}
