private ViewModel_Tariff GetTariffData()
{
_tariffLogic = new Lms_TariffLogic(_cache, new EntityFrameworkGenericRepository <Lms_TariffPoco>(_dbContext));
_cityLogic = new App_CityLogic(_cache, new EntityFrameworkGenericRepository <App_CityPoco>(_dbContext));
_deliveryOptionLogic = new Lms_DeliveryOptionLogic(_cache, new EntityFrameworkGenericRepository <Lms_DeliveryOptionPoco>(_dbContext));
_vehicleTypeLogic = new Lms_VehicleTypeLogic(_cache, new EntityFrameworkGenericRepository <Lms_VehicleTypePoco>(_dbContext));
_unitTypeLogic = new Lms_UnitTypeLogic(_cache, new EntityFrameworkGenericRepository <Lms_UnitTypePoco>(_dbContext));
_weightScaleLogic = new Lms_WeightScaleLogic(_cache, new EntityFrameworkGenericRepository <Lms_WeightScalePoco>(_dbContext));
ViewModel_Tariff tariffViewModel = new ViewModel_Tariff();
tariffViewModel.Tariffs = _tariffLogic.GetList();
tariffViewModel.Cities = _cityLogic.GetList();
tariffViewModel.DeliveryOptions = _deliveryOptionLogic.GetList();
tariffViewModel.VehicleTypes = _vehicleTypeLogic.GetList();
tariffViewModel.UnitTypes = _unitTypeLogic.GetList();
tariffViewModel.WeightScales = _weightScaleLogic.GetList();
return(tariffViewModel);
}
private List <ViewModel_SearchResult_Order> GetOrdersByQuery(string filteredData)
{
List <ViewModel_SearchResult_Order> searchResults = new List <ViewModel_SearchResult_Order>();
JObject queryData = new JObject();
string fromDate = "", toDate = "", optionForWaybill = "", waybillNumber = "", optionForBillTo = "", billToCustomerName = "", optionForShipper = "",
shipperCustomerName = "", optionForCctn = "", cctnRef = "", optionForActn = "", actnRef = "", optionForConsignee = "",
consigneeCustomerName = "", optionForDelRef = "", delRef = "", optionForPuRef = "", puRef = "", optionForOrderBy = "",
orderBy = "", optionForBolRef = "", bolRef = "", optionForProRef = "", proRef = "", optionForCustomerRef = "", customerRef = "";
if (filteredData != string.Empty)
{
queryData = JObject.Parse(filteredData);
fromDate = queryData.SelectToken("fromDate").ToString();
toDate = queryData.SelectToken("toDate").ToString();
optionForWaybill = queryData.SelectToken("optionForWaybill").ToString();
waybillNumber = queryData.SelectToken("waybillNumber").ToString();
optionForBillTo = queryData.SelectToken("optionForBillTo").ToString();
billToCustomerName = queryData.SelectToken("billToCustomerName").ToString();
optionForShipper = queryData.SelectToken("optionForShipper").ToString();
shipperCustomerName = queryData.SelectToken("shipperCustomerName").ToString();
optionForCctn = queryData.SelectToken("optionForCctn").ToString();
cctnRef = queryData.SelectToken("cctnRef").ToString();
optionForActn = queryData.SelectToken("optionForActn").ToString();
actnRef = queryData.SelectToken("actnRef").ToString();
optionForConsignee = queryData.SelectToken("optionForConsignee").ToString();
consigneeCustomerName = queryData.SelectToken("consigneeCustomerName").ToString();
optionForDelRef = queryData.SelectToken("optionForDelRef").ToString();
delRef = queryData.SelectToken("delRef").ToString();
optionForPuRef = queryData.SelectToken("optionForPuRef").ToString();
puRef = queryData.SelectToken("puRef").ToString();
optionForOrderBy = queryData.SelectToken("optionForOrderBy").ToString();
orderBy = queryData.SelectToken("orderBy").ToString();
optionForBolRef = queryData.SelectToken("optionForBolRef").ToString();
bolRef = queryData.SelectToken("bolRef").ToString();
optionForProRef = queryData.SelectToken("optionForProRef").ToString();
proRef = queryData.SelectToken("proRef").ToString();
optionForCustomerRef = queryData.SelectToken("optionForCustomerRef").ToString();
customerRef = queryData.SelectToken("customerRef").ToString();
}
var orders = _orderLogic.GetList().Where(c => c.OrderTypeId == 1 && (c.TotalOrderCost + c.TotalAdditionalServiceCost) > 0).ToList();
List <Lms_CustomerPoco> customers = new List <Lms_CustomerPoco>();
customers = _customerLogic.GetList();
if (fromDate != "" && toDate != "")
{
orders = orders.Where(c => c.ScheduledPickupDate >= Convert.ToDateTime(fromDate) && c.ScheduledPickupDate <= Convert.ToDateTime(toDate)).ToList();
}
if (waybillNumber.Trim() != "")
{
if (optionForWaybill == "1")
{
orders = orders.Where(c => c.WayBillNumber.Equals(waybillNumber.Trim())).ToList();
}
else if (optionForWaybill == "2")
{
orders = orders.Where(c => c.WayBillNumber.Contains(waybillNumber.Trim())).ToList();
}
}
if (customerRef.Trim() != "")
{
if (optionForCustomerRef == "1")
{
orders = orders.Where(c => c.ReferenceNumber != null && c.ReferenceNumber.ToUpper().Equals(customerRef.ToUpper())).ToList();
}
else if (optionForCustomerRef == "2")
{
orders = orders.Where(c => c.ReferenceNumber != null && c.ReferenceNumber.ToUpper().Contains(customerRef.ToUpper())).ToList();
}
}
if (billToCustomerName.Trim() != "")
{
if (optionForBillTo == "1")
{
customers = new List <Lms_CustomerPoco>();
customers = _customerLogic.GetList().Where(c => c.CustomerName.Equals(billToCustomerName.ToUpper())).OrderBy(c => c.Id).ToList();
orders = orders.Where(c => customers.Any(d => d.Id == c.BillToCustomerId)).ToList();
}
else if (optionForBillTo == "2")
{
customers = new List <Lms_CustomerPoco>();
customers = _customerLogic.GetList().Where(c => c.CustomerName.ToUpper().Contains(billToCustomerName.ToUpper())).OrderBy(c => c.Id).ToList();
orders = orders.Where(c => customers.Any(d => d.Id == c.BillToCustomerId)).ToList();
}
}
if (shipperCustomerName.Trim() != "")
{
if (optionForShipper == "1")
{
customers = new List <Lms_CustomerPoco>();
customers = _customerLogic.GetList().Where(c => c.CustomerName.ToUpper().Equals(shipperCustomerName.ToUpper())).OrderBy(c => c.Id).ToList();
orders = orders.Where(c => customers.Any(d => c.ShipperCustomerId != null && d.Id == c.ShipperCustomerId)).ToList();
}
else if (optionForShipper == "2")
{
customers = new List <Lms_CustomerPoco>();
customers = _customerLogic.GetList().Where(c => c.CustomerName.ToUpper().Contains(shipperCustomerName.ToUpper())).OrderBy(c => c.Id).ToList();
orders = orders.Where(c => customers.Any(d => c.ShipperCustomerId != null && d.Id == c.ShipperCustomerId)).ToList();
}
}
if (consigneeCustomerName.Trim() != "")
{
if (optionForConsignee == "1")
{
customers = new List <Lms_CustomerPoco>();
customers = _customerLogic.GetList().Where(c => c.CustomerName.ToUpper().Equals(consigneeCustomerName.ToUpper())).OrderBy(c => c.Id).ToList();
orders = orders.Where(c => customers.Any(d => c.ConsigneeCustomerId != null && d.Id == c.ConsigneeCustomerId)).ToList();
}
else if (optionForConsignee == "2")
{
customers = new List <Lms_CustomerPoco>();
customers = _customerLogic.GetList().Where(c => c.CustomerName.ToUpper().Contains(consigneeCustomerName.ToUpper())).OrderBy(c => c.Id).ToList();
orders = orders.Where(c => customers.Any(d => c.ConsigneeCustomerId != null && d.Id == c.ConsigneeCustomerId)).ToList();
}
}
if (cctnRef.Trim() != "")
{
if (optionForCctn == "1")
{
orders = orders.Where(c => c.CargoCtlNumber != null && c.CargoCtlNumber.ToUpper().Equals(cctnRef.ToUpper())).ToList();
}
else if (optionForCctn == "2")
{
orders = orders.Where(c => c.CargoCtlNumber != null && c.CargoCtlNumber.ToUpper().Contains(cctnRef.ToUpper())).ToList();
}
}
if (actnRef.Trim() != "")
{
if (optionForActn == "1")
{
orders = orders.Where(c => c.AwbCtnNumber != null && c.AwbCtnNumber.ToUpper().Equals(actnRef.ToUpper())).ToList();
}
else if (optionForActn == "2")
{
orders = orders.Where(c => c.AwbCtnNumber != null && c.AwbCtnNumber.ToUpper().Contains(actnRef.ToUpper())).ToList();
}
}
if (delRef.Trim() != "")
{
if (optionForDelRef == "1")
{
orders = orders.Where(c => c.DeliveryReferenceNumber != null && c.DeliveryReferenceNumber.ToUpper().Equals(delRef.ToUpper())).ToList();
}
else if (optionForDelRef == "2")
{
orders = orders.Where(c => c.DeliveryReferenceNumber != null && c.DeliveryReferenceNumber.ToUpper().Contains(delRef.ToUpper())).ToList();
}
}
if (puRef.Trim() != "")
{
if (optionForPuRef == "1")
{
orders = orders.Where(c => c.PickupReferenceNumber != null && c.PickupReferenceNumber.ToUpper().Equals(puRef.ToUpper())).ToList();
}
else if (optionForPuRef == "2")
{
orders = orders.Where(c => c.PickupReferenceNumber != null && c.PickupReferenceNumber.ToUpper().Contains(puRef.ToUpper())).ToList();
}
}
if (orderBy.Trim() != "")
{
if (orderBy == "1")
{
orders = orders.Where(c => c.OrderedBy != null && c.OrderedBy.ToUpper().Equals(orderBy.ToUpper())).ToList();
}
else if (orderBy == "2")
{
orders = orders.Where(c => c.OrderedBy != null && c.OrderedBy.ToUpper().Contains(orderBy.ToUpper())).ToList();
}
}
if (bolRef.Trim() != "")
{
if (orderBy == "1")
{
orders = orders.Where(c => c.BolReferenceNumber != null && c.BolReferenceNumber.ToUpper().Equals(bolRef.ToUpper())).ToList();
}
else if (orderBy == "2")
{
orders = orders.Where(c => c.BolReferenceNumber != null && c.BolReferenceNumber.ToUpper().Contains(bolRef.ToUpper())).ToList();
}
}
if (proRef.Trim() != "")
{
if (orderBy == "1")
{
orders = orders.Where(c => c.ProReferenceNumber != null && c.ProReferenceNumber.ToUpper().Equals(proRef.ToUpper())).ToList();
}
else if (orderBy == "2")
{
orders = orders.Where(c => c.ProReferenceNumber != null && c.ProReferenceNumber.ToUpper().Contains(proRef.ToUpper())).ToList();
}
}
customers = _customerLogic.GetList();
var employees = _employeeLogic.GetList();
var addresses = _addressLogic.GetList();
var unitTypes = _unitTypeLogic.GetList();
var weightScales = _weightScaleLogic.GetList();
var deliveyOptions = _deliveryOptionLogic.GetList();
var vehicleTypes = _vehicleTypeScaleLogic.GetList();
var cities = _cityLogic.GetList();
var provinces = _provinceLogic.GetList();
var countries = _countryLogic.GetList();
foreach (var order in orders)
{
var resultModel = new ViewModel_SearchResult_Order();
resultModel.OrderId = order.Id;
resultModel.OrderTypeId = order.OrderTypeId;
resultModel.OrderId = order.OrderTypeId;
resultModel.OrderTypeId = order.OrderTypeId;
resultModel.WayBillNumber = order.WayBillNumber;
resultModel.ReferenceNumber = order.ReferenceNumber;
resultModel.CargoCtlNumber = order.CargoCtlNumber;
resultModel.AwbCtnNumber = order.AwbCtnNumber;
resultModel.PickupReferenceNumber = order.PickupReferenceNumber;
resultModel.DeliveryReferenceNumber = order.DeliveryReferenceNumber;
resultModel.ShipperCustomerId = order.ShipperCustomerId;
if (resultModel.ShipperCustomerId != null && resultModel.ShipperCustomerId > 0)
{
resultModel.ShipperCustomerName = customers.Where(c => c.Id == resultModel.ShipperCustomerId).FirstOrDefault().CustomerName;
}
resultModel.ShipperAddressId = order.ShipperAddressId;
if (resultModel.ShipperAddressId != null && resultModel.ShipperAddressId > 0)
{
var address = addresses.Where(c => c.Id == resultModel.ShipperAddressId).FirstOrDefault();
resultModel.ShipperUnitNumber = address.UnitNumber;
resultModel.ShipperAddressLine = address.AddressLine;
if (address.CityId > 0)
{
resultModel.ShipperCityName = cities.Where(c => c.Id == address.CityId).FirstOrDefault().CityName;
}
if (address.ProvinceId > 0)
{
resultModel.ShipperProvinceName = provinces.Where(c => c.Id == address.ProvinceId).FirstOrDefault().ShortCode;
}
if (address.CountryId > 0)
{
resultModel.ShipperCountryName = countries.Where(c => c.Id == address.CountryId).FirstOrDefault().Alpha3CountryCode;
}
resultModel.ShipperPostCode = address.PostCode;
}
resultModel.ConsigneeCustomerId = order.ConsigneeCustomerId;
if (resultModel.ConsigneeCustomerId != null && resultModel.ConsigneeCustomerId > 0)
{
resultModel.ConsigneeCustomerName = customers.Where(c => c.Id == resultModel.ConsigneeCustomerId).FirstOrDefault().CustomerName;
}
resultModel.ConsigneeAddressId = order.ConsigneeAddressId;
if (resultModel.ConsigneeAddressId != null && resultModel.ConsigneeAddressId > 0)
{
var address = addresses.Where(c => c.Id == resultModel.ConsigneeAddressId).FirstOrDefault();
resultModel.ConsigneeUnitNumber = address.UnitNumber;
resultModel.ConsigneeAddressLine = address.AddressLine;
if (address.CityId > 0)
{
resultModel.ConsigneeCityName = cities.Where(c => c.Id == address.CityId).FirstOrDefault().CityName;
}
if (address.ProvinceId > 0)
{
resultModel.ConsigneeProvinceName = provinces.Where(c => c.Id == address.ProvinceId).FirstOrDefault().ShortCode;
}
if (address.CountryId > 0)
{
resultModel.ConsigneeCountryName = countries.Where(c => c.Id == address.CountryId).FirstOrDefault().Alpha3CountryCode;
}
resultModel.ConsigneePostCode = address.PostCode;
}
resultModel.BillToCustomerId = order.BillToCustomerId;
if (resultModel.BillToCustomerId > 0)
{
resultModel.BillToCustomerName = customers.Where(c => c.Id == resultModel.BillToCustomerId).FirstOrDefault().CustomerName;
}
resultModel.ServiceProviderEmployeeId = order.ServiceProviderEmployeeId;
if (resultModel.ServiceProviderEmployeeId > 0)
{
var emp = employees.Where(c => c.Id == resultModel.ServiceProviderEmployeeId).FirstOrDefault();
resultModel.ServiceProviderEmployeeName = emp.FirstName + " " + emp.LastName;
}
resultModel.ScheduledPickupDate = order.ScheduledPickupDate;
resultModel.ExpectedDeliveryDate = order.ExpectedDeliveryDate;
resultModel.CityId = order.CityId;
if (resultModel.CityId > 0)
{
resultModel.CityName = cities.Where(c => c.Id == resultModel.CityId).FirstOrDefault().CityName;
}
resultModel.DeliveryOptionId = order.DeliveryOptionId;
if (resultModel.DeliveryOptionId > 0)
{
resultModel.DeliveryOptionName = deliveyOptions.Where(c => c.Id == resultModel.DeliveryOptionId).FirstOrDefault().ShortCode;
}
resultModel.VehicleTypeId = order.VehicleTypeId;
if (resultModel.VehicleTypeId > 0)
{
resultModel.VehicleTypeName = vehicleTypes.Where(c => c.Id == resultModel.VehicleTypeId).FirstOrDefault().TypeName;
}
resultModel.UnitTypeId = order.UnitTypeId;
if (resultModel.UnitTypeId > 0)
{
resultModel.UnitTypeName = unitTypes.Where(c => c.Id == resultModel.UnitTypeId).FirstOrDefault().TypeName;
}
resultModel.WeightScaleId = order.WeightScaleId;
if (resultModel.WeightScaleId > 0)
{
resultModel.WeightScaleName = weightScales.Where(c => c.Id == resultModel.WeightScaleId).FirstOrDefault().ShortCode;
}
resultModel.WeightTotal = order.WeightTotal;
resultModel.UnitQuantity = order.UnitQuantity;
resultModel.SkidQuantity = order.SkidQuantity;
resultModel.TotalPiece = order.TotalPiece;
resultModel.OrderBasicCost = order.OrderBasicCost;
resultModel.BasicCostOverriden = order.BasicCostOverriden;
resultModel.FuelSurchargePercentage = order.FuelSurchargePercentage;
resultModel.DiscountPercentOnOrderCost = order.DiscountPercentOnOrderCost;
resultModel.ApplicableGstPercent = order.ApplicableGstPercent;
resultModel.TotalOrderCost = order.TotalOrderCost;
resultModel.TotalAdditionalServiceCost = order.TotalAdditionalServiceCost;
resultModel.OrderedBy = order.OrderedBy;
resultModel.DeliveredBy = order.DeliveredBy;
resultModel.BolReferenceNumber = order.BolReferenceNumber;
resultModel.ProReferenceNumber = order.ProReferenceNumber;
resultModel.ShipperName = order.ShipperName;
resultModel.ShipperAddress = order.ShipperAddress;
resultModel.OrderShareAmount = order.OrderShareAmount;
resultModel.IsSharingOnPercent = order.IsSharingOnPercent;
resultModel.IsInvoiced = order.IsInvoiced;
resultModel.CommentsForWayBill = order.CommentsForWayBill;
resultModel.IsPrintedOnWayBill = order.IsPrintedOnWayBill;
resultModel.CommentsForInvoice = order.CommentsForInvoice;
resultModel.IsPrintedOnInvoice = order.IsPrintedOnInvoice;
resultModel.IsPrePrinted = order.IsPrePrinted;
resultModel.Remarks = order.Remarks;
resultModel.OrderDateString = order.CreateDate.ToString("dd-MMM-yyyy");
searchResults.Add(resultModel);
}
return(searchResults);
}
private ViewModel_MiscellaneousOrder GetMiscellaneousOrders()
{
ViewModel_MiscellaneousOrder miscOrderViewModel = new ViewModel_MiscellaneousOrder();
_cityLogic = new App_CityLogic(_cache, new EntityFrameworkGenericRepository <App_CityPoco>(_dbContext));
miscOrderViewModel.Cities = _cityLogic.GetList();
_provinceLogic = new App_ProvinceLogic(_cache, new EntityFrameworkGenericRepository <App_ProvincePoco>(_dbContext));
miscOrderViewModel.Provinces = _provinceLogic.GetList();
_configurationLogic = new Lms_ConfigurationLogic(_cache, new EntityFrameworkGenericRepository <Lms_ConfigurationPoco>(_dbContext));
miscOrderViewModel.Configuration = _configurationLogic.GetList().FirstOrDefault();
_customerLogic = new Lms_CustomerLogic(_cache, new EntityFrameworkGenericRepository <Lms_CustomerPoco>(_dbContext));
miscOrderViewModel.Customers = _customerLogic.GetList();
_deliveryOptionLogic = new Lms_DeliveryOptionLogic(_cache, new EntityFrameworkGenericRepository <Lms_DeliveryOptionPoco>(_dbContext));
miscOrderViewModel.DeliveryOptions = _deliveryOptionLogic.GetList();
_unitTypeLogic = new Lms_UnitTypeLogic(_cache, new EntityFrameworkGenericRepository <Lms_UnitTypePoco>(_dbContext));
miscOrderViewModel.UnitTypes = _unitTypeLogic.GetList();
_weightScaleLogic = new Lms_WeightScaleLogic(_cache, new EntityFrameworkGenericRepository <Lms_WeightScalePoco>(_dbContext));
miscOrderViewModel.WeightScales = _weightScaleLogic.GetList();
_additionalServiceLogic = new Lms_AdditionalServiceLogic(_cache, new EntityFrameworkGenericRepository <Lms_AdditionalServicePoco>(_dbContext));
miscOrderViewModel.AdditionalServices = _additionalServiceLogic.GetList();
_employeeLogic = new Lms_EmployeeLogic(_cache, new EntityFrameworkGenericRepository <Lms_EmployeePoco>(_dbContext));
miscOrderViewModel.Employees = _employeeLogic.GetList().Where(c => c.EmployeeTypeId == 5).ToList(); // Load employees 'Broker'
var orders = _orderLogic.GetList().Where(c => c.OrderTypeId == 3).ToList(); // Load only misc. orders
List <ViewModel_OrderDispatched> viewModelOrders = new List <ViewModel_OrderDispatched>();
foreach (var item in orders)
{
ViewModel_OrderDispatched viewModelOrder = new ViewModel_OrderDispatched();
viewModelOrder.OrderId = item.Id;
viewModelOrder.OrderTypeId = item.OrderTypeId;
viewModelOrder.OrderTypeFlag = "Misc.";
viewModelOrder.ServiceProviderEmployeeId = item.ServiceProviderEmployeeId;
if (item.ServiceProviderEmployeeId != null && item.ServiceProviderEmployeeId > 0)
{
viewModelOrder.ServiceProviderEmployeeName = (miscOrderViewModel.Employees.Where(c => c.Id == item.ServiceProviderEmployeeId).FirstOrDefault()).FirstName;
}
viewModelOrder.WayBillNumber = item.WayBillNumber;
viewModelOrder.OrderDateString = item.CreateDate.ToString("dd-MMM-yy");
viewModelOrder.CustomerRefNumber = item.ReferenceNumber;
viewModelOrder.UnitTypeId = item.UnitTypeId;
if (item.UnitTypeId > 0)
{
viewModelOrder.UnitTypeName = miscOrderViewModel.UnitTypes.Where(c => c.Id == viewModelOrder.UnitTypeId).FirstOrDefault().ShortCode;
}
viewModelOrder.UnitQuantity = item.UnitQuantity;
viewModelOrder.SkidQuantity = item.SkidQuantity;
viewModelOrder.TotalPiece = item.TotalPiece;
viewModelOrder.SpcIns = "";
viewModelOrder.BillerCustomerId = item.BillToCustomerId;
if (item.BillToCustomerId > 0)
{
viewModelOrder.BillerCustomerName = miscOrderViewModel.Customers.Where(c => c.Id == viewModelOrder.BillerCustomerId).FirstOrDefault().CustomerName;
}
viewModelOrders.Add(viewModelOrder);
}
miscOrderViewModel.MiscellaneousOrders = viewModelOrders;
return(miscOrderViewModel);
}
public JsonResult PrintWaybill([FromBody] dynamic orderData)
{
try
{
List <ViewModel_PrintWaybill> waybillPrintViewModels = new List <ViewModel_PrintWaybill>();
JArray wayBillNumberList = null;
var orderList = _orderLogic.GetList();
_addressLogic = new Lms_AddressLogic(_cache, new EntityFrameworkGenericRepository <Lms_AddressPoco>(_dbContext));
var addresses = _addressLogic.GetList();
_cityLogic = new App_CityLogic(_cache, new EntityFrameworkGenericRepository <App_CityPoco>(_dbContext));
var cities = _cityLogic.GetList();
_provinceLogic = new App_ProvinceLogic(_cache, new EntityFrameworkGenericRepository <App_ProvincePoco>(_dbContext));
var provinces = _provinceLogic.GetList();
_customerLogic = new Lms_CustomerLogic(_cache, new EntityFrameworkGenericRepository <Lms_CustomerPoco>(_dbContext));
var customers = _customerLogic.GetList();
_deliveryOptionLogic = new Lms_DeliveryOptionLogic(_cache, new EntityFrameworkGenericRepository <Lms_DeliveryOptionPoco>(_dbContext));
var deliveryOptions = _deliveryOptionLogic.GetList();
_unitTypeLogic = new Lms_UnitTypeLogic(_cache, new EntityFrameworkGenericRepository <Lms_UnitTypePoco>(_dbContext));
var unitTypes = _unitTypeLogic.GetList();
_weightScaleLogic = new Lms_WeightScaleLogic(_cache, new EntityFrameworkGenericRepository <Lms_WeightScalePoco>(_dbContext));
var weightScales = _weightScaleLogic.GetList();
if (orderData != null)
{
wayBillNumberList = JArray.Parse(JsonConvert.SerializeObject(orderData[0]));
}
foreach (var item in wayBillNumberList)
{
var wbNumber = item.ToString();
var orderInfo = orderList.Where(c => c.WayBillNumber == wbNumber && c.OrderTypeId == 1).FirstOrDefault(); //consider only the single order; not the return order
if (orderInfo != null)
{
ViewModel_PrintWaybill waybillPrintViewModel = new ViewModel_PrintWaybill();
waybillPrintViewModel.WaybillNumber = orderInfo.WayBillNumber;
waybillPrintViewModel.WayBillDate = orderInfo.CreateDate.ToString("dd-MMM-yy");
waybillPrintViewModel.BillerCustomerId = orderInfo.BillToCustomerId;
waybillPrintViewModel.CustomerRefNo = orderInfo.ReferenceNumber;
waybillPrintViewModel.CargoCtlNo = orderInfo.CargoCtlNumber;
waybillPrintViewModel.AwbContainerNo = orderInfo.AwbCtnNumber;
waybillPrintViewModel.BillerCustomerName = customers.Where(c => c.Id == orderInfo.BillToCustomerId).FirstOrDefault().CustomerName;
waybillPrintViewModel.OrderedByName = orderInfo.OrderedBy;
waybillPrintViewModel.DeliveryOptionShortCode = deliveryOptions.Where(c => c.Id == orderInfo.DeliveryOptionId).FirstOrDefault().ShortCode;
waybillPrintViewModel.OrderBasePrice = orderInfo.OrderBasicCost.ToString();
if (orderInfo.BasicCostOverriden != null && orderInfo.BasicCostOverriden > 0)
{
waybillPrintViewModel.OrderBasePrice = orderInfo.BasicCostOverriden.ToString();
}
if (orderInfo.DiscountPercentOnOrderCost != null && orderInfo.DiscountPercentOnOrderCost > 0)
{
var orderDiscount = Convert.ToDecimal(waybillPrintViewModel.OrderBasePrice) - (Convert.ToDecimal(waybillPrintViewModel.OrderBasePrice) * orderInfo.DiscountPercentOnOrderCost / 100);
if (orderDiscount > 0)
{
waybillPrintViewModel.OrderDiscountAmount = orderDiscount.ToString();
waybillPrintViewModel.OrderBasePrice = (Convert.ToDecimal(waybillPrintViewModel.OrderBasePrice) - (decimal)orderDiscount).ToString();
}
else
{
waybillPrintViewModel.OrderDiscountAmount = "0.00";
}
}
if (orderInfo.FuelSurchargePercentage != null && orderInfo.FuelSurchargePercentage > 0)
{
var fuelAmnt = Convert.ToDecimal(waybillPrintViewModel.OrderBasePrice) * orderInfo.FuelSurchargePercentage / 100;
if (fuelAmnt > 0)
{
waybillPrintViewModel.FuelSurcharge = fuelAmnt.ToString();
}
else
{
waybillPrintViewModel.FuelSurcharge = "0.00";
}
}
if (orderInfo.TotalAdditionalServiceCost > 0)
{
waybillPrintViewModel.AdditionalServiceCost = orderInfo.TotalAdditionalServiceCost.ToString();
}
else
{
waybillPrintViewModel.AdditionalServiceCost = "0.00";
}
if (orderInfo.ApplicableGstPercent != null && orderInfo.ApplicableGstPercent > 0)
{
var taxAmnt = Convert.ToDecimal(waybillPrintViewModel.OrderBasePrice) * orderInfo.ApplicableGstPercent / 100;
if (taxAmnt > 0)
{
waybillPrintViewModel.OrderTaxAmountOnBasePrice = taxAmnt.ToString();
}
else
{
waybillPrintViewModel.OrderTaxAmountOnBasePrice = "0.00";
}
}
waybillPrintViewModel.NetTotalOrderCost = (Convert.ToDecimal(waybillPrintViewModel.OrderBasePrice) + Convert.ToDecimal(waybillPrintViewModel.FuelSurcharge) + Convert.ToDecimal(waybillPrintViewModel.AdditionalServiceCost)).ToString();
waybillPrintViewModel.ShipperCustomerName = customers.Where(c => c.Id == orderInfo.ShipperCustomerId).FirstOrDefault().CustomerName;
var shippperAddress = addresses.Where(c => c.Id == orderInfo.ShipperAddressId).FirstOrDefault();
waybillPrintViewModel.ShipperCustomerAddressLine1 = !string.IsNullOrEmpty(shippperAddress.UnitNumber) ? shippperAddress.UnitNumber + ", " + shippperAddress.AddressLine : shippperAddress.AddressLine;
waybillPrintViewModel.ShipperCustomerAddressLine2 = cities.Where(c => c.Id == shippperAddress.CityId).FirstOrDefault().CityName + ", " + provinces.Where(c => c.Id == shippperAddress.ProvinceId).FirstOrDefault().ShortCode + " " + shippperAddress.PostCode;
waybillPrintViewModel.ConsigneeCustomerName = customers.Where(c => c.Id == orderInfo.ConsigneeCustomerId).FirstOrDefault().CustomerName;
var consigneeAddress = addresses.Where(c => c.Id == orderInfo.ConsigneeAddressId).FirstOrDefault();
waybillPrintViewModel.ConsigneeCustomerAddressLine1 = !string.IsNullOrEmpty(consigneeAddress.UnitNumber) ? consigneeAddress.UnitNumber + ", " + consigneeAddress.AddressLine : consigneeAddress.AddressLine;
waybillPrintViewModel.ConsigneeCustomerAddressLine2 = cities.Where(c => c.Id == consigneeAddress.CityId).FirstOrDefault().CityName + ", " + provinces.Where(c => c.Id == consigneeAddress.ProvinceId).FirstOrDefault().ShortCode + " " + consigneeAddress.PostCode;
waybillPrintViewModel.TotalSkidPieces = 0;
waybillPrintViewModel.UnitTypeName = unitTypes.Where(c => c.Id == orderInfo.UnitTypeId).FirstOrDefault().TypeName;
waybillPrintViewModel.UnitTypeShortCode = unitTypes.Where(c => c.Id == orderInfo.UnitTypeId).FirstOrDefault().ShortCode;
waybillPrintViewModel.UnitQuantity = orderInfo.UnitQuantity;
waybillPrintViewModel.WeightScaleShortCode = weightScales.Where(c => c.Id == orderInfo.WeightScaleId).FirstOrDefault().ShortCode;
waybillPrintViewModel.WeightTotal = orderInfo.WeightTotal.ToString();
waybillPrintViewModel.DeliveryDate = null;
waybillPrintViewModel.DeliveryTime = null;
waybillPrintViewModel.PUDriverName = "";
waybillPrintViewModel.DeliveryDriverName = orderInfo.WayBillNumber;
if (orderInfo.IsPrintedOnWayBill != null && orderInfo.IsPrintedOnWayBill == true)
{
waybillPrintViewModel.WaybillComments = orderInfo.CommentsForWayBill;
}
waybillPrintViewModels.Add(waybillPrintViewModel);
}
}
var webrootPath = _hostingEnvironment.WebRootPath;
var uniqueId = DateTime.Now.ToFileTime();
var path = "/contents/waybills/waybill_" + uniqueId + ".pdf";
var filePath = webrootPath + path;
var pdfReport = new ViewAsPdf("PrintWaybill", waybillPrintViewModels);
var file = pdfReport.BuildFile(ControllerContext).Result;
System.IO.File.WriteAllBytes(filePath, file);
//_emailService.SendEmail("*****@*****.**", "test subject", "test body content", path);
return(Json(path));
}
catch (Exception ex)
{
return(null);
}
//return View();
}
public IActionResult Index()
{
var customerList = _deliveryOptionLogic.GetList();
return(View());
}
public IActionResult PartialLoadEmployeeOrders(string empId, string fromDate, string toDate)
{
List <ViewModel_PayrollOrder> viewModelPayrollOrders = new List <ViewModel_PayrollOrder>();
if (empId != "")
{
int selectedEmpId = Convert.ToInt16(empId);
DateTime selectedFromDate = Convert.ToDateTime(fromDate);
DateTime selectedToDate = Convert.ToDateTime(toDate);
_deliveryOptionLogic = new Lms_DeliveryOptionLogic(_cache, new EntityFrameworkGenericRepository <Lms_DeliveryOptionPoco>(_dbContext));
var deliveryOptionList = _deliveryOptionLogic.GetList();
_employeeLogic = new Lms_EmployeeLogic(_cache, new EntityFrameworkGenericRepository <Lms_EmployeePoco>(_dbContext));
var employeeList = _employeeLogic.GetList();
_additionalServiceLogic = new Lms_OrderAdditionalServiceLogic(_cache, new EntityFrameworkGenericRepository <Lms_OrderAdditionalServicePoco>(_dbContext));
_orderLogic = new Lms_OrderLogic(_cache, new EntityFrameworkGenericRepository <Lms_OrderPoco>(_dbContext));
var orderList = _orderLogic.GetList();
_orderStatusLogic = new Lms_OrderStatusLogic(_cache, new EntityFrameworkGenericRepository <Lms_OrderStatusPoco>(_dbContext));
var orderStatusList = _orderStatusLogic.GetList().Where(c => (c.DispatchedToEmployeeId == selectedEmpId || c.PassedOffToEmployeeId == selectedEmpId) && c.CreateDate >= selectedFromDate && c.CreateDate <= selectedToDate && c.IsDelivered == true).ToList();
orderList = (from order in orderList
join status in orderStatusList on order.Id equals status.OrderId
select order).ToList();
foreach (var order in orderList)
{
ViewModel_PayrollOrder payrollOrder = new ViewModel_PayrollOrder();
var empInfo = _employeeLogic.GetSingleById(selectedEmpId);
var orderStatus = orderStatusList.Where(c => c.OrderId == order.Id).FirstOrDefault();
payrollOrder.WaybillNumber = order.WayBillNumber;
payrollOrder.WaybillDate = order.CreateDate;
payrollOrder.OrderType = order.OrderTypeId == 1 ? "Single" : "Return";
payrollOrder.DeliveryOptionShortCode = deliveryOptionList.Where(c => c.Id == order.DeliveryOptionId).FirstOrDefault().ShortCode;
payrollOrder.PickupEmployeeId = (int)orderStatus.DispatchedToEmployeeId;
payrollOrder.PickupEmployeeName = employeeList.Where(c => c.Id == payrollOrder.PickupEmployeeId).FirstOrDefault().FirstName;
var deliveryEmpId = orderStatusList.Where(c => c.OrderId == order.Id).FirstOrDefault().PassedOffToEmployeeId;
if (deliveryEmpId != null && deliveryEmpId > 0)
{
payrollOrder.DeliveryEmployeeId = (int)orderStatus.PassedOffToEmployeeId;
payrollOrder.DeliveryEmployeeName = employeeList.Where(c => c.Id == payrollOrder.DeliveryEmployeeId).FirstOrDefault().FirstName;
}
else
{
payrollOrder.DeliveryEmployeeId = payrollOrder.PickupEmployeeId;
payrollOrder.DeliveryEmployeeName = payrollOrder.PickupEmployeeName;
}
payrollOrder.WaybillBaseAmount = order.OrderBasicCost;
if (order.BasicCostOverriden != null && order.BasicCostOverriden > 0)
{
payrollOrder.WaybillBaseAmount = (decimal)order.BasicCostOverriden;
}
payrollOrder.OrderCommissionPercent = empInfo.CommissionPercentage == null ? 0 : (decimal)empInfo.CommissionPercentage;
payrollOrder.OrderFuelPercent = empInfo.FuelPercentage == null ? 0 : (decimal)empInfo.FuelPercentage;
payrollOrder.OrderCommissionAmnt = payrollOrder.WaybillBaseAmount * payrollOrder.OrderCommissionPercent / 100;
payrollOrder.OrderFuelAmnt = payrollOrder.WaybillBaseAmount * payrollOrder.OrderFuelPercent / 100;
payrollOrder.AddServiceAmnt = 0;
var additionalServices = _additionalServiceLogic.GetList().Where(c => c.OrderId == order.Id);
foreach (var addSrv in additionalServices)
{
if (addSrv.DriverPercentageOnAddService != null && addSrv.DriverPercentageOnAddService > 0)
{
payrollOrder.AddServiceAmnt = payrollOrder.AddServiceAmnt + (addSrv.AdditionalServiceFee * (decimal)addSrv.DriverPercentageOnAddService / 100);
}
}
payrollOrder.WaitTime = orderStatus.DeliveryWaitTimeHour;
viewModelPayrollOrders.Add(payrollOrder);
}
}
return(PartialView("_PartialViewEmployeeDeliveries", viewModelPayrollOrders));
}
