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