public dynamic Post(DBOYinfo DBI) { logger.Info("start OrderMaster: "); List <deliveryboydatalist> MainReport = new List <deliveryboydatalist>(); DateTime start = DateTime.Parse("01-01-2017 00:00:00"); DateTime end = DateTime.Today.AddDays(1); try { var identity = User.Identity as ClaimsIdentity; int compid = 0, userid = 0; foreach (Claim claim in identity.Claims) { if (claim.Type == "compid") { compid = int.Parse(claim.Value); } if (claim.Type == "userid") { userid = int.Parse(claim.Value); } } logger.Info("User ID : {0} , Company Id : {1}", compid, userid); if (DBI.datefrom == null) { DBI.datefrom = DateTime.Parse("01-01-2017 00:00:00"); DBI.dateto = DateTime.Today.AddDays(1); } else { start = DBI.datefrom.GetValueOrDefault(); end = DBI.dateto.GetValueOrDefault(); } foreach (var i in DBI.ids) { deliveryboydatalist oh = new deliveryboydatalist(); var olist = getDBoyOrdersHistory(i.mob, DBI.datefrom, DBI.dateto, i.id); oh = olist; MainReport.Add(oh); } return(MainReport); } catch (Exception ex) { logger.Error("Error in OrderMaster " + ex.Message); logger.Info("End OrderMaster: "); return(null); } }
public deliveryboydatalist getDBoyOrdersHistory(string mob, DateTime?start, DateTime?end, int dboyId) { try { deliveryboydatalist orderhistory = new deliveryboydatalist(); orderhistory.totalOrder = 0; orderhistory.AllOrderAmount = 0; orderhistory.DeliveredOrderAmount = 0; orderhistory.Canceled = 0; orderhistory.CanceledOderAmount = 0; orderhistory.RedispatchedOrderAmount = 0; orderhistory.Redispatched = 0; orderhistory.Delivered = 0; orderhistory.Pending = 0; orderhistory.PendingOderAmount = 0; var Issulist = db.DeliveryIssuanceDb.Where(x => x.CreatedDate > start && x.CreatedDate <= end && x.PeopleID == dboyId).ToList(); if (Issulist != null) { orderhistory.name = Issulist[0].DisplayName; orderhistory.DBoyId = Issulist[0].PeopleID; } foreach (var o in Issulist) { if (o.Status == "Accepted") { var orderhistory1 = new OrderHistory(); List <OrderDispatchedMaster> OrdersObj = new List <OrderDispatchedMaster>(); string[] ids = o.OrderdispatchIds.Split(','); foreach (var od in ids) { var oid = Convert.ToInt16(od); var orderdipatchmaster = db.OrderDispatchedMasters.Where(x => x.OrderDispatchedMasterId == oid).SingleOrDefault(); if (orderdipatchmaster != null) { if ((orderdipatchmaster.Status == "Delivery Canceled" || orderdipatchmaster.Status == "Order Canceled")) { orderhistory.Canceled = orderhistory.Canceled + 1; orderhistory.CanceledOderAmount = orderhistory.CanceledOderAmount + orderdipatchmaster.GrossAmount; } else if ((orderdipatchmaster.Status == "Delivered" || orderdipatchmaster.Status == "sattled" || orderdipatchmaster.Status == "Account settled" || orderdipatchmaster.Status == "Partial settled" || orderdipatchmaster.Status == "Partial receiving -Bounce")) { orderhistory.Delivered = orderhistory.Delivered + 1; orderhistory.DeliveredOrderAmount = orderhistory.DeliveredOrderAmount + orderdipatchmaster.GrossAmount; } if ((orderdipatchmaster.Status == "Ready to Dispatch" || orderdipatchmaster.Status == "Delivery Redispatch") && (orderdipatchmaster.ReDispatchCount > 0)) { orderhistory.Redispatched = orderhistory.Redispatched + 1; orderhistory.RedispatchedOrderAmount = orderhistory.RedispatchedOrderAmount + orderdipatchmaster.GrossAmount; } if ((orderdipatchmaster.Status == "Ready to Dispatch")) { orderhistory.ReadyToDispatch = orderhistory.ReadyToDispatch + 1; orderhistory.ReadyToDispatchOderAmount = orderhistory.ReadyToDispatchOderAmount + orderdipatchmaster.GrossAmount; } if ((orderdipatchmaster.Status == "Pending" || orderdipatchmaster.Status == "Shipped")) { orderhistory.Pending = orderhistory.Pending + 1; orderhistory.PendingOderAmount = orderhistory.PendingOderAmount + orderdipatchmaster.GrossAmount; } orderhistory.AllOrderAmount = orderhistory.AllOrderAmount + orderdipatchmaster.GrossAmount; orderhistory.totalOrder = orderhistory.totalOrder + 1; } } } } return(orderhistory); } catch (Exception ex) { return(null); } }