public async Task <List <TRIALSpIndex> > GetIndex(Int64 ScreenId, Int64 UserId, Int64 RecordsPerPage, Int64 PageNo, Int64 TableId, Boolean LastPage)
{
TRIALSpIndex result = new TRIALSpIndex();
try
{
string csql = @" EXEC spGetPageData
@pi_mScreenId
, @pi_mUserId
, @pi_RecordsPerPage
, @pi_PageNo
, @pi_mTableId
, @pi_LastPage";
List <SqlParameter> sqlparam = new List <SqlParameter>()
{
new SqlParameter("@pi_mScreenId", ScreenId),
new SqlParameter("@pi_mUserId", UserId),
new SqlParameter("@pi_RecordsPerPage", RecordsPerPage),
new SqlParameter("@pi_PageNo", PageNo),
new SqlParameter("@pi_mTableId", TableId),
new SqlParameter("@pi_LastPage", LastPage),
};
return(await _Context.TRIALSpIndex.FromSql(csql, sqlparam.ToArray()).ToListAsync());
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <TRIALSpIndex> GetEntry(Int64 id)
{
try
{
TRIALSpIndex result = await _Context.TRIALSpIndex.FromSql("Exec spmTRIALSpEntry @pi_mTRIALSpId", new SqlParameter("@pi_mTRIALSpId", id)).SingleOrDefaultAsync();
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <IActionResult> Get(Int64 id)
{
TRIALSpIndex result = await _repo.GetEntry(id);
return(Ok(result));
}
