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