public void Create(order_items product)
        {
            if (!UpdateDatabase)
            {
                var first = GetAll().OrderByDescending(e => e.id).FirstOrDefault();
                var id    = (first != null) ? first.id : 0;

                product.id = id + 1;

                entities.order_items.Add(product);
                entities.SaveChanges();
            }
            else
            {
                var entity = new order_items();

                entity.item_id = product.item_id;
                entity.oid     = product.oid;
                entity.qty     = product.qty;
                entity.total   = product.total;
                entity.profit  = product.profit;
                entity.disc    = product.disc;

                entities.order_items.Add(entity);
                entities.SaveChanges();

                product.id = entity.id;
            }
        }
        // GET: OrderItemsMain/Details/5
        public ActionResult Details(int id)
        {
            order_items order_itemss = null;

            using (var client = new HttpClient())
            {
                client.BaseAddress = new Uri("http://localhost:54964/api/Order_ItemsApi");
                //HTTP GET
                var responseTask = client.GetAsync("Order_ItemsApi?id=" + id.ToString());
                responseTask.Wait();

                var result = responseTask.Result;
                if (result.IsSuccessStatusCode)
                {
                    var readTask = result.Content.ReadAsAsync <order_items>();
                    readTask.Wait();

                    order_itemss = readTask.Result;
                }
                else //web api sent error response
                {
                    //log response status here..


                    ModelState.AddModelError(string.Empty, "Server error. Please contact administrator.");
                }
            }
            return(View(order_itemss));
        }
        public IHttpActionResult Putorder_items(int id, order_items order_items)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != order_items.Id)
            {
                return(BadRequest());
            }

            db.Entry(order_items).State = EntityState.Modified;

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!order_itemsExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
        public void Update(order_items product)
        {
            if (!UpdateDatabase)
            {
                var target = One(e => e.id == product.id);

                if (target != null)
                {
                    target.item_id = product.item_id;
                    target.qty     = product.qty;
                    target.total   = product.total;
                    target.profit  = product.profit;
                    target.disc    = product.disc;
                }
                entities.SaveChanges();
            }
            else
            {
                var entity = new order_items();

                entity.item_id = product.item_id;
                entity.qty     = product.qty;
                entity.total   = product.total;
                entity.profit  = product.profit;
                entity.disc    = product.disc;

                entities.order_items.Attach(entity);
                entities.Entry(entity).State = EntityState.Modified;
                entities.SaveChanges();
            }
        }
        public IHttpActionResult Postorder_items(order_items order_items)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            db.order_items.Add(order_items);

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateException)
            {
                if (order_itemsExists(order_items.order_id))
                {
                    return(Conflict());
                }
                else
                {
                    throw;
                }
            }

            return(CreatedAtRoute("DefaultApi", new { id = order_items.order_id }, order_items));
        }
        public ActionResult DeleteConfirmed(int id)
        {
            order_items order_items = db.order_items.Find(id);

            db.order_items.Remove(order_items);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
        public IHttpActionResult Getorder_items(int id)
        {
            order_items order_items = db.order_items.Find(id);

            if (order_items == null)
            {
                return(NotFound());
            }

            return(Ok(order_items));
        }
 public ActionResult Edit([Bind(Include = "order_id,item_id,product_id,quantity,list_price,discount")] order_items order_items)
 {
     if (ModelState.IsValid)
     {
         db.Entry(order_items).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.product_id = new SelectList(db.products, "product_id", "product_name", order_items.product_id);
     ViewBag.order_id   = new SelectList(db.orders, "order_id", "order_id", order_items.order_id);
     return(View(order_items));
 }
        public IHttpActionResult Postorder_items(order_items order_items)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            db.order_items.Add(order_items);
            db.SaveChanges();

            return(CreatedAtRoute("DefaultApi", new { id = order_items.Id }, order_items));
        }
        // GET: OrderItems/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            order_items order_items = db.order_items.Find(id);

            if (order_items == null)
            {
                return(HttpNotFound());
            }
            return(View(order_items));
        }
        public IHttpActionResult Deleteorder_items(int id)
        {
            order_items order_items = db.order_items.Find(id);

            if (order_items == null)
            {
                return(NotFound());
            }

            db.order_items.Remove(order_items);
            db.SaveChanges();

            return(Ok(order_items));
        }
        // GET: OrderItems/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            order_items order_items = db.order_items.Find(id);

            if (order_items == null)
            {
                return(HttpNotFound());
            }
            ViewBag.product_id = new SelectList(db.products, "product_id", "product_name", order_items.product_id);
            ViewBag.order_id   = new SelectList(db.orders, "order_id", "order_id", order_items.order_id);
            return(View(order_items));
        }
Exemple #13
0
        private void saveOrderItems(int oid)
        {
            order_itemsModel oic = new order_itemsModel();

            for (int i = 0; i < ids.Length; i++)
            {
                order_items oi = new order_items();
                oi.oid     = oid;
                oi.item_id = ids[i];
                oi.qty     = qnty[i];
                oi.total   = total[i];
                oi.disc    = 0;
                oi.profit  = getItemProfit(i);
                oic.Create(oi);
            }
        }
        public ActionResult Delete(int id, order_items order_itemss)
        {
            using (var client = new HttpClient())
            {
                client.BaseAddress = new Uri("http://localhost:54964/api/Order_ItemsApi");

                //HTTP DELETE
                var deleteTask = client.DeleteAsync("Order_ItemsApi/" + id.ToString());
                deleteTask.Wait();

                var result = deleteTask.Result;
                if (result.IsSuccessStatusCode)
                {
                    return(RedirectToAction("Index"));
                }
            }
            return(RedirectToAction("Index"));
        }
        public ActionResult Edit(int id, order_items order_itemss)
        {
            using (var client = new HttpClient())
            {
                client.BaseAddress = new Uri("http://localhost:54964/api/Order_ItemsApi");

                //HTTP POST
                var putTask = client.PutAsJsonAsync <order_items>("Order_ItemsApi?id=" + id.ToString(), order_itemss);
                putTask.Wait();

                var result = putTask.Result;
                if (result.IsSuccessStatusCode)
                {
                    return(RedirectToAction("Index"));
                }
            }
            return(View(order_itemss));
        }
        public ActionResult Create(order_items order_itemss)
        {
            using (var client = new HttpClient())
            {
                client.BaseAddress = new Uri("http://localhost:54964/api/Order_ItemsApi");
                var postTask = client.PostAsJsonAsync <order_items>("Order_ItemsApi", order_itemss);
                postTask.Wait();

                var result = postTask.Result;
                if (result.IsSuccessStatusCode)
                {
                    return(RedirectToAction("Index"));
                }
                else
                {
                    ModelState.AddModelError(string.Empty, "Server Error. Please contact administrator.");
                }
            }

            return(View("Create"));
        }
        public static List <order_items> GetOrderItems()
        {
            String             query          = "SELECT * FROM order_items";
            List <order_items> list_ord_items = new List <order_items>();

            using (SqlCommand com = new SqlCommand(query, db.GetConnection()))
            {
                SqlDataReader reader = com.ExecuteReader();
                while (reader.Read())
                {
                    order_items ord_item = new order_items();
                    ord_item.order_item_id     = (Int32)reader["order_item_id"];
                    ord_item.quantity_in_order = (Int32)reader["quantity_in_order"];
                    ord_item.id_order          = (Int32)reader["id_order"];
                    ord_item.id_product        = (Int32)reader["id_product"];

                    list_ord_items.Add(ord_item);
                }
                db.CloseConnection();
            }
            return(list_ord_items);
        }
Exemple #18
0
        // ORDER ITEMS

        private void Button_add_items_Click(object sender, EventArgs e)
        {
            bool flag = true;

            try
            {
                var order_item = new order_items
                {
                    product_id     = Convert.ToInt32(dropDownList_product.SelectedValue),
                    order_id       = Convert.ToInt32(dropDownList_order.SelectedValue),
                    order_quantity = Convert.ToInt32(text_order_quantity.Text.ToString())
                };

                product product = db.products.Where(p => p.id == order_item.product_id).First();
                if (order_item.order_quantity > product.quantityInStock)
                {
                    flag = false;
                    MessageBox.Show("There Is not enough products to add them to order ! There Is just " + product.quantityInStock + " left :<");
                }


                if (IsInputValid(order_item) && flag && ShowConfirmMessage("add", "item"))
                {
                    db.order_items.Add(order_item);

                    product.quantityInStock = product.quantityInStock - order_item.order_quantity;
                    db.Entry(product).State = EntityState.Modified;
                    db.SaveChanges();
                    this.order_itemsTableAdapter.Fill(this.dataSet.order_items);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        public ActionResult Index(customer customer)
        {
            if (Session["user"] == null)
            {
                TempData["error2"] = "Bạn cần đăng nhập trước khi Order !.";
                return(RedirectToAction("Login", "Account"));
            }

            if (Session["Cart"] == null)
            {
                ViewBag.error = "Giỏ hàng của bạn đang trống !";
                return(Index());
            }
            if (ModelState.IsValid)
            {
                order order = new order
                {
                    customer_id = ((Session["user"] as customer).customer_id),
                    first_name  = customer.first_name,
                    last_name   = customer.last_name,
                    email       = customer.email,
                    //staff_id = 6,
                    phone        = customer.phone,
                    street       = customer.street,
                    city         = customer.city,
                    zip_code     = customer.zip_code,
                    order_status = false,
                    order_date   = DateTime.Now,
                    shipped_date = DateTime.Now.AddDays(4)
                };
                db.orders.Add(order);
                db.SaveChanges();
                List <CartItem> cart = (List <CartItem>)Session["Cart"];
                Xmail.XMail.Send(order.email, 1, 0, order, cart);
                List <staff> staff = db.staffs.ToList();
                foreach (var item in staff)
                {
                    Xmail.XMail.Send(item.email, 0, 0, order, cart);
                }
                ViewBag.success = "Đặt hàng thành công!";

                for (int i = 0; i < cart.Count; i++)
                {
                    order_items item = new order_items
                    {
                        order_id   = order.order_id,
                        product_id = cart[i].cart.product_id,
                        quantity   = cart[i].quantity,
                        list_price = cart[i].cart.list_price
                    };
                    product product = db.products.Find(cart[i].cart.product_id);
                    product.quantity = product.quantity - cart[i].quantity;
                    db.order_items.Add(item);
                    db.SaveChanges();
                }
                Session.Remove("Cart");
                return(Index());
            }
            else
            {
                return(Index());
            }
        }
Exemple #20
0
        /// <summary>
        /// GetdataFromMySQL
        /// </summary>
        /// <param name="ConString"></param>
        public static void GetdataFromMySQL(string ConString)
        {
            string apiResponse       = string.Empty;
            string apiGenPickupRes   = string.Empty;
            string apiGenMenifestRes = string.Empty;

            AWBResponce      awbResponce      = new AWBResponce();
            PickupResponce   pickupResponce   = new PickupResponce();
            ManifestResponce manifestResponce = new ManifestResponce();

            MySqlConnection con = null;

            try
            {
                DataSet        ds           = new DataSet();
                AWBRequest     objdetails   = new AWBRequest();
                orderDetails   orderDetails = new orderDetails();
                IConfiguration config       = new ConfigurationBuilder().AddJsonFile("appsettings.json", true, true).Build();

                string ClientAPIURL = config.GetSection("MySettings").GetSection("ClientAPIURL").Value;
                con = new MySqlConnection(ConString);
                MySqlCommand cmd = new MySqlCommand("SP_PHYGetOrderdetailForAWB", con)
                {
                    CommandType = System.Data.CommandType.StoredProcedure
                };
                cmd.Connection.Open();
                MySqlDataAdapter da = new MySqlDataAdapter(cmd);
                da.Fill(ds);
                cmd.Connection.Close();
                if (ds != null && ds.Tables[0] != null)
                {
                    for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                    {
                        try
                        {
                            if (ds != null && ds.Tables[1] != null)
                            {
                                objdetails = new AWBRequest()
                                {
                                    pickup_postcode   = ds.Tables[1].Rows[i]["pickup_postcode"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[1].Rows[i]["pickup_postcode"]),
                                    delivery_postcode = ds.Tables[1].Rows[i]["delivery_postcode"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[1].Rows[i]["delivery_postcode"]),
                                    weight            = ds.Tables[1].Rows[i]["Weight"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[1].Rows[i]["Weight"]),
                                    orderDetails      = new orderDetails()
                                };
                            }

                            orderDetails = new orderDetails
                            {
                                Id                    = ds.Tables[0].Rows[i]["ID"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["ID"]),
                                order_id              = ds.Tables[0].Rows[i]["InvoiceNo"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["InvoiceNo"]),
                                order_date            = ds.Tables[0].Rows[i]["Date"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["Date"]),
                                billing_customer_name = ds.Tables[0].Rows[i]["CustomerName"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["CustomerName"]),
                                billing_address       = ds.Tables[0].Rows[i]["ShippingAddress"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["ShippingAddress"]),
                                billing_city          = ds.Tables[0].Rows[i]["City"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["City"]),
                                billing_pincode       = ds.Tables[0].Rows[i]["delivery_postcode"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["delivery_postcode"]),
                                billing_state         = ds.Tables[0].Rows[i]["State"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["State"]),
                                billing_country       = ds.Tables[0].Rows[i]["Country"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["Country"]),
                                //billing_email = ds.Tables[0].Rows[i]["EmailID"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["EmailID"]),
                                billing_phone          = ds.Tables[0].Rows[i]["MobileNumber"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["MobileNumber"]),
                                shipping_customer_name = ds.Tables[0].Rows[i]["CustomerName"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["CustomerName"]),
                                shipping_address       = ds.Tables[0].Rows[i]["ShippingAddress"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["ShippingAddress"]),
                                shipping_city          = ds.Tables[0].Rows[i]["City"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["City"]),
                                shipping_pincode       = ds.Tables[0].Rows[i]["delivery_postcode"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["delivery_postcode"]),
                                shipping_country       = ds.Tables[0].Rows[i]["Country"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["Country"]),
                                shipping_state         = ds.Tables[0].Rows[i]["State"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["State"]),
                                //shipping_email = ds.Tables[0].Rows[i]["EmailID"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["EmailID"]),
                                shipping_phone          = ds.Tables[0].Rows[i]["MobileNumber"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["MobileNumber"]),
                                shipping_is_billing     = true,
                                billing_email           = "*****@*****.**",
                                shipping_email          = "*****@*****.**",
                                payment_method          = "Prepaid",
                                pickup_location         = "Test",
                                channel_id              = "633828",
                                billing_last_name       = "",
                                billing_address_2       = "",
                                billing_alternate_phone = "",
                                shipping_last_name      = "",
                                shipping_address_2      = "",
                                sub_total     = ds.Tables[0].Rows[i]["Amount"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["Amount"]),
                                length        = ds.Tables[0].Rows[i]["Length"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["Length"]),
                                breadth       = ds.Tables[0].Rows[i]["Breath"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["Breath"]),
                                height        = ds.Tables[0].Rows[i]["Height"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["Height"]),
                                weight        = ds.Tables[0].Rows[i]["Weight"] == DBNull.Value ? 0 : Convert.ToDecimal(ds.Tables[0].Rows[i]["Weight"]),
                                StoreDelivery = Convert.ToBoolean(ds.Tables[0].Rows[i]["StoreDelivery"]),
                                TenantId      = ds.Tables[0].Rows[i]["TenantId"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["TenantId"]),
                                StoreId       = ds.Tables[0].Rows[i]["StoreId"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["StoreId"]),
                                ProgramCode   = ds.Tables[0].Rows[i]["ProgramCode"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["ProgramCode"]),
                                order_items   = new List <order_items>()
                            };
                            List <order_items> listobj = new List <order_items>();

                            string ItemIDs = "";
                            for (int j = 0; j < ds.Tables[2].Rows.Count; j++)
                            {
                                if (Convert.ToInt32(ds.Tables[2].Rows[j]["OrderID"]) == Convert.ToInt32(orderDetails.Id))
                                {
                                    order_items objorder_Items = new order_items()
                                    {
                                        OrderItemID   = ds.Tables[2].Rows[j]["ID"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[2].Rows[j]["ID"]),
                                        name          = ds.Tables[2].Rows[j]["ItemName"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[2].Rows[j]["ItemName"]),
                                        sku           = ds.Tables[2].Rows[j]["ItemID"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[2].Rows[j]["ItemID"]),
                                        units         = ds.Tables[2].Rows[j]["Quantity"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[2].Rows[j]["Quantity"]),
                                        selling_price = ds.Tables[2].Rows[j]["ItemPrice"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[2].Rows[j]["ItemPrice"])
                                    };
                                    listobj.Add(objorder_Items);
                                    ItemIDs += ds.Tables[2].Rows[j]["ID"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[2].Rows[j]["ID"]) + ",";
                                }
                            }
                            ItemIDs = ItemIDs.TrimEnd(',');
                            /*Check the Pincode Deliver or not*/

                            HSChkCourierAvailibilty hSChkCourierAvailibilty = new HSChkCourierAvailibilty
                            {
                                Pickup_postcode   = objdetails.pickup_postcode,
                                Delivery_postcode = objdetails.delivery_postcode
                            };

                            ResponseCourierAvailibilty responseCourierAvailibilty = new ResponseCourierAvailibilty();
                            responseCourierAvailibilty = CheckClientPinCodeForCourierAvailibilty(hSChkCourierAvailibilty, orderDetails.TenantId, orderDetails.Id, ClientAPIURL);

                            /*Check the Pincode Deliver or not*/
                            if (responseCourierAvailibilty.Available == "false")
                            {
                                if (orderDetails.StoreDelivery == true)
                                {
                                    AddStoreResponse(orderDetails.Id, ItemIDs, orderDetails.TenantId, true, ConString);
                                }
                                else
                                {
                                    AddStoreResponse(orderDetails.Id, ItemIDs, orderDetails.TenantId, false, ConString);
                                }
                            }
                            else if (responseCourierAvailibilty.Available == "true")
                            {
                                orderDetails.order_items = listobj;
                                ItemIDs = ItemIDs.TrimEnd(',');
                                objdetails.orderDetails = orderDetails;
                                string apiReq = JsonConvert.SerializeObject(objdetails);
                                apiResponse = CommonService.SendApiRequest(ClientAPIURL + "/api/ShoppingBag/GetCouriersPartnerAndAWBCode", apiReq);
                                awbResponce = JsonConvert.DeserializeObject <AWBResponce>(apiResponse);
                                if (awbResponce.data != null)
                                {
                                    if (awbResponce.data.awb_code != "" && awbResponce.data.courier_name != "" && awbResponce.statusCode == "200")
                                    {
                                        InsertCourierResponse(orderDetails.Id, ItemIDs, awbResponce.data.awb_code, awbResponce.data.courier_company_id, awbResponce.data.courier_name, awbResponce.data.order_id, awbResponce.data.shipment_id, ConString);

                                        CommonService.SmsWhatsUpDataSend(orderDetails.TenantId, 0, orderDetails.ProgramCode, orderDetails.Id, ClientAPIURL, "AWBAssigned", ConString);

                                        if (awbResponce != null)
                                        {
                                            if (awbResponce.data != null)
                                            {
                                                if (awbResponce.data.shipment_id != null)
                                                {
                                                    PickupManifestRequest pickupManifestRequest = new PickupManifestRequest()
                                                    {
                                                        shipmentId = new List <int> {
                                                            Convert.ToInt32(awbResponce.data.shipment_id)
                                                        }
                                                    };

                                                    try
                                                    {
                                                        string apiGenPickupReq = JsonConvert.SerializeObject(pickupManifestRequest);
                                                        apiGenPickupRes = CommonService.SendApiRequest(ClientAPIURL + "/api/ShoppingBag/GeneratePickup", apiGenPickupReq);
                                                        pickupResponce  = JsonConvert.DeserializeObject <PickupResponce>(apiGenPickupRes);
                                                        //if (pickupResponce.response.pickupTokenNumber != "")
                                                        //{
                                                        //    UpdateGeneratePickupManifest(orderDetails.Id, orderDetails.TenantId, orderDetails.Id, "Pickup", ConString);
                                                        //}
                                                        if (pickupResponce.status_code == 0 && pickupResponce.pickupStatus == "1")
                                                        {
                                                            if (pickupResponce.response != null)
                                                            {
                                                                if (pickupResponce.response.pickupTokenNumber != null)
                                                                {
                                                                    //UpdateGeneratePickupManifest(ID, "Pickup", ConString, TenantId);
                                                                    UpdateGeneratePickupManifest(orderDetails.Id, orderDetails.TenantId, orderDetails.Id, "Pickup", ConString);

                                                                    CommonService.SmsWhatsUpDataSend(orderDetails.TenantId, 0, orderDetails.ProgramCode, orderDetails.Id, ClientAPIURL, "PickupScheduled", ConString);
                                                                }
                                                            }
                                                        }
                                                        else
                                                        {
                                                            ExLogger(orderDetails.Id, orderDetails.order_id, Convert.ToString(DateTime.Now), Convert.ToString(orderDetails.StoreId), pickupResponce.status_code + " : " + pickupResponce.message, apiGenPickupRes, ConString);
                                                        }
                                                    }
                                                    catch (Exception ex)
                                                    {
                                                        ExLogger(orderDetails.Id, orderDetails.order_id, orderDetails.order_date, Convert.ToString(orderDetails.StoreId), ex.Message, ex.StackTrace, ConString);
                                                    }
                                                    try
                                                    {
                                                        string apiGenMenifestReq = JsonConvert.SerializeObject(pickupManifestRequest);
                                                        apiGenMenifestRes = CommonService.SendApiRequest(ClientAPIURL + "/api/ShoppingBag/GenerateManifest", apiGenMenifestReq);
                                                        manifestResponce  = JsonConvert.DeserializeObject <ManifestResponce>(apiGenMenifestRes);
                                                        if (manifestResponce.status_code == 0)
                                                        {
                                                            if (manifestResponce.status == "1" && manifestResponce.manifestUrl != null && manifestResponce.manifestUrl != "")
                                                            {
                                                                UpdateGeneratePickupManifest(orderDetails.Id, orderDetails.TenantId, orderDetails.Id, "Manifest", ConString);

                                                                CommonService.SmsWhatsUpDataSend(orderDetails.TenantId, 0, orderDetails.ProgramCode, orderDetails.Id, ClientAPIURL, "ManifestGenerated", ConString);
                                                            }
                                                            else
                                                            {
                                                                ExLogger(orderDetails.Id, orderDetails.order_id, Convert.ToString(DateTime.Now), Convert.ToString(orderDetails.StoreId), manifestResponce.status, apiGenMenifestRes, ConString);
                                                            }
                                                        }
                                                        else
                                                        {
                                                            ExLogger(orderDetails.Id, orderDetails.order_id, Convert.ToString(DateTime.Now), Convert.ToString(orderDetails.StoreId), manifestResponce.status_code + " : " + manifestResponce.message, apiGenMenifestRes, ConString);
                                                        }
                                                    }
                                                    catch (Exception ex)
                                                    {
                                                        ExLogger(orderDetails.Id, orderDetails.order_id, orderDetails.order_date, Convert.ToString(orderDetails.StoreId), ex.Message, ex.StackTrace, ConString);
                                                    }
                                                }
                                            }
                                        }
                                    }
                                    else
                                    {
                                        AddStoreResponse(orderDetails.Id, ItemIDs, orderDetails.TenantId, false, ConString);
                                    }
                                }
                                else
                                {
                                    AddStoreResponse(orderDetails.Id, ItemIDs, orderDetails.TenantId, false, ConString);
                                }
                            }
                        }
                        catch (Exception Ex)
                        {
                            ExLogger(orderDetails.Id, orderDetails.order_id, orderDetails.order_date, Convert.ToString(orderDetails.StoreId), Ex.Message, Ex.StackTrace, ConString);
                        }
                    }
                }
            }
            catch (Exception ex)
            {
            }
            finally
            {
                if (con != null)
                {
                    con.Close();
                }
                GC.Collect();
            }
        }