Exemple #1
0
 public List <TAS_Duty> GetTAS_DutysAll()
 {
     logHelper.InfoLog("", "GetTAS_DutysAll");
     return(DapperHelper <TAS_Duty> .Query(@"SELECT *
                                   FROM [dbo].[TAS_Duty]", new object()));
 }
Exemple #2
0
 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));
 }
Exemple #3
0
 public List <TAS_ClassesRecord> GetTAS_ClassesRecordAll()
 {
     logHelper.InfoLog("", "GetTAS_ClassesRecordAll");
     return(DapperHelper <TAS_ClassesRecord> .Query(@"SELECT * FROM [dbo].[TAS_ClassesRecord]", new object()));
 }
Exemple #4
0
 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));
 }
Exemple #5
0
 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));
 }
Exemple #6
0
 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));
 }