public Boolean ThemLuongNVTV(LuongNVTV tv)
{
SqlConnection conn = getConnection();
conn.Open();
try
{
string sqlThem = "INSERT INTO BangCongNVThuViec VALUES(@MaPB , @MaNVTV , @Thang ,@Nam , @LuongTV ,@SoGioLamThem ,@SoNgayCong ,@TongLuong)";
SqlCommand cmd = new SqlCommand(sqlThem, conn);
cmd.Parameters.AddWithValue("MaPB", tv.MaPB);
cmd.Parameters.AddWithValue("MaNVTV", tv.MaNV);
cmd.Parameters.AddWithValue("Thang", tv.Thang);
cmd.Parameters.AddWithValue("Nam", tv.Nam);
cmd.Parameters.AddWithValue("LuongTV", tv.LuongTV);
cmd.Parameters.AddWithValue("SoGioLamThem", tv.SoGioLamThem);
cmd.Parameters.AddWithValue("SoNgayCong", tv.SoNgayCong);
cmd.Parameters.AddWithValue("TongLuong", tv.TongLuong);
cmd.ExecuteNonQuery();
}
catch (Exception)
{
return(false);
}
finally
{
conn.Close();
}
return(true);
}
public Boolean SuaLuongNVTV(LuongNVTV tv)
{
SqlConnection conn = getConnection();
conn.Open();
try
{
string sqlSua = "DECLARE @dem int select @dem = COUNT(MaNVTV) FROM BangCongNVThuViec WHERE MaNVTV = @MaNVTV IF @dem != 0 UPDATE BangCongNVThuViec SET Thang = @Thang," +
" Nam = @Nam, LuongTV = @LuongTV, SoGioLamThem = @SoGioLamThem, SoNgayCong = @SoNgayCong, Luong = @TongLuong WHERE MaNVTV = @MaNVTV else raiserror('', 16, 1)";
SqlCommand cmd = new SqlCommand(sqlSua, conn);
cmd.Parameters.AddWithValue("MaNVTV", tv.MaNV);
cmd.Parameters.AddWithValue("Thang", tv.Thang);
cmd.Parameters.AddWithValue("Nam", tv.Nam);
cmd.Parameters.AddWithValue("LuongTV", tv.LuongTV);
cmd.Parameters.AddWithValue("SoGioLamThem", tv.SoGioLamThem);
cmd.Parameters.AddWithValue("SoNgayCong", tv.SoNgayCong);
cmd.Parameters.AddWithValue("TongLuong", tv.TongLuong);
cmd.ExecuteNonQuery();
}
catch (Exception)
{
return(false);
}
finally
{
conn.Close();
}
return(true);
}
public Boolean UpdateLuongNVTV(string MaPB, string MaNV, int Thang, int Nam, long LuongTV, int SoGioLamThem, int SoNgayCong)
{
DataProviderLuongNVTV dp = new DataProviderLuongNVTV();
LuongNVTV bh = new LuongNVTV(MaPB, MaNV, Thang, Nam, LuongTV, SoGioLamThem, SoNgayCong, TinhLuong(LuongTV, SoGioLamThem, SoNgayCong));
return(dp.SuaLuongNVTV(bh));
}
