/// <summary>
/// Get list of CustomClearanceDetailVm
/// </summary>
/// <param name="custClearId">Custom Clearance Id</param>
/// <returns>CustomClearanceDetailVm List</returns>
internal static CustomClearanceDetailMainVm GetCustClearDetailList(int custClearId)
{
List <CustomClearanceDetailVm> cusClearDetailList = new List <CustomClearanceDetailVm>();
OperationsEntities db = new OperationsEntities();
var custDbList = db.CustomClearanceDetails.Where(x => x.CCId == custClearId).ToList();
if (custDbList.Count == 0)
{
CustomClearanceDetailVm custClearDetObj = new CustomClearanceDetailVm {
CCId = custClearId
};
cusClearDetailList.Add(custClearDetObj);
}
else
{
Mapper.CreateMap <CustomClearanceDetail, CustomClearanceDetailVm>().IgnoreAllNonExisting();
Mapper.Map(custDbList, cusClearDetailList);
}
CustomClearanceDetailMainVm custClearDetMain = new CustomClearanceDetailMainVm();
custClearDetMain.CustomClearanceDetailVms.AddRange(cusClearDetailList);
return(custClearDetMain);
}
internal static OperationView GetOne(int id)
{
OperationsEntities db = new OperationsEntities();
OperationView operationView = db.OperationViews.Where(x => x.OperationId == id).FirstOrDefault();
return(operationView);
}
internal static CustomClearVm GetCustomClearance(int operationId, int houseBillId)
{
CustomClearVm custClearVm = new CustomClearVm(operationId, houseBillId);
OperationsEntities db = new OperationsEntities();
//Get operation status
byte oprStatus = db.HouseBills.Where(x => x.HouseBillId == houseBillId).FirstOrDefault().StatusId;
CustomClearanceOrder custClearDb;
if (oprStatus == 3 || oprStatus == 4)
{
custClearDb = db.CustomClearanceOrders
.Where(x => x.HouseBillId == houseBillId && (x.StatusId == 3 || x.StatusId == 4)).FirstOrDefault();
}
else
{
custClearDb = db.CustomClearanceOrders
.Where(x => x.HouseBillId == houseBillId && (x.StatusId == 1 || x.StatusId == 2)).FirstOrDefault();
}
if (custClearDb != null)
{
Mapper.CreateMap <CustomClearanceOrder, CustomClearVm>().IgnoreAllNonExisting();
Mapper.Map(custClearDb, custClearVm);
}
return(custClearVm);
}
/// <summary>
/// Close CC order .. change statusId = 3
/// </summary>
/// <param name="ccId"></param>
/// <returns>string "true" if success</returns>
internal static string CloseCC(int ccId, byte statusId)
{
string isClosed = "true";
OperationsEntities db = new OperationsEntities();
var ccOrder = db.CustomClearanceOrders.Where(x => x.CCId == ccId).FirstOrDefault();
if (statusId == 4) //cancel from HB will delete the record
{
db.CustomClearanceOrders.Remove(ccOrder);
}
else
{
ccOrder.StatusId = statusId;
}
try
{
db.SaveChanges();
}
catch (DbEntityValidationException e)
{
isClosed = "false " + e.Message;
}
catch (Exception e)
{
isClosed = "false " + e.InnerException;
}
return(isClosed);
}
internal static int GetHBCount(int operationId)
{
OperationsEntities db = new OperationsEntities();
int count = db.HouseBills.Where(x => x.OperationId == operationId).Count();
return(count);
}
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 one row from CustomClearanceView
/// </summary>
/// <param name="id">Custom Clearance Id</param>
/// <returns>CustomClearanceView object</returns>
internal static CustomClearanceView GetOneCustClearView(int ccId)
{
OperationsEntities db = new OperationsEntities();
CustomClearanceView custClearObj = db.CustomClearanceViews.Where(x => x.CCId == ccId).FirstOrDefault();
return(custClearObj);
}
internal static string ChangeHBStatus(int hbId, byte statusId)
{
string isClosed = "true";
OperationsEntities db = new OperationsEntities();
int operCostCount = db.OperationCosts.Where(x => x.HouseBillId == hbId).Count();
if (operCostCount == 0)
{
return("Please add operation cost before close it.");
}
HouseBill hbObj = db.HouseBills.Where(x => x.HouseBillId == hbId).FirstOrDefault();
hbObj.StatusId = statusId; //closed
try
{
db.SaveChanges();
}
catch (DbEntityValidationException e)
{
isClosed = "false " + e.Message;
}
catch (Exception e)
{
isClosed = "false " + e.InnerException;
}
return(isClosed);
}
public static HouseBillView GetHBViewInfo(int hbId)
{
OperationsEntities db = new OperationsEntities();
HouseBillView hbView = db.HouseBillViews.Where(x => x.HouseBillId == hbId).FirstOrDefault();
return(hbView);
}
public static QuotationVm GetQuotationInfo(int quotationId, byte orderFrom)
{
QuotationVm quotationVm = new QuotationVm(orderFrom);
if (quotationId == 0)
{
QuotationContainerVm quotContVm = new QuotationContainerVm();
quotationVm.QuotationContainers.Add(quotContVm);
}
else
{
OperationsEntities db = new OperationsEntities();
var quotDb = db.Quotations.Include("QuotationContainers")
.Where(x => x.QuoteId == quotationId).FirstOrDefault();
Mapper.CreateMap <Quotation, QuotationVm>().IgnoreAllNonExisting();
Mapper.CreateMap <QuotationContainer, QuotationContainerVm>().IgnoreAllNonExisting();
Mapper.Map(quotDb, quotationVm);
if (quotationVm.QuotationContainers.Count == 0)
{
QuotationContainerVm quotContVm = new QuotationContainerVm();
quotationVm.QuotationContainers.Add(quotContVm);
}
}
return(quotationVm);
}
public static QuotationView GetOneQuote(int id)
{
OperationsEntities db = new OperationsEntities();
QuotationView quoteView = db.QuotationViews.Where(x => x.QuoteId == id).FirstOrDefault();
return(quoteView);
}
internal static List <OperationCostLib> GetOperationCostLib()
{
OperationsEntities db = new OperationsEntities();
List <OperationCostLib> costLib = db.OperationCostLibs.ToList();
return(costLib);
}
internal static string AddEditOperationCost(int costId, string costNameEn, string costNameAr)
{
string isSaved = "true";
OperationsEntities db = new OperationsEntities();
OperationCostLib costDb;
if (costId == 0)
{
costDb = new OperationCostLib();
}
else
{
costDb = db.OperationCostLibs.Where(x => x.OperCostLibId == costId).FirstOrDefault();
}
costDb.OperCostNameEn = costNameEn;
costDb.OperCostNameAr = costNameAr;
if (costId == 0)
{
db.OperationCostLibs.Add(costDb);
}
try
{
db.SaveChanges();
}
catch (Exception ex)
{
isSaved = "false" + ex.Message;
}
return(isSaved);
}
internal static string DeleteCCCost(int id)
{
OperationsEntities db = new OperationsEntities();
string isDeleted = "true";
var costObj = db.CustomClearanceCostLibs.Where(x => x.CCCostId == id).FirstOrDefault();
db.CustomClearanceCostLibs.Remove(costObj);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
if ((ex.InnerException).InnerException.Message.Contains("DELETE statement conflicted"))
{
isDeleted = "false. Can't delete this row as it is linked with some operation orders";
}
else
{
isDeleted = "false" + ex.Message;
}
}
return(isDeleted);
}
internal static List <CustomClearanceCostLib> GetCCCostLib()
{
OperationsEntities db = new OperationsEntities();
List <CustomClearanceCostLib> costLib = db.CustomClearanceCostLibs.ToList();
return(costLib);
}
public static string GetCCCashDepAccountId(int operationId)
{
OperationsEntities db = new OperationsEntities();
string accId = db.Operations.Where(x => x.OperationId == operationId).FirstOrDefault().CCCashDepAccountId;
return(accId);
}
private static int GetOperationCostCount(int operationId)
{
OperationsEntities db = new OperationsEntities();
int count = db.OperationCosts.Where(x => x.OperationId == operationId).Count();
return(count);
}
/// <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 OperationCostMainVm GetHBCost(int houseBillId)
{
OperationsEntities db = new OperationsEntities();
var operCostDb = db.OperationCosts.Where(x => x.HouseBillId == houseBillId && x.IsAccounting == true).ToList();
OperationCostMainVm operCostMainVm = new OperationCostMainVm();
if (operCostDb.Count == 0)
{
OperationCostVm operCostVm = new OperationCostVm()
{
HouseBillId = houseBillId
};
operCostMainVm.OperationCosts.Add(operCostVm);
}
else
{
OperationCostVm operCostVm;
Mapper.CreateMap <OperationCost, OperationCostVm>().IgnoreAllNonExisting();
foreach (var item in operCostDb)
{
operCostVm = new OperationCostVm();
Mapper.Map(item, operCostVm);
//if operation id = 0 .. view mode .. load all data
var costLib = item.OperationCostLib;
operCostVm.OperCostNameEn = costLib.OperCostNameEn;
operCostVm.OperCostNameAr = costLib.OperCostNameAr;
operCostVm.CurrencySign = item.Currency.CurrencySign;
operCostMainVm.OperationCosts.Add(operCostVm);
}
OperationCostTotalsVm costTotals;
var totalsObj = operCostMainVm.OperationCosts.GroupBy(g => g.CurrencySign)
.Select(x => new
{
CurrSign = x.Key,
TotalSelling = x.Sum(g => g.OperationCostSelling),
TotalNet = x.Sum(g => g.OperationCostNet)
}).ToList();
foreach (var item in totalsObj)
{
costTotals =
new OperationCostTotalsVm()
{
CurrencySign = item.CurrSign,
TotalCostNet = item.TotalNet,
TotalCostSelling = item.TotalSelling
};
operCostMainVm.Totals.Add(costTotals);
}
}
return(operCostMainVm);
}
//public static OperationStatisticVm GetOperationStatistics(System.Web.Mvc.FormCollection form)
//{
//OperationsEntities db5 = new OperationsEntities();
//var operationList = db5.OperationViews.Where(f => f.OrderFrom == orderFrom &&
// (f.OperationDate >= fromDate && f.OperationDate <= toDate))
// .Select(x => new
// {
// x.OperationId,
// x.CarrierType,
// x.QuoteId,
// x.CreateDate,
// x.OperationCode,
// x.ShipperNameEn,
// x.ConsigneeNameEn,
// x.CarrierNameEn,
// x.FromPort,
// x.ToPort,
// x.DateOfDeparture,
// x.StatusName,
// x.StatusId,
// x.IsConsolidation,
// x.OrderFrom,
// x.AgentNameEn
// })
// .ToList();
// OperationsEntities db = new OperationsEntities();
// OperationStatisticVm operationStatistic = new OperationStatisticVm() ;
// int orderfrom = string.IsNullOrEmpty(form["OrderFrom"])? 1:int.Parse(form["OrderFrom"]);
// DateTime fromDate = string.IsNullOrEmpty(form["FromDate"]) ? DateTime.Now.AddDays(-7) : DateTime.Parse(form["FromDate"]);
// DateTime toDate = string.IsNullOrEmpty(form["ToDate"]) ? DateTime.Now.AddDays(-7) : DateTime.Parse(form["ToDate"]);
// operationStatistic = GetOperationStatistics(fromDate, toDate, orderfrom);
// return operationStatistic;
//}
internal static string DeleteOperation(int operationId)
{
string isClosed = "true";
OperationsEntities db = new OperationsEntities();
int statusId = db.Operations.Where(d => d.OperationId == operationId).FirstOrDefault().StatusId;
if (statusId > 2)
{
isClosed = "false Cannot delete this operation it may be Closed or Invoice Issued ";
return(isClosed);
}
// delete all HB under this operation
var hbList = db.HouseBills.Where(x => x.OperationId == operationId);// && (x.StatusId == 1 || x.StatusId == 2));
foreach (var item in hbList)
{
item.StatusId = 4; //canceled
}
// delete all Custom Clearance under this operation
var ccList = db.CustomClearanceOrders.Where(x => x.OperationId == operationId);// && (x.StatusId == 1 || x.StatusId == 2));
foreach (var item in ccList)
{
item.StatusId = 4; //canceled
}
// Delete all Trucking orders
EasyFreightEntities dbE = new EasyFreightEntities();
var truckList = dbE.TruckingOrders.Where(x => x.OperationId == operationId);// && (x.StatusId == 1 || x.StatusId == 2));
foreach (var item in truckList)
{
item.StatusId = 4; //canceled
}
var operation = db.Operations.Where(x => x.OperationId == operationId).FirstOrDefault();
operation.StatusId = 4;
try
{
db.SaveChanges();
dbE.SaveChanges();
}
catch (DbEntityValidationException e)
{
isClosed = "false " + e.Message;
}
catch (Exception e)
{
isClosed = "false " + e.InnerException;
}
return(isClosed);
}
//kamal
internal static HouseBillListVm GetHbContent(int hbId)
{
OperationsEntities db = new OperationsEntities();
HouseBillListVm hbList = db.HouseBills
.Where(x => x.HouseBillId == hbId)
.Select(x => new HouseBillListVm
{
HouseBillId = x.HouseBillId,
OperationCode = x.OperationCode,
OperationDate = x.OperationDate,
ShipperId = x.ShipperId,
ConsigneeId = x.ConsigneeId,
HouseBL = x.HouseBL,
ClientName = "",
NumberOfPackages = x.NumberOfPackages,
OperationId = x.OperationId,
CarrierType = x.Operation.CarrierType,
StatusId = x.StatusId,
FreightCostAmount = x.CollectedFreightCost,
ThcCostAmount = x.CollectedThcCost,
FreighCurrencySign = x.Currency1.CurrencySign,
ThcCurrencySign = x.Currency.CurrencySign,
AgentId = x.AgentId
})
.FirstOrDefault();
Operation operationDb = db.Operations.Where(x => x.OperationId == hbList.OperationId).FirstOrDefault();
EasyFreightEntities db1 = new EasyFreightEntities();
if (operationDb.OrderFrom == 1) //Export .. client will be the shipper
{
var shipperList = db1.Shippers
.Where(x => x.ShipperId == hbList.ShipperId)
.Select(x => new { x.ShipperId, x.ShipperNameEn, x.ShipperNameAr }).ToList();
hbList.ClientName = shipperList.Where(x => x.ShipperId == hbList.ShipperId).FirstOrDefault().ShipperNameEn;
}
else //Export .. client will be consignee
{
//List<int> consigneeIds = hbList.Select(x => x.ConsigneeId).ToList();
var consigneeList = db1.Consignees
.Where(x => x.ConsigneeId == hbList.ConsigneeId)
.Select(x => new { x.ConsigneeId, x.ConsigneeNameEn, x.ConsigneeNameAr }).ToList();
hbList.ClientName = consigneeList.Where(x => x.ConsigneeId == hbList.ConsigneeId).FirstOrDefault().ConsigneeNameEn;
}
return(hbList);
}
/// <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);
}
/// <summary>
/// Check If any transportation or CC is opened for this operation
/// .. if so will show message that is must be closed first
/// </summary>
/// <param name="operationId"></param>
/// <returns></returns>
private static bool CheckOpenedOperationTransactions(int operationId)
{
bool isOpened = false;
EasyFreightEntities db1 = new EasyFreightEntities();
isOpened = db1.TruckingOrders.Any(x => x.OperationId == operationId && (x.StatusId == 1 || x.StatusId == 2));
if (!isOpened)
{
OperationsEntities db = new OperationsEntities();
isOpened = db.CustomClearanceOrders.Any(x => x.OperationId == operationId && (x.StatusId == 1 || x.StatusId == 2));
}
return(isOpened);
}
public static string DeleteTruckingOrder(int truckingOrderId)
{
string isSaved = "true";
EasyFreightEntities db = new EasyFreightEntities();
OperationsEntities db1 = new OperationsEntities();
TruckingOrder orderDb;
List <TruckingOrderDetail> orderDetailsDb;
List <TruckingOrderCost> orderCostDb;
orderDb = db.TruckingOrders.Where(x => x.TruckingOrderId == truckingOrderId).FirstOrDefault();
int houseBillStatusID = db1.HouseBills.Where(c => c.HouseBillId == orderDb.HouseBillId).FirstOrDefault().StatusId;
if (houseBillStatusID == 3 || houseBillStatusID == 6)
{
return("false " + "Cannot delete this trucking. The house bill is closed");
}
//cancel from HB will delete the record
db.TruckingOrders.Remove(orderDb);
orderDetailsDb = db.TruckingOrderDetails.Where(x => x.TruckingOrderId == truckingOrderId).ToList();
foreach (var item in orderDetailsDb)
{
db.TruckingOrderDetails.Remove(item);
}
orderCostDb = db.TruckingOrderCosts.Where(x => x.TruckingOrderId == truckingOrderId).ToList();
foreach (var item in orderCostDb)
{
db.TruckingOrderCosts.Remove(item);
}
try
{
db.SaveChanges();
}
catch (DbEntityValidationException e)
{
isSaved = "false " + e.Message;
}
catch (Exception e)
{
isSaved = "false " + e.Message;
}
return(isSaved);
}
/// <summary>
/// Close operation and all related HB
/// </summary>
/// <param name="operationId"></param>
/// <returns></returns>
internal static string CloseOperation(int operationId)
{
string isClosed = "true";
int operCostCount = GetOperationCostCount(operationId);
if (operCostCount == 0)
{
return("Please add operation cost before close it.");
}
bool isTransOpened = CheckOpenedOperationTransactions(operationId);
if (isTransOpened)
{
return("Transportation or Custom Clearance orders are opened. Please close them first");
}
OperationsEntities db = new OperationsEntities();
bool anyHbIsOpended = db.HouseBills.Any(x => x.OperationId == operationId && (x.StatusId == 1 || x.StatusId == 2));
if (anyHbIsOpended)
{
var hbList = db.HouseBills.Where(x => x.OperationId == operationId && (x.StatusId == 1 || x.StatusId == 2));
foreach (var item in hbList)
{
item.StatusId = 3;
}
}
var operation = db.Operations.Where(x => x.OperationId == operationId).FirstOrDefault();
operation.StatusId = 3;
try
{
db.SaveChanges();
}
catch (DbEntityValidationException e)
{
isClosed = "false " + e.Message;
}
catch (Exception e)
{
isClosed = "false " + e.InnerException;
}
return(isClosed);
}
public static OperationStatisticVm GetOperationStatistics(DateTime fromDate, DateTime toDate, int?orderFrom)
{
/* */
OperationsEntities db5 = new OperationsEntities();
var operationList = db5.OperationViews.Where(f => f.OrderFrom == orderFrom &&
(f.OperationDate >= fromDate && f.OperationDate <= toDate))
.GroupBy(f => f.ShipperId)
.Select(x => new
{
ShipperId = x.Key,
OperationCount = x.Count(),
TotalCBM = x.Sum(f => f.CBM),
TotalWeight = x.Sum(f => f.NetWeight),
ShipperNameEn = x.Max(r => r.ShipperNameEn)
//x.ShipperId,
//x.OperationId,
//x.CarrierType,
//x.QuoteId,
//x.CreateDate,
//x.OperationCode,
//x.ShipperNameEn,
//x.ConsigneeNameEn,
//x.CarrierNameEn,
//x.FromPort,
//x.ToPort,
//x.DateOfDeparture,
//x.StatusName,
//x.StatusId,
//x.IsConsolidation,
//x.OrderFrom,
//x.AgentNameEn
})
.Take(5)
.OrderByDescending(y => y.OperationCount)
.ThenBy(s => s.TotalWeight)
.ToList();
var ee = operationList;
/* */
OperationsEntities db = new OperationsEntities();
OperationStatisticVm operationStatistic = new OperationStatisticVm();
GetOperationStatistics_Result spResult = db.GetOperationStatistics(orderFrom, fromDate, toDate).FirstOrDefault();
Mapper.CreateMap <GetOperationStatistics_Result, OperationStatisticVm>().IgnoreAllNonExisting();
Mapper.Map(spResult, operationStatistic);
return(operationStatistic);
}
internal static List <CustomClearanceListVm> GetCCOrdersList(int operationId, byte orderFrom)
{
OperationsEntities db = new OperationsEntities();
EasyFreightEntities db1 = new EasyFreightEntities();
List <CustomClearanceListVm> ccOrdersList = db.CustomClearanceOrders.Include("HouseBill")
.Where(x => x.OperationId == operationId)
.Select(x => new CustomClearanceListVm
{
CCId = x.CCId,
ConsigneeId = x.HouseBill.ConsigneeId,
HouseBillId = x.HouseBillId,
HouseBL = x.HouseBill.HouseBL,
NeedArriveDate = x.NeedArriveDate,
NeedArriveTime = x.NeedArriveTime,
NumberOfPackages = x.HouseBill.NumberOfPackages,
OperationCode = x.HouseBill.OperationCode,
ShipperId = x.HouseBill.ShipperId,
OperationId = x.OperationId,
StatusId = x.StatusId
}).ToList();
if (orderFrom == 1) //Export .. client will be the shipper
{
List <int> shipperIds = ccOrdersList.Select(x => x.ShipperId).ToList();
var shipperList = db1.Shippers
.Where(x => shipperIds.Contains(x.ShipperId))
.Select(x => new { x.ShipperId, x.ShipperNameEn, x.ShipperNameAr }).ToList();
foreach (var item in ccOrdersList)
{
item.ClientName = shipperList.Where(x => x.ShipperId == item.ShipperId).FirstOrDefault().ShipperNameEn;
}
}
else //Export .. client will be consignee
{
List <int> consigneeIds = ccOrdersList.Select(x => x.ConsigneeId).ToList();
var consigneeList = db1.Consignees
.Where(x => consigneeIds.Contains(x.ConsigneeId))
.Select(x => new { x.ConsigneeId, x.ConsigneeNameEn, x.ConsigneeNameAr }).ToList();
foreach (var item in ccOrdersList)
{
item.ClientName = consigneeList.Where(x => x.ConsigneeId == item.ConsigneeId).FirstOrDefault().ConsigneeNameEn;
}
}
return(ccOrdersList);
}
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);
}
public static TruckingOrderVm NewTruckingOrderByOperation(int operationId, byte orderFrom = 1, int houseBillId = 0)
{
EasyFreightEntities db = new EasyFreightEntities();
OperationsEntities db1 = new OperationsEntities();
TruckingOrderVm trkoVmObj = new TruckingOrderVm(orderFrom);
//Get House Bill status
var hbInfo = db1.HouseBills.Where(x => x.HouseBillId == houseBillId)
.Select(x => new { x.StatusId, x.OperationDate }).FirstOrDefault();
//Check if has trucking order .. Get its details for edit
TruckingOrder truckingOrderDb;
if (hbInfo.StatusId == 3 || hbInfo.StatusId == 4)
{
truckingOrderDb = db.TruckingOrders
.Where(x => x.HouseBillId == houseBillId && (x.StatusId == 3 || x.StatusId == 4)).FirstOrDefault();
}
else
{
truckingOrderDb = db.TruckingOrders
.Where(x => x.HouseBillId == houseBillId && (x.StatusId == 1 || x.StatusId == 2)).FirstOrDefault();
}
if (truckingOrderDb != null)
{
Mapper.CreateMap <TruckingOrder, TruckingOrderVm>().IgnoreAllNonExisting();
Mapper.Map(truckingOrderDb, trkoVmObj);
trkoVmObj.OperationDate = hbInfo.OperationDate.Value;
}
else
{
var houseBillVm = HouseBillHelper.GetHbContent(operationId, orderFrom, houseBillId);
Mapper.CreateMap <HouseBillVm, TruckingOrderVm>()
.ForMember(x => x.StatusId, y => y.Ignore())
.IgnoreAllNonExisting();
Mapper.Map(houseBillVm, trkoVmObj);
trkoVmObj.BookingNo = db1.Operations.Where(x => x.OperationId == operationId)
.FirstOrDefault().BookingNumber;
}
return(trkoVmObj);
}
internal static string AddEditHouseBill(HouseBillVm houseBillVm)
{
string isSaved = "true";
int houseBillId = houseBillVm.HouseBillId;
OperationsEntities db = new OperationsEntities();
HouseBill houseBillDb;
if (houseBillId == 0)
{
houseBillDb = new HouseBill();
}
else
{
houseBillDb = db.HouseBills.Where(x => x.HouseBillId == houseBillId).FirstOrDefault();
}
Mapper.CreateMap <HouseBillVm, HouseBill>().IgnoreAllNonExisting();
Mapper.Map(houseBillVm, houseBillDb);
if (houseBillId == 0)
{
db.HouseBills.Add(houseBillDb);
int operationId = houseBillDb.OperationId;
Operation operationObj = db.Operations.Where(x => x.OperationId == operationId).FirstOrDefault();
operationObj.StatusId = 2;
}
try
{
db.SaveChanges();
isSaved = "true_" + houseBillDb.HouseBillId;
}
catch (DbEntityValidationException e)
{
isSaved = "false " + e.InnerException.InnerException;
}
catch (Exception e)
{
isSaved = "false " + e.InnerException.InnerException;
}
return(isSaved);
}
