public ActionResult FilterAuthorizeAccountTypeScreen(FilterAccountTypeVM request, string RequestType)
{
if (RequestType == "Add")
{
List <AccountTypeVM> viewModel = ReviewMethods.FilterAccountTypeRequestDetails(request, "R");
return(PartialView("_partialReviewAuthorizeAccountTypeAddView", viewModel));
}
else
{
//fetch from system requests
List <tbl_System_Requests> lst = new SystemRequestDataAccess().GetAllSystemRequests("R", Constants.RequestTypes.AccountTypes_SystemRequest);
List <AccountTypeVM> lstData = new List <AccountTypeVM>();
for (int i = 0; i < lst.Count; i++)
{
AccountTypeVM item = new AccountTypeVM();
item = CustomHelper.ParseJson <AccountTypeVM>(lst[i].UpdatedData);
item.Code = lst[i].ID.ToString();//setting code as ID so it could be used at hyperlink
item.AuthorizationComments = lst[i].AuthorizationComments;
lstData.Add(item);
}
return(PartialView("_partialReviewAuthorizeAccountTypeUpdateView", lstData));
}
}
public ActionResult FilterAuthorizeCardChargesScreen(FilterAccountTypeVM request, string RequestType)
{
if (RequestType == "Add")
{
List <CardChargesVM> viewModel = ReviewMethods.FilterCardChargesRequestDetails(request, "R");
return(PartialView("_partialReviewAuthorizeCardChargesAddView", viewModel));
}
else
{
//fetch from system requests
List <tbl_System_Requests> lst = new SystemRequestDataAccess().GetAllSystemRequests("R", Constants.RequestTypes.CardCharges_SystemRequest);
List <CardChargesVM> lstData = new List <CardChargesVM>();
for (int i = 0; i < lst.Count; i++)
{
CardChargesVM item = new CardChargesVM();
item = CustomHelper.ParseJson <CardChargesVM>(lst[i].UpdatedData);
var cardChargesData = new CardChargesDataAccess().GetCardChargeDetailsById(item.ID);
item.Title = lst[i].ID.ToString();//setting title as ID so it could be used at hyperlink
item.AccountTypeName = cardChargesData.tbl_Account_Types.Name;
item.CardTypeName = cardChargesData.tbl_Card_Types.Title;
item.AuthorizationComments = lst[i].AuthorizationComments;
lstData.Add(item);
}
return(PartialView("_partialReviewAuthorizeCardChargesUpdateView", lstData));
}
}
public static List <CardTypeVM> FilterCardTypeRequestDetails(FilterAccountTypeVM request, string authorizationStatus)
{
using (var db = new SoneriCISEntities())
{
//var _query = default(IQueryable<tbl_Card_Types>);
var query = db.tbl_Card_Types.Where(e => /*e.IsActive == true && */ e.AuthorizationStatus == authorizationStatus).AsQueryable();
if (request.CardTypeId.HasValue)
{
query = query.Where(e => e.ID == request.CardTypeId).AsQueryable();
}
return(query.Select(e => new CardTypeVM
{
ID = e.ID,
AuthorizationComments = e.AuthorizationComments,
AuthorizationStatus = e.AuthorizationStatus,
Title = e.Title,
Description = e.Description,
IsIssuance = e.IsIssuance,
IsReplacement = e.IsReplacement,
IsUpgrade = e.IsUpgrade
}).ToList());
}
}
public static List <AccountTypeVM> FilterAccountTypeRequestDetails(FilterAccountTypeVM request, string authorizationStatus)
{
using (var db = new SoneriCISEntities())
{
//var _query = default(IQueryable<tbl_Account_Types>);
var query = db.tbl_Account_Types.Where(e => /*e.IsActive == true && */ e.AuthorizationStatus == authorizationStatus).AsQueryable();
if (!string.IsNullOrEmpty(request.AccountTypeCode))
{
query = query.Where(e => e.Code == request.AccountTypeCode).AsQueryable();
}
if (request.AccountTypeId.HasValue)
{
query = query.Where(e => e.ID == request.AccountTypeId).AsQueryable();
}
return(query.Select(e => new AccountTypeVM
{
AuthorizationComments = e.AuthorizationComments,
Code = e.Code,
AuthorizationStatus = e.AuthorizationStatus,
Description = e.Description,
ID = e.ID,
Name = e.Name
}).ToList());
}
}
public static List <CardChargesVM> FilterCardChargesRequestDetails(FilterAccountTypeVM request, string authorizationStatus)
{
using (var db = new SoneriCISEntities())
{
//var _query = default(IQueryable<tbl_Card_Charges>);
var query = db.tbl_Card_Charges.Where(e => /*e.IsActive == true && */ e.AuthorizationStatus == authorizationStatus).AsQueryable();
if (request.CardTypeId.HasValue)
{
query = query.Where(e => e.CardTypeID == request.CardTypeId).AsQueryable();
}
if (request.AccountTypeId.HasValue)
{
query = query.Where(e => e.AccountTypeID == request.AccountTypeId).AsQueryable();
}
return(query.Select(e => new CardChargesVM
{
ID = e.ID,
AccountTypeID = e.AccountTypeID,
Amount = e.Amount,
AuthorizationComments = e.AuthorizationComments,
AuthorizationStatus = e.AuthorizationStatus,
CardTypeID = e.CardTypeID,
Title = e.Title,
AccountTypeName = e.tbl_Account_Types.Name,
CardTypeName = e.tbl_Card_Types.Title
}).ToList());
}
}
