/// <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); }