/// <summary>
/// Get data for Concession Letter "خطاب تنازل"
/// </summary>
/// <param name="operationId">operation id</param>
/// <param name="langCode">language code "en" or "ar"</param>
/// <returns>Concession Letter Vm</returns>
internal static ConcessionLetterVm GetConcessionLetter(int operationId, string langCode = "en")
{
ConcessionLetterVm concLetterVm = new ConcessionLetterVm();
OperationsEntities db = new OperationsEntities();
var operDb = //db.OperationViews
//.Where(x => x.OperationId == operationId)
db.HouseBillViews.Where(x => x.HouseBillId == operationId)
.Select(x => new
{
x.CarrierNameEn,
x.FromPort,
x.MBL,
x.GrossWeight,
x.CBM,
x.ConsigneeNameEn,
x.ToPort,
x.CarrierType,
x.NumberOfPackages,
x.OperationId
})
.FirstOrDefault();
concLetterVm.CarrierName = operDb.CarrierNameEn;
concLetterVm.FromPort = operDb.FromPort;
concLetterVm.MBL = operDb.MBL;
concLetterVm.GrossWeight = operDb.GrossWeight.Value;
concLetterVm.CBM = operDb.CBM == null ? 0 : operDb.CBM.Value;
concLetterVm.ConsigneeName = operDb.ConsigneeNameEn;
concLetterVm.Containers = GetContainersSummary(operDb.OperationId);
concLetterVm.NumberOfPackages = operDb.NumberOfPackages.Value;
concLetterVm.ToPort = operDb.ToPort;
if (operDb.CarrierType == 1) // sea
{
concLetterVm.StaticLabels = CommonHelper.GetStaticLabels((int)StaticTextForScreenEnum.ConcessionLetter, langCode);
}
else
{
concLetterVm.StaticLabels = CommonHelper.GetStaticLabels((int)StaticTextForScreenEnum.ConcessionLetterAir, langCode);
concLetterVm.HouseBL = db.HouseBills.Where(x => x.HouseBillId == operationId).FirstOrDefault().HouseBL;
}
if (langCode == "ar")
{
concLetterVm.CompanyName = CommonHelper.GetCompInfo().CompanyNameAr;
}
else
{
concLetterVm.CompanyName = CommonHelper.GetCompInfo().CompanyNameEn;
}
return(concLetterVm);
}
internal static ConcessionLetterVm GetDeliveryNoteInfo(int hbId, string langCode)
{
ConcessionLetterVm concLetterVm = new ConcessionLetterVm();
OperationsEntities db = new OperationsEntities();
var hbView = db.HouseBillViews.Where(x => x.HouseBillId == hbId).Select(x => new
{
x.CarrierNameEn,
x.FromPort,
x.MBL,
x.GrossWeight,
x.CBM,
x.ConsigneeNameEn,
x.ToPort,
x.CarrierType,
x.NumberOfPackages,
x.OperationId,
x.VesselName,
x.ArriveDate,
x.HouseBL,
x.GoodsDescription
}).FirstOrDefault();
int operId = hbView.OperationId;
concLetterVm.CarrierName = hbView.CarrierNameEn;
concLetterVm.FromPort = hbView.FromPort;
concLetterVm.MBL = hbView.MBL;
concLetterVm.GrossWeight = hbView.GrossWeight.Value;
concLetterVm.CBM = hbView.CBM.Value;
concLetterVm.ConsigneeName = hbView.ConsigneeNameEn;
concLetterVm.Containers = OperationHelper.GetContainersSummary(operId);
concLetterVm.NumberOfPackages = hbView.NumberOfPackages.Value;
concLetterVm.ToPort = hbView.ToPort;
concLetterVm.VesselName = hbView.VesselName;
concLetterVm.ArriveDate = hbView.ArriveDate;
concLetterVm.HouseBL = hbView.HouseBL;
concLetterVm.GoodsDescription = hbView.GoodsDescription;
var containerList = db.OperationContainers.Where(x => x.OperationId == operId).Select(x => x.ContainerNumber).ToArray();
concLetterVm.ContainerNumber = string.Join(" - ", containerList);
concLetterVm.StaticLabels = CommonHelper.GetStaticLabels((int)StaticTextForScreenEnum.DeliveryNote, langCode);
return(concLetterVm);
}
