public async Task <TermVM> GetTermListAsync(int pageno, int pagesize, string sterm)
{
TermVM model = new TermVM();
var parStart = new SqlParameter("@Start", (pageno - 1) * pagesize);
var parEnd = new SqlParameter("@PageSize", pagesize);
var parSearchTerm = new SqlParameter("@SearchTerm", DBNull.Value);
if (!(sterm == null || sterm == ""))
{
parSearchTerm.Value = sterm;
}
// setting stored procedure OUTPUT value
// This return total number of rows, and avoid two database call for data and total number of rows
var spOutput = new SqlParameter
{
ParameterName = "@TotalCount",
SqlDbType = System.Data.SqlDbType.BigInt,
Direction = System.Data.ParameterDirection.Output
};
model.TermList = await objDB.Database.SqlQuery <TermView>("udspMstTermList @Start, @PageSize,@SearchTerm, @TotalCount out",
parStart, parEnd, parSearchTerm, spOutput).ToListAsync();
model.TotalRecords = int.Parse(spOutput.Value.ToString());
return(model);
}
public async Task EditTerm(TermVM term)
{
TermQueue termQueue = Mapper.Map <TermVM, TermQueue>(term, options => {
options.AfterMap((src, dest) => dest.UserPerformingAction = this.UserId);
options.AfterMap((src, dest) => dest.TenantId = this.TenantId);
});
ProcessQueueHistory processQueueHistory = new ProcessQueueHistory()
{
Data = JsonConvert.SerializeObject(termQueue),
AddedById = this.UserId,
TenantId = this.TenantId,
Status = Data.Enums.ResultStatus.Waiting,
Type = Data.Enums.ProcessType.EditTerm
};
await this.queueHandler.AddToQueue(processQueueHistory);
}
public ActionResult TermList(int PageNo = 1, int PageSize = 10, string SearchTerm = "")
{
try
{
ViewBag.ActiveURL = "/Admin/Termlist";
string query = "PageNo=" + PageNo + "&PageSize=" + PageSize + "&SearchTerm=" + SearchTerm;
TermAPIVM apiModel = objAPI.GetRecordByQueryString <TermAPIVM>("configuration", "termlist", query);
TermVM model = new TermVM();
model.TermList = apiModel.TermList;
model.PagingInfo = new PagingInfo {
CurrentPage = PageNo, ItemsPerPage = PageSize, TotalItems = apiModel.TotalRecords
};
if (Request.IsAjaxRequest())
{
return(PartialView("_pvTermList", model));
}
return(View(model));
}
catch (AuthorizationException)
{
TempData["ErrMsg"] = "Your Login Session has expired. Please Login Again";
return(RedirectToAction("Login", "Account", new { Area = "" }));
}
}
public async Task <IActionResult> Edit([FromBody] TermVM term)
{
await this.TermService.EditTerm(term);
return(Ok());
}
public async Task <IActionResult> GetById(Guid id)
{
TermVM term = await this.TermService.GetTermById(id);
return(Json(term));
}
