public int AddTAS_Staff(TAS_Staff tAS_Staff)
{
logHelper.InfoLog("", "tAS_Staff");
return(DapperHelper <TAS_Staff> .Execute(@"INSERT INTO [dbo].[TAS_Staff]
([No]
,[CostCentre]
,[Dept]
,[Role])
VALUES
(@No
,@CostCentre
,@Dept
,@Role)", tAS_Staff));
}
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));
}
public int AddTAS_ClassesRecords(TAS_ClassesRecord tAS_CourseRecord)
{
logHelper.InfoLog("", "AddTAS_ClassesRecords");
return(DapperHelper <TAS_ClassesRecord> .Execute(@"INSERT INTO [dbo].[TAS_ClassesRecord]
([CourseID]
,[Hours]
,[ClasseTitle]
,[UId]
,[Position])
VALUES
(@CourseID
,@Hours
,@ClasseTitle
,@UId
,@Position)", tAS_CourseRecord));
}
public int AddTAS_users(TAS_User tAS_user)
{
logHelper.InfoLog("", "AddTAS_users");
return(DapperHelper <TAS_User> .Execute(@"INSERT INTO [dbo].[TAS_User]
([UId]
,[Fname]
,[Lname]
,[Title]
,[StaffNo]
,[Type])
VALUES
(@UId
,@Fname
,@Lname
,@Title
,@StaffNo
,@Type)", tAS_user));
}
public int DelectTAS_users(TAS_User tAS_user)
{
logHelper.InfoLog("", "DelectTAS_users");
return(DapperHelper <TAS_User> .Execute(@"DELETE FROM [dbo].[TAS_User]
WHERE id=@Id", tAS_user));
}