public TradelaneGetShipmentModel GetShipmentDetail(string FrayteNumber, string FrayteType)
{
TradelaneGetShipmentModel TGS = new TradelaneGetShipmentModel();
if (FrayteType == "FrayteRefNo")
{
var Shipment = dbContext.TradelaneShipments.Where(x => x.FrayteNumber == FrayteNumber).FirstOrDefault();
if (Shipment != null)
{
TGS.TradelaneShipmentId = Shipment.TradelaneShipmentId;
}
}
else if (FrayteType == "Mawb")
{
var MawbRes = GetMawbStr(FrayteNumber);
var Mawb = MawbRes.Item1;
var AirlineId = MawbRes.Item2;
if (!string.IsNullOrEmpty(AirlineId))
{
var Airline = dbContext.Airlines.Where(a => a.AirlineCode == AirlineId).FirstOrDefault();
var Shipment = dbContext.TradelaneShipments.Where(x => x.MAWB == Mawb && x.AirlineId == Airline.AirlineId).FirstOrDefault();
if (Shipment != null)
{
TGS.TradelaneShipmentId = Shipment.TradelaneShipmentId;
}
}
else
{
var Shipment = dbContext.TradelaneShipments.Where(x => x.MAWB == Mawb).FirstOrDefault();
if (Shipment != null)
{
TGS.TradelaneShipmentId = Shipment.TradelaneShipmentId;
}
}
}
return(TGS);
}
public List <TradelaneGetShipmentModel> GetTradelaneShipments(TradelaneTrackDirectBooking track)
{
List <TradelaneGetShipmentModel> ShipmentList = new List <TradelaneGetShipmentModel>();
if (track != null)
{
FrayteOperationZone OperationZone = UtilityRepository.GetOperationZone();
int RoleId = dbContext.UserRoles.Where(p => p.UserId == (track.UserId > 0 ? track.UserId : track.CustomerId)).FirstOrDefault().RoleId;
int TotalRows = 0;
int SkipRows = 0;
SkipRows = (track.CurrentPage - 1) * track.TakeRows;
DateTime?fromdate;
DateTime?todate;
var Airline = "";
if (track.FromDate.HasValue)
{
fromdate = track.FromDate.Value;
}
else
{
fromdate = track.FromDate;
}
if (track.ToDate.HasValue)
{
todate = track.ToDate.Value;
}
else
{
todate = track.ToDate;
}
if (track.MAWB != null && track.MAWB != "")
{
var Result1 = GetMawbStr(track.MAWB);
track.MAWB = Result1.Item1;
Airline = Result1.Item2;
}
var Result = dbContext.spGet_TradelaneTrackAndTraceDetail(track.MAWB, fromdate, todate, track.ShipmentStatusId, track.FrayteNumber, SkipRows, track.TakeRows, track.CustomerId, track.UserId, OperationZone.OperationZoneId, RoleId, track.SpecialSearchId, Airline).ToList();
foreach (var res in Result)
{
var STCode = "";
TradelaneGetShipmentModel Shipment = new TradelaneGetShipmentModel();
Shipment.DepartureAirport = res.DepartureAirport;
Shipment.DestinationAirport = res.DestinationAirport;
Shipment.CustomerId = res.CustomerId;
Shipment.CreatedOn = res.CreatedOnUtc.Date;
Shipment.Customer = res.ContactName;
Shipment.IsAgentMAWBAllocated = res.IsAgentMAWBAllocated != null ? res.IsAgentMAWBAllocated.Value : false;
Shipment.MAWBAgentId = res.MAWBAgentId != null ? res.MAWBAgentId.Value : 0;
Shipment.TradelaneShipmentId = res.TradelaneShipmentId;
STCode = !string.IsNullOrEmpty(res.ShipmentHandlerMethodCode) ? " (" + res.ShipmentHandlerMethodCode + ')' : "";
Shipment.Status = res.StatusName;
Shipment.StatusDisplay = res.DisplayStatusName + STCode;
Shipment.MAWB = res.MAWB;
Shipment.TotalWeight = res.TotalWeight != null ? res.TotalWeight.Value : 0;
Shipment.TotalCarton = res.TotalCartons != null ? res.TotalCartons.Value : 0;
Shipment.TotalRows = res.TotalRows.Value;
ShipmentList.Add(Shipment);
}
return(ShipmentList.OrderBy(a => a.Status).ToList());
}
return(ShipmentList);
}
