public JsonResult GetOrderStatusByOrderId(string id)
{
ValidateSession();
try
{
var orderStatus = _orderStatusLogic.GetList().Where(c => c.OrderId == Convert.ToInt32(id)).FirstOrDefault();
return(Json(JsonConvert.SerializeObject(orderStatus)));
}
catch (Exception ex)
{
return(Json(""));
}
}
public IActionResult Index()
{
ValidateSession();
var orderList = _orderLogic.GetList();
var orderStatusList = _orderStatusLogic.GetList();
var orders = (from order in orderList
join status in orderStatusList on order.Id equals status.OrderId
where status.IsPickedup != true && order.OrderTypeId != 3 && order.TotalOrderCost > 0
select order).ToList();
ViewBag.OrderCount = orders.Count;
ViewBag.UserId = sessionData.UserId;
ViewBag.FirstName = sessionData.FirstName;
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));
}
public IActionResult Index()
{
var customerList = _orderStatusLogic.GetList();
return(View());
}