public static List <OperationContainerVm> GetOperationContainers(int id) { OperationsEntities db = new OperationsEntities(); Dictionary <int, string> contList = ListCommonHelper.GetContainerList(); Dictionary <int, string> packageList = ListCommonHelper.GetPackageTypeList(); List <OperationContainerVm> oprContainers = new List <OperationContainerVm>(); var operConDb = db.OperationContainers.Where(x => x.OperationId == id).ToList(); Mapper.CreateMap <OperationContainer, OperationContainerVm>().IgnoreAllNonExisting(); Mapper.Map(operConDb, oprContainers); foreach (var item in oprContainers) { try { item.ContainerTypeName = contList[item.ContainerTypeId]; } catch { } if (item.PackageTypeId != null) { item.PackageTypeName = packageList[item.PackageTypeId.Value]; } } if (oprContainers.Count == 0) { OperationContainerVm operContObj = new OperationContainerVm(); oprContainers.Add(operContObj); } return(oprContainers); }
/// <summary> /// Get container summary for operation /// </summary> /// <param name="operationId">int operation id</param> /// <returns>string like 2x20' 4xLCL 3x40'</returns> internal static string GetContainersSummary(int operationId) { OperationsEntities db = new OperationsEntities(); var contList = db.OperationContainers.Where(x => x.OperationId == operationId) .GroupBy(x => x.ContainerTypeId, (key, values) => new { ContainerTypeId = key, count = values.Count() }).ToList(); Dictionary <int, string> containerTypeList = ListCommonHelper.GetContainerList(); StringBuilder result = new StringBuilder(); foreach (var item in contList) { if (item.ContainerTypeId == 0) { result.Append("Air Container"); } else { result.Append(containerTypeList[item.ContainerTypeId]); } result.Append("x"); result.Append(item.count); result.Append(" "); } return(result.ToString()); }
internal static List <QuotationContainerVm> GetQuotationContainers(int id) { OperationsEntities db = new OperationsEntities(); Dictionary <int, string> contList = ListCommonHelper.GetContainerList(); List <QuotationContainerVm> quoteContainers = new List <QuotationContainerVm>(); var qouteConDb = db.QuotationContainers.Where(x => x.QuoteId == id).ToList(); Mapper.CreateMap <QuotationContainer, QuotationContainerVm>().IgnoreAllNonExisting(); Mapper.Map(qouteConDb, quoteContainers); foreach (var item in quoteContainers) { if (item.ContainerTypeId != 0) { item.ContainerTypeName = contList[item.ContainerTypeId.Value]; } else { item.ContainerTypeName = "Air"; } } return(quoteContainers); }