public HomeController(IMemoryCache cache, LogisticsContext dbContext)
{
_cache = cache;
_dbContext = dbContext;
_orderLogic = new Lms_OrderLogic(_cache, new EntityFrameworkGenericRepository <Lms_OrderPoco>(_dbContext));
_orderStatusLogic = new Lms_OrderStatusLogic(_cache, new EntityFrameworkGenericRepository <Lms_OrderStatusPoco>(_dbContext));
}
public MiscellaneousOrderController(IMemoryCache cache, IEmailService emailService, IHostingEnvironment hostingEnvironment, IHttpContextAccessor httpContext, LogisticsContext dbContext)
{
_cache = cache;
_dbContext = dbContext;
_emailService = emailService;
_hostingEnvironment = hostingEnvironment;
_httpContext = httpContext;
_orderLogic = new Lms_OrderLogic(_cache, new EntityFrameworkGenericRepository <Lms_OrderPoco>(_dbContext));
_orderStatusLogic = new Lms_OrderStatusLogic(_cache, new EntityFrameworkGenericRepository <Lms_OrderStatusPoco>(_dbContext));
}
public IActionResult Remove(string id)
{
ValidateSession();
var result = "";
try
{
using (var scope = new TransactionScope())
{
var orders = _orderLogic.GetList().Where(c => c.WayBillNumber == id).ToList();
_orderAdditionalServiceLogic = new Lms_OrderAdditionalServiceLogic(_cache, new EntityFrameworkGenericRepository <Lms_OrderAdditionalServicePoco>(_dbContext));
_orderStatusLogic = new Lms_OrderStatusLogic(_cache, new EntityFrameworkGenericRepository <Lms_OrderStatusPoco>(_dbContext));
foreach (var order in orders)
{
if (!order.IsInvoiced)
{
var orderServices = _orderAdditionalServiceLogic.GetList().Where(c => c.OrderId == order.Id).ToList();
if (orderServices.Count > 0)
{
foreach (var item in orderServices)
{
_orderAdditionalServiceLogic.Remove(item);
}
}
_orderLogic.Remove(order);
result = "Success";
}
else
{
result = "";
}
}
if (result.Length > 0)
{
scope.Complete();
}
}
}
catch (Exception ex)
{
}
return(Json(result));
}
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));
}
