/////////////////////////////////For IndianLcc and Domestic//////////////////////////////////////////
public PNRsModel GetIndianLccPNRDetail(int PNRId)
{
var result = _ent.TBO_MasterPNRs.Where(x => x.MPNRId == PNRId).FirstOrDefault();
var CreatedBystring = _ent.UsersDetails.Where(x => x.AppUserId == result.CreatedBy).FirstOrDefault();
PNRsModel model = new PNRsModel();
if (result != null)
{
model = new PNRsModel
{
AgentId = result.AgentId,
ContactNumber = result.Phone,
BookedBy = CreatedBystring.FullName,
CreatedDate = result.CreatedDate,
EmailAddress = result.Email,
FirstName = result.FirstName,
GDSRefrenceNumber = result.TBO_PNRs.FirstOrDefault().RecLoc,
LastName = result.LastName,
MiddleName = result.MiddleName,
PNRId = result.MPNRId,
Prefix = result.Prefix,
ServiceProviderId = result.ServiceProviderId,
TicketStatusId = result.TicketStatusId,
UpdatedBy = result.UpdatedBy,
UpdatedDate = result.UpdatedDate,
TicketStatus = result.TicketStatus.ticketStatusName
};
}
return(model);
}
public PNRsModel GetPNRDetail(string GDSPNR)
{
var result = _ent.PNRs.Where(x => x.GDSRefrenceNumber == GDSPNR).FirstOrDefault();
PNRsModel model = new PNRsModel();
if (result != null)
{
model = new PNRsModel
{
AgentId = result.AgentId,
AgentName = result.Agents.AgentName,
ATLTTL = result.ATLTTL.ToString(),
ContactNumber = result.ContactNumber,
CreatedBy = result.UsersDetails.AppUserId,
CreatedDate = result.CreatedDate,
DispatchedDate = result.DispatchedDate,
EmailAddress = result.EmailAddress,
FirstName = result.FirstName,
GDSRefrenceNumber = result.GDSRefrenceNumber,
IssuedDate = result.IssuedDate,
LastName = result.LastName,
MiddleName = result.MiddleName,
PNRId = result.PNRId,
Prefix = result.Prefix,
ServiceProviderId = result.ServiceProviderId,
TicketStatusId = result.TicketStatusId,
TTL = result.TTL,
Checker = result.UsersDetails.FullName,
UpdatedDate = result.UpdatedDate,
TicketStatus = result.TicketStatus.ticketStatusName,
BookedPerson = result.UsersDetails.FullName
};
}
return(model);
}
public PNRsModel GetPNRDetail(int PNRId)
{
var result = _ent.PNRs.Where(x => x.PNRId == PNRId).FirstOrDefault();
if (result == null)
{
return(GetIndianLccPNRDetail(PNRId));
}
var CreatedBystring = _ent.UsersDetails.Where(x => x.AppUserId == result.CreatedBy).FirstOrDefault();
PNRsModel model = new PNRsModel();
if (result != null)
{
model = new PNRsModel
{
AgentId = result.AgentId,
//ATLTTL = (DateTime)?result.ATLTTL,
ContactNumber = result.ContactNumber,
BookedBy = CreatedBystring.FullName,
CreatedDate = result.CreatedDate,
DispatchedDate = result.DispatchedDate,
EmailAddress = result.EmailAddress,
FirstName = result.FirstName,
GDSRefrenceNumber = result.GDSRefrenceNumber,
IssuedDate = result.IssuedDate,
LastName = result.LastName,
MiddleName = result.MiddleName,
PNRId = result.PNRId,
Prefix = result.Prefix,
ServiceProviderId = result.ServiceProviderId,
TicketStatusId = result.TicketStatusId,
TTL = result.TTL,
UpdatedBy = result.UpdatedBy,
UpdatedDate = result.UpdatedDate,
TicketStatus = result.TicketStatus.ticketStatusName
//BookedBy = result..
};
}
return(model);
}
/// <summary>
///
/// id is the PNR Id
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult PNR(int id)
{
_modPNR = _provider.GetPNRDetail(id);
return(PartialView("VUC_PNR", _modPNR));
}
public ActionResult DomesticPNR(int id)
{
_modPNR = _provider.GetIndianLccPNRDetail(id);
return(PartialView("VUC_PNR", _modPNR));
}