public dynamic Displaymissedorders([FromBody] orderdetails od) { string plantid = od.plantid; int metricid = od.metricid; int week = od.week; switch (metricid) { case 1: break; case 5: var reason = _context.Metricbasedreasoncodeview.Where(p => p.MetricId == metricid).Select(q => new { q.ReasonCode, q.ReasonCodeId }).ToArray(); var orderdetails = (from shopflor in _context.ShopFloorComformance join resoncode in _context.ReasonCodes on shopflor.ReasonCodeId equals resoncode.ReasonCodeId into joinreason from _reasoncode in joinreason.DefaultIfEmpty() where shopflor.PlantId == plantid && shopflor.Week == week && shopflor.Flag == "Miss" //&& _reasoncode.Flag == 1 select new { _reasoncode.ReasonCode, shopflor.ReasonCodeId, shopflor.Resource, shopflor.PlantName, shopflor.PlantId, shopflor.ProcessOrder, shopflor.OrderQuantity, shopflor.MaterialId, shopflor.MaterialName, shopflor.OrderQuantityUnit, shopflor.Flag, shopflor.FinishDateConfirmed, shopflor.FinishDateScheduled, shopflor.ReasonCornerFlag }).ToArray(); // return new Array[] { orders, reason, reasoncode }; return(new Array[] { orderdetails, reason }); break; } return(null); }
public List <orderdetails> orderdetails(string orderdetails, string restcode) { try { GetConnectionString getConnectionString = new GetConnectionString(); string ConnectionString = getConnectionString.CustomizeConnectionString(restcode); SqlConnection Conn = new SqlConnection(ConnectionString); Conn.Open(); List <orderdetails> ordetails = new List <orderdetails>(); if (Conn.State != System.Data.ConnectionState.Open) { Conn.Open(); } SqlCommand cmd = new SqlCommand("sploadcartforconformpage", Conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Orderid", orderdetails); SqlDataReader _Reader = cmd.ExecuteReader(); while (_Reader.Read()) { orderdetails objCust = new orderdetails(); objCust.Price = Convert.ToInt16(_Reader["price"]); objCust.Quantity = Convert.ToInt16(_Reader["Quantity"]); objCust.ProductName = _Reader["ProductName"].ToString(); //objCust.Image = _Reader["Image"]; ordetails.Add(objCust); } return(ordetails); } catch (Exception ex) { throw ex; } //finally //{ // //if (Conn != null) // //{ // // //if (Conn.State == ConnectionState.Open) // // //{ // // // Conn.Close(); // // // Conn.Dispose(); // // //} // //} //} //} }
public IHttpActionResult placeorder([FromBody] villageorders order, [FromUri] string email, [FromUri] string pid) { var data = orderrepo.InsertOrder(order, email); var cartdetails = prdctdetails.getproductbyid(pid).ToArray(); orderdetails orderdetail = new orderdetails(); for (var i = 0; i < cartdetails.Length; i++) { var detail = cartdetails[i]; orderdetail.ProductId = detail.id.ToString(); orderdetail.Quantity = detail.Quantity; orderdetail.orderid = data; var orderdetails = orderrepo.InsertOrderdetails(orderdetail); } return(Json(data)); }
public string check(string paymentmethod) { foodorder objOrder = new foodorder(); objOrder.ORDERDATE = DateTime.Now; objOrder.CUSTID = GetSessionUser().CUSTID; objOrder.PAYMENTMETHOD = paymentmethod; int amount = 0; foreach (var item in GetSessionCart()) { amount += item.subtotal; } objOrder.AMOUNT = amount; orderdetails objOrderDetails = new orderdetails(); MySqlConnection conn = Shared.BaseManager.PrimaryConnection(); conn.Open(); var transaction = conn.BeginTransaction(); string ret = foodorderManager.Savefoodorder(objOrder, conn, transaction); int orderid; if (!ret.Equals(Shared.Constants.MSG_ERR_DBSAVE.Text)) { orderid = int.Parse(ret); foreach (var item in GetSessionCart()) { if (!ret.Equals(Shared.Constants.MSG_ERR_DBSAVE.Text)) { objOrderDetails.ORDERID = orderid; objOrderDetails.ITEMID = item.ITEMID; objOrderDetails.QUANTITY = item.QUANTITY; ret = orderdetailsManager.Saveorderdetails(objOrderDetails, conn, transaction); } } if (paymentmethod == "Wallet") { wallet objwallet = new wallet(); List <wallet> lstwallet = walletManager.Getwallet("CustomerID='" + GetSessionUser().CUSTID + "'"); if (lstwallet.First().BALANCE > amount) { objwallet.WALLETID = lstwallet.First().WALLETID; objwallet.CUSTOMERID = GetSessionUser().CUSTID; objwallet.BALANCE = lstwallet.First().BALANCE - amount; ret = walletManager.Savewallet(objwallet, conn, transaction); } else { ret = "insufficient amount in wallet"; transaction.Rollback(); conn.Close(); conn.Dispose(); return(ret); } } else if (paymentmethod == "MasterCard") { } if (ret.Equals(Shared.Constants.MSG_OK_DBSAVE.Text)) { payment objpayment = new payment(); objpayment.ORDERID = orderid; objpayment.PAYMENTDATE = DateTime.Now; ret = paymentManager.Savepayment(objpayment, conn, transaction); } if (ret.Equals(Shared.Constants.MSG_OK_DBSAVE.Text)) { transaction.Commit(); conn.Close(); conn.Dispose(); return(Shared.Constants.MSG_SUCCESS.Text); } } transaction.Rollback(); conn.Close(); conn.Dispose(); return(Shared.Constants.MSG_ERR_SERVER.Text); }
public void View1(orderdetails obj) { string ret = orderdetailsManager.Saveorderdetails(obj); }