public List <TAS_Duty> GetTAS_Dutys(TAS_Duty tAS_Duty) { logHelper.InfoLog("", "GetTAS_Dutys"); return(DapperHelper <TAS_Duty> .Query(@"SELECT * FROM [dbo].[TAS_Duty] where StaffNo=@StaffNo and CostCentre=@CostCentre and Hours=@Hours and Duty=@Duty", tAS_Duty)); }
public int AddTAS_Dutys(TAS_Duty tAS_Duty) { logHelper.InfoLog("", "AddTAS_Dutys"); return(DapperHelper <TAS_Duty> .Execute(@"INSERT INTO [dbo].[TAS_Duty] ([StaffNo] ,[CostCentre] ,[Hours] ,[Duty]) VALUES (@StaffNo ,@CostCentre ,@Hours ,@Duty)", tAS_Duty)); }