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));
}
public List <TAS_Duty> GetTAS_DutysAll()
{
logHelper.InfoLog("", "GetTAS_DutysAll");
return(DapperHelper <TAS_Duty> .Query(@"SELECT *
FROM [dbo].[TAS_Duty]", new object()));
}
public List <TAS_ClassesRecord> GetTAS_ClassesRecords(TAS_ClassesRecord tAS_CourseRecord)
{
logHelper.InfoLog("", "GetTAS_ClassesRecords");
return(DapperHelper <TAS_ClassesRecord> .Query(@"SELECT * FROM [dbo].[TAS_ClassesRecord] where CourseID=@CourseID and Hours=@Hours and ClasseTitle=@ClasseTitle and UId=@UId and Position=@Position", tAS_CourseRecord));
}
public List <TAS_ClassesRecord> GetTAS_ClassesRecordAll()
{
logHelper.InfoLog("", "GetTAS_ClassesRecordAll");
return(DapperHelper <TAS_ClassesRecord> .Query(@"SELECT * FROM [dbo].[TAS_ClassesRecord]", new object()));
}
public List <TAS_ClassesRecord> GetTAS_ClassesRecordByCourseIds(ByCourseIdsModel byCourseIdsModel)
{
logHelper.InfoLog("", "GetTAS_ClassesRecordByCourseIds");
return(DapperHelper <TAS_ClassesRecord> .Query(@"SELECT * FROM [dbo].[TAS_ClassesRecord] where CourseID in @ids", byCourseIdsModel));
}
public List <TAS_ClassesRecord> GetTAS_ClassesRecordByCourseId(TAS_ClassesRecord tAS_CourseRecord)
{
logHelper.InfoLog("", "GetTAS_ClassesRecordByCourseId");
return(DapperHelper <TAS_ClassesRecord> .Query(@"SELECT * FROM [dbo].[TAS_ClassesRecord] where CourseID=@CourseID", tAS_CourseRecord));
}
public List <System_User> GetUsers(System_User user)
{
logHelper.InfoLog("", "GetUsers");
return(DapperHelper <System_User> .Query("select * from [System_User] where UserName=@UserName and Password=@Password", user));
}
