public IActionResult GetEmployeeList() { ValidateSession(); var employeeList = _employeeLogic.GetList(); if (employeeList.Count > 0) { return(Json(JsonConvert.SerializeObject(employeeList))); } return(Json("")); }
public IActionResult Index() { ValidateSession(); _cityLogic = new App_CityLogic(_cache, new EntityFrameworkGenericRepository <App_CityPoco>(_dbContext)); _provinceLogic = new App_ProvinceLogic(_cache, new EntityFrameworkGenericRepository <App_ProvincePoco>(_dbContext)); _countryLogic = new App_CountryLogic(_cache, new EntityFrameworkGenericRepository <App_CountryPoco>(_dbContext)); _employeeLogic = new Lms_EmployeeLogic(_cache, new EntityFrameworkGenericRepository <Lms_EmployeePoco>(_dbContext)); ViewBag.UserGroups = Enum.GetValues(typeof(Enum_UserGroup)).Cast <Enum_UserGroup>(); ViewBag.Cities = _cityLogic.GetList().Select(c => new App_CityPoco { Id = c.Id, CityName = c.CityName }).ToList(); ViewBag.Provinces = _provinceLogic.GetList().Select(c => new App_ProvincePoco { Id = c.Id, ShortCode = c.ShortCode, IsDefault = c.IsDefault }).ToList(); ViewBag.Countries = _countryLogic.GetList().Select(c => new App_CountryPoco { Id = c.Id, CountryName = c.CountryName, IsDefault = c.IsDefault }).ToList(); ViewBag.Employees = _employeeLogic.GetList().Select(c => new Lms_EmployeePoco { Id = c.Id, FirstName = c.FirstName, LastName = c.LastName, EmailAddress = c.EmailAddress }).ToList(); return(View(GetUserData())); }
private List <ViewModel_EmployeeLoan> GetEmployeeLoans() { List <ViewModel_EmployeeLoan> employeeLoanViewList = new List <ViewModel_EmployeeLoan>(); var employeeLoanList = _employeeLoanLogic.GetList(); //var employeeLoanPaymentList = _employeeLoanPaymentLogic.GetList(); var employeeList = employeeLoanList.Select(c => c.EmployeeId).Distinct(); var employees = _employeeLogic.GetList(); foreach (var employeeId in employeeList) { ViewModel_EmployeeLoan employeeLoanView = new ViewModel_EmployeeLoan(); employeeLoanView.EmployeeId = employeeId; var emp = employees.Where(e => e.Id == employeeId).FirstOrDefault(); employeeLoanView.EmployeeName = emp.FirstName + " " + emp.LastName; employeeLoanView.LoanAmount = employeeLoanList.Where(c => c.EmployeeId == employeeId).Sum(c => c.LoanAmount); employeeLoanView.PaidAmount = 0;// employeeLoanPaymentList.Where(c=>c.EmployeeId==employeeId).Sum(c=>c.LoanAmountPaid); employeeLoanView.DueAmount = employeeLoanView.LoanAmount - employeeLoanView.PaidAmount; employeeLoanViewList.Add(employeeLoanView); } return(employeeLoanViewList); }
private ViewModel_Employee GetEmployeeData() { ViewModel_Employee employeeViewModel = new ViewModel_Employee(); employeeViewModel.Employees = _employeeLogic.GetList(); _cityLogic = new App_CityLogic(_cache, new EntityFrameworkGenericRepository <App_CityPoco>(_dbContext)); _provinceLogic = new App_ProvinceLogic(_cache, new EntityFrameworkGenericRepository <App_ProvincePoco>(_dbContext)); _countryLogic = new App_CountryLogic(_cache, new EntityFrameworkGenericRepository <App_CountryPoco>(_dbContext)); employeeViewModel.Cities = _cityLogic.GetList(); employeeViewModel.Provinces = _provinceLogic.GetList(); employeeViewModel.Countries = _countryLogic.GetList(); return(employeeViewModel); }
private List <ViewModel_EmployeeLoan> GetEmployeeLoans() { List <ViewModel_EmployeeLoan> employeeLoanViewList = new List <ViewModel_EmployeeLoan>(); var employeeLoanList = _employeeLoanLogic.GetList(); var employeeList = _employeeLogic.GetList(); foreach (var loan in employeeLoanList) { ViewModel_EmployeeLoan employeeLoanView = new ViewModel_EmployeeLoan(); employeeLoanView.LoanId = loan.Id; employeeLoanView.EmployeeId = loan.EmployeeId; employeeLoanView.EmployeeName = employeeList.Where(c => c.Id == loan.EmployeeId).FirstOrDefault().FirstName + " " + employeeList.Where(c => c.Id == loan.EmployeeId).FirstOrDefault().LastName; employeeLoanView.LoanAmount = loan.LoanAmount; employeeLoanView.LoanTakenOn = loan.LoanTakenOn; employeeLoanView.Remarks = loan.Remarks; employeeLoanViewList.Add(employeeLoanView); } return(employeeLoanViewList); }
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 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)); }
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(); _employeeLogic = new Lms_EmployeeLogic(_cache, new EntityFrameworkGenericRepository <Lms_EmployeePoco>(_dbContext)); var employees = _employeeLogic.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.DeliveredBy = orderInfo.DeliveredBy; waybillPrintViewModel.ShipperName = orderInfo.ShipperName; waybillPrintViewModel.ShipperAddress = orderInfo.ShipperAddress; waybillPrintViewModel.ProReferenceNumber = orderInfo.ProReferenceNumber; if (orderInfo.ServiceProviderEmployeeId != null && orderInfo.ServiceProviderEmployeeId > 0) { waybillPrintViewModel.ServiceProviderEmployeeName = employees.Where(c => c.Id == orderInfo.ServiceProviderEmployeeId).FirstOrDefault().FirstName; } 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) { throw ex; //return null; } //return View(); }