public int AddTAS_CourseRecords(TAS_CourseRecord tAS_CourseRecord)
{
logHelper.InfoLog("", "AddTAS_CourseRecords");
return(DapperHelper <int> .Query(@"INSERT INTO [dbo].[TAS_CourseRecord]
([CourseCode]
,[CourseTitle]
,[Dept]
,[Schooltime]
,[HQ]
,[UNITA]
,[UNITB]
,[UNITC]
,[ITGY]
,[MSAF]
,[SMG])
VALUES
(@CourseCode
,@CourseTitle
,@Dept
,@Schooltime
,@HQ
,@UNITA
,@UNITB
,@UNITC
,@ITGY
,@MSAF
,@SMG);SELECT CAST(SCOPE_IDENTITY() as int)", tAS_CourseRecord).FirstOrDefault());
}
public TAS_CourseRecord GetTAS_CourseRecord(TAS_CourseRecord tAS_CourseRecord)
{
logHelper.InfoLog("", "GetTAS_CourseRecord");
return(DapperHelper <TAS_CourseRecord> .QueryFirst(@"SELECT *
FROM [dbo].[TAS_CourseRecord]
where Id=@id", tAS_CourseRecord));
}
public List <TAS_CourseRecord> GetTAS_CourseRecords(TAS_CourseRecord tAS_CourseRecord)
{
logHelper.InfoLog("", "GetTAS_CourseRecords");
return(DapperHelper <TAS_CourseRecord> .Query(@"SELECT *
FROM [dbo].[TAS_CourseRecord]
where CourseCode=@CourseCode and CourseTitle=@CourseTitle and Type=@Type and Hours=@Hours and Dept=@Dept and UId=@UId and Schooltime=@Schooltime and HQ=@HQ and UNITA=@UNITA and UNITB=@UNITB and UNITC=@UNITC and ITGY=@ITGY and MSAF=@MSAF and SMG=@SMG and", tAS_CourseRecord));
}
