//for pagination//
public IQueryable <CancelRequestModel> GetCancelRequestByPagination(CancelRequestModel m, int pageNo, out int currentPageNo, out int numberOfPages, int?flag)
{
int pageSize = 30; //(int)AirLines.Helpers.PageSize.JePageSize;
int rowCount = m.CancelRequestList.Count();
numberOfPages = (int)Math.Ceiling((decimal)rowCount / (decimal)pageSize);
if (flag != null)//Checking for next/Previous
{
if (flag == 1)
{
if (pageNo != 1) //represents previous
{
pageNo -= 1;
}
}
if (flag == 2)
{
if (pageNo != numberOfPages)//represents next
{
pageNo += 1;
}
}
}
currentPageNo = pageNo;
int rowsToSkip = (pageSize * currentPageNo) - pageSize;
IQueryable <CancelRequestModel> pagingdata = m.CancelRequestList.OrderByDescending(x => x.BookedBy).Skip(rowsToSkip).Take(pageSize).AsQueryable();
return(pagingdata.AsQueryable());
}
public ActionResult Details(long Id, int serid, CancelRequestModel model, string CancelledTicket)
{
var ts = (TravelSession)Session["TravelPortalSessionInfo"];
model.CreatedBy = ts.AppUserId;
if (CancelledTicket == "Approve Cancel")
{
ser.Confirm(Id, 0, model.ArihantCancellationCharge, true, 1, ts.AppUserId, serid);
}
else
{
ser.RevertCancel(Id);
}
model.PNRId = Id;
ser.CancelledTicketRemarks(model, CancelledTicket);
model.CancelRequestList = ser.CancelListRequestList().ToPagedList(1, int.MaxValue);
return(View("Index", model));
}
public List <CancelRequestModel> CancelListRequestList()
{
int sno = 0;
var data = ent.Air_GetCancelListRequest(null);
List <CancelRequestModel> model = new List <CancelRequestModel>();
foreach (var item in data.Select(x => x).OrderByDescending(x => x.BookedBy))
{
sno++;
var CancelRequestModel = new CancelRequestModel
{
SNO = sno,
PNRId = item.PNRId,
PassengerName = item.PassengerName,
Sector = item.Sector,
BookedOn = (DateTime)item.BookedOn,
BookedBy = item.BookedBy,
GDSRefrenceNumber = item.GDSRefrenceNumber,
TicketStatusName = item.ticketStatusName,
TicketStatusID = item.TicketStatusId,
AgentName = item.AgentName,
serviceproviderid = item.ServiceProviderId
};
model.Add(CancelRequestModel);
}
return(model.ToList());
}
/// <summary>
/// Getting the shifts. shift Details those had a cancellation request
/// </summary>
/// <returns></returns>
public List <CancelRequestModel> GetCancelshiftRequests()
{
//Join b/w user and shift detail table
var cancelShiftRequests = _userContext.ShiftDetailModels.Include(s => s.Shift).Join(_userContext.UserModels,
shiftDetail => shiftDetail.PickedByEmployee,
user => user.Id,
(shiftDetail, user) =>
new {
shiftDetail,
user
}).
Where(s => s.shiftDetail.IsCancelRequest == true)
.ToList();
List <CancelRequestModel> cancelRequestModels = new List <CancelRequestModel>();
foreach (var cancelShiftRequest in cancelShiftRequests)
{
var cancelRequestModel = new CancelRequestModel
{
ShiftDetails = cancelShiftRequest.shiftDetail,
UserName = cancelShiftRequest.user.UserName,
UserId = cancelShiftRequest.user.Id
};
cancelRequestModels.Add(cancelRequestModel);
}
return(cancelRequestModels);
}
public ActionResult Index(int?page)
{
int currentPageIndex = page.HasValue ? page.Value : 1;
int defaultPageSize = 30;
CancelRequestModel model = new CancelRequestModel();
model.CancelRequestList = ser.CancelListRequestList().ToPagedList(currentPageIndex, defaultPageSize);
return(View(model));
}
public void CancelledTicketRemarks(CancelRequestModel model, string CancelledTicket)
{
TransactionLog obj = new TransactionLog
{
PNRId = model.PNRId,
TransactionType = 1,
TransactionCharge = (decimal)model.ArihantCancellationCharge,
RequestStatus = CancelledTicket == "Approve Cancel" ? "Cancel-Request" : "Cancel-Request-Reject",
Remark = model.Remarks,
CreatedBy = model.CreatedBy,
CreatedDate = DateTime.UtcNow,
};
ent.AddToTransactionLog(obj);
ent.SaveChanges();
}
public List <CancelRequestModel> GetCommemtList(Int64 id)
{
List <CancelRequestModel> model = new List <CancelRequestModel>();
var result = ent.TransactionLog.Where(xx => xx.PNRId == id).ToList();
foreach (var item in result)
{
CancelRequestModel obj = new CancelRequestModel();
obj.TransactionLogId = item.TransactionLogId;
obj.TransactionType = item.TransactionType;
obj.PNRId = item.PNRId;
obj.Remark = item.Remark;
obj.CreatedBy = item.CreatedBy;
obj.CreatedName = GetUserName(item.CreatedBy);
obj.CreatedDate = item.CreatedDate;
model.Add(obj);
}
return(model);
}
public IActionResult CancelRequest(string email, string snack_brand, string snack_name, string request_count)
{
Request request = new Request(email, snack_brand, snack_name, Int32.Parse(request_count));
var cancelRequestModel = new CancelRequestModel()
{
Request = request
};
var model = new RequestModel()
{
CancelRequestModel = cancelRequestModel
};
// Cancel request
RequestRepository requestRepository = new RequestRepository(_connection);
requestRepository.CancelRequest(request);
requestRepository.IncrementCount(request);
return(View(model));
}
public async Task <CancelResponseModel> Cancel(CancelRequestModel request)
{
var securityUrl = request.Settings["SecurityUrl"];
var userName = request.Settings["UserName"];
var password = request.Settings["Password"];
var voidUrl = request.Settings["VoidUrl"];
var merchantId = request.Settings["MerchantId"];
var token = await this._visaNetSecurityTokenService.GetToken(securityUrl, userName, password);
var requestMessage = new
{
order = new
{
purchaseNumber = request.OrderNumber,
transactionDate = request.TransactionDate.ToString("yyyyMMdd")
}
};
var headers = new Dictionary <string, string>();
headers.Add("authorization", token);
using (var proxy = new HttpClient())
{
var httpRequest = new HttpRequestMessage(HttpMethod.Post, $"{voidUrl}/reverse/ecommerce/{merchantId}");
foreach (var h in headers)
{
httpRequest.Headers.TryAddWithoutValidation(h.Key, h.Value);
}
var json = Newtonsoft.Json.JsonConvert.SerializeObject(requestMessage);
httpRequest.Content = new StringContent(json, Encoding.UTF8, "application/json");
var response = await proxy.SendAsync(httpRequest);
if (response.IsSuccessStatusCode)
{
var data = Newtonsoft.Json.JsonConvert.DeserializeObject <CancelResultModel>(await response.Content.ReadAsStringAsync());
var result = new CancelResponseModel
{
Success = true
};
return(result);
}
var errorData = Newtonsoft.Json.JsonConvert.DeserializeObject <CancelFailedResultModel>(await response.Content.ReadAsStringAsync());
return(new CancelResponseModel
{
Success = false,
Errors = new List <TransactionErrorResponseModel> {
new TransactionErrorResponseModel {
Code = errorData.ErrorCode, Message = errorData.ErrorMessage
}
}
});
}
}
public ActionResult Details(CancelRequestModel model, Int64 id)
{
model.PNRId = id;
model.CommentList = ser.GetCommemtList(id);
return(View(model));
}
