public List <TAS_User> GetTAS_users(TAS_User tAS_user)
{
logHelper.InfoLog("", "GetTAS_users");
return(DapperHelper <TAS_User> .Query(@"SELECT *
FROM [dbo].[TAS_User]
where UId=@UId and Fname=@Fname and @Lname=Lname and Title=@Title and StaffNo=@StaffNo and Type=@Type", tAS_user));
}
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));
}
