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 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_ClassesRecordByCourseId(TAS_ClassesRecord tAS_CourseRecord)
{
logHelper.InfoLog("", "GetTAS_ClassesRecordByCourseId");
return(DapperHelper <TAS_ClassesRecord> .Query(@"SELECT * FROM [dbo].[TAS_ClassesRecord] where CourseID=@CourseID", tAS_CourseRecord));
}
