public IHttpActionResult PutOrder_details(int id, Order_details order_details) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != order_details.ID) { return(BadRequest()); } db.Entry(order_details).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!Order_detailsExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult DeleteConfirmed(string id) { Order_details order_details = db.Order_details.Find(id); db.Order_details.Remove(order_details); db.SaveChanges(); return(RedirectToAction("Index")); }
public IHttpActionResult GetOrder_details(int id) { Order_details order_details = db.Order_details.Find(id); if (order_details == null) { return(NotFound()); } return(Ok(order_details)); }
public ActionResult Edit([Bind(Include = "Order_detail_no,Order_id,Service_details_Id,Appointment_date,Session_id,Designer_id,Coupon_id,Last_updata_date")] Order_details order_details) { if (ModelState.IsValid) { db.Entry(order_details).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Order_id = new SelectList(db.Order, "Order_id", "Order_id", order_details.Order_id); ViewBag.Service_details_Id = new SelectList(db.Service_details, "Service_details_Id", "Name", order_details.Service_details_Id); return(View(order_details)); }
public IHttpActionResult PostOrder_details(Order_details order_details) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.Order_details.Add(order_details); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = order_details.ID }, order_details)); }
// GET: Order_details/Details/5 public ActionResult Details(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Order_details order_details = db.Order_details.Find(id); if (order_details == null) { return(HttpNotFound()); } return(View(order_details)); }
public async void AddOrderDetailsAsync(int orderId, int product_id, int size_id, int amount) { using (HttpClient client = new HttpClient()) { String request = "api/Orders/AddOrderDetails"; client.BaseAddress = this.UriApi; client.DefaultRequestHeaders.Accept.Clear(); client.DefaultRequestHeaders.Accept.Add(this.Header); Order_details orderDetails = new Order_details(orderId, product_id, size_id, amount); String json = JsonConvert.SerializeObject(orderDetails); StringContent content = new StringContent(json, Encoding.UTF8, "application/json"); await client.PostAsync(request, content); } }
public IHttpActionResult DeleteOrder_details(int id) { Order_details order_details = db.Order_details.Find(id); if (order_details == null) { return(NotFound()); } db.Order_details.Remove(order_details); db.SaveChanges(); return(Ok(order_details)); }
public ActionResult Edit(Order_details order) { try { Order_details orderToEdit = db.Order_details.Find(order.Id); UpdateModel(orderToEdit); db.SaveChanges(); return(RedirectToAction("Index")); } catch { return(View()); } }
// GET: Order_details/Edit/5 public ActionResult Edit(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Order_details order_details = db.Order_details.Find(id); if (order_details == null) { return(HttpNotFound()); } ViewBag.Order_id = new SelectList(db.Order, "Order_id", "Order_id", order_details.Order_id); ViewBag.Service_details_Id = new SelectList(db.Service_details, "Service_details_Id", "Name", order_details.Service_details_Id); return(View(order_details)); }
// GET: OrdersAdmin/Edit/5 public ActionResult Edit(int id) { Order_details details = db.Order_details.Find(id); List <Payment> paymentTypes = db.Payment.ToList(); ViewBag.PaymentTypes = new SelectList(paymentTypes, "Id", "Name"); List <Delivery> deliveryTypes = db.Delivery.ToList(); ViewBag.DeliveryTypes = new SelectList(deliveryTypes, "Id", "Name"); List <Status> status = db.Status.ToList(); ViewBag.Status = new SelectList(status, "Id", "Name"); return(View(details)); }
public ActionResult Create(Orders order) { try { List <ShoppingCart> listCart = (List <ShoppingCart>)Session["Cart"]; db.Orders.Add(order); db.SaveChanges(); foreach (ShoppingCart cart in listCart) { Order_item orderItem = new Order_item() { OrderID = order.Id, ProductID = cart.Product.Id, Quantity = cart.Quantity }; db.Order_item.Add(orderItem); db.SaveChanges(); } Session.Remove("Cart"); Order_details orderDetails = new Order_details() { Order = order, StatusID = 1 }; db.Order_details.Add(orderDetails); db.SaveChanges(); // tutaj wyslac na strone ze zamowienie zostalo zlozone i ze liste zamowien mozna zobaczyc np. w profilu // i oczywisice zrobic trzeba w profilu mozliwosc zobaczenia zamowien return(RedirectToAction("Index", "Home", new { area = "" })); } catch { // Error - Trzeba zrobic strone dla View ze blad wystapil albo jakas ogolna ze blad wystapil // bo jak teraz wywali errora gdzies to zwroci ze ta strona nie istnieje :P return(View()); } }
// GET: OrdersAdmin/Details/5 public ActionResult Details(int id) { Order_details details = db.Order_details.Find(id); return(View(details)); }
public void _intoDB(string cartInfo, string Status, string OrderNo, int PayWay_id, int cus_id) { var result = Newtonsoft.Json.JsonConvert.DeserializeObject <List <CartDetail> >(cartInfo); AppleLaLaRepository <Order> repo_order = new AppleLaLaRepository <Order>(context); AppleLaLaRepository <Order_details> repo_Order_details = new AppleLaLaRepository <Order_details>(context); AppleLaLaRepository <Work_schedule> repo_Work_schedule = new AppleLaLaRepository <Work_schedule>(context); Order _order = new Order { Order_id = OrderNo, Payway_id = PayWay_id, Cust_id = cus_id, Order_date = DateTime.Now, Last_updata_date = DateTime.Now, }; repo_order.Create(_order); context.SaveChanges(); var SessionId = 0; var time = 1; foreach (var item in result) { switch (int.Parse(item.Session)) { case 11: SessionId = 1; break; case 12: SessionId = 2; break; case 13: SessionId = 3; break; case 14: SessionId = 4; break; case 15: SessionId = 5; break; case 16: SessionId = 6; break; case 17: SessionId = 7; break; case 18: SessionId = 8; break; case 19: SessionId = 9; break; case 20: SessionId = 10; break; case 21: SessionId = 11; break; default: SessionId = 0; break; } Order_details order_Details = new Order_details() { Order_detail_no = DateTimeOffset.Now.AddSeconds(time).ToUnixTimeSeconds().ToString(), Order_id = OrderNo, Service_details_Id = (from sd in context.Service_details where sd.Name == item.Services select sd.Service_details_Id).First(), Appointment_date = item.Date, Session_id = SessionId, Designer_id = (from d in context.Designer where d.Name == item.Designer select d.Designer_id).First(), Last_updata_date = DateTime.Now, }; repo_Order_details.Create(order_Details); var cnstr = ConfigurationManager.ConnectionStrings["AppleLaLaModel"].ConnectionString; using (var conn = new SqlConnection(cnstr)) { conn.Open(); string sql = "select ws.Schedule_id, ws.Designer_id,ws.Date,ws.Session_id,ws.On_work_flag from[Work_schedule] ws inner join[Designer] d on ws.Designer_id = d.Designer_id where d.Name = @Name and ws.Date = @Date and ws.Session_id = @Session_id "; var target = conn.Query <dynamic>(sql, new { Name = item.Designer, Date = item.Date, Session_id = SessionId }); foreach (var i in target) { Work_schedule Work_schedule = new Work_schedule() { Schedule_id = i.Schedule_id, Designer_id = i.Designer_id, Date = i.Date, Session_id = i.Session_id, On_work_flag = "N" }; repo_Work_schedule.Update(Work_schedule); } } context.SaveChanges(); time++; } }
public JsonResult PlaceOrderAjax(string captcha) { Object data = null; var message = ""; try { string response = captcha; string secretKey = "6Ldx_iQUAAAAANOg9tYwABMd6C2os33YQ5pPt2EY"; var client = new WebClient(); var result = client.DownloadString(string.Format("https://www.google.com/recaptcha/api/siteverify?secret={0}&response={1}", secretKey, response)); var obj = JObject.Parse(result); var status = (bool)obj.SelectToken("success"); if (status) { User u = (User)Session["User"]; Order o = db.Orders.Where(e => e.U_id == u.U_id && e.Last == 1).FirstOrDefault(); if (o != null) { o.Last = 0; db.SaveChanges(); } var cart = db.Carts.Where(e => e.U_id == u.U_id).ToList(); Address add = db.Addresses.Where(e => e.U_id == u.U_id).FirstOrDefault(); double grandTotal = 0; foreach (var x in cart) { Product p = db.Products.Find(x.P_id); double subtotal = (int)x.Quantity * (int)p.Price; grandTotal = subtotal + grandTotal; } Order order = new Order(); order.O_id = 2; order.U_id = u.U_id; order.A_id = add.A_id; order.Date = DateTime.Now.ToString(); order.S_id = 1; order.Last = 1; order.Grand_total = grandTotal; db.Orders.Add(order); db.SaveChanges(); var orderId = db.Orders.Where(e => e.U_id == u.U_id && e.Last == 1).FirstOrDefault(); foreach (var x in cart) { Product p = db.Products.Find(x.P_id); Order_details orderDetail = new Order_details(); orderDetail.Od_id = 1; orderDetail.O_id = orderId.O_id; orderDetail.P_id = x.P_id; orderDetail.Quantity = x.Quantity; int price = (int)x.Quantity * (int)p.Price; orderDetail.Price = price; db.Order_details.Add(orderDetail); } db.SaveChanges(); var remove = db.Carts.Where(e => e.U_id == u.U_id); foreach (var x in remove) { db.Carts.Remove(x); } db.SaveChanges(); message = "Your Order is Placed!"; } else { message = "Google reCaptcha Validation Failed!"; } data = new { output = message }; } catch (Exception e) { message = "Some Thing Went Wrong!"; data = new { output = message }; } return(Json(data, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 新增一筆訂單資料. /// </summary> /// <param name="orders"></param> /// <returns></returns> public int AddOrder(Orders orders) { string SqlOrder = @"INSERT INTO [Orders] ([CustomerID] ,[EmployeeID] ,[OrderDate] ,[RequiredDate] ,[ShippedDate] ,[Freight] ,[ShipName]) VALUES (@CustomerID ,@EmployeeID ,@OrderDate ,@RequiredDate ,@ShippedDate ,@Freight ,@ShipName);select @@IDENTITY"; string SqlOrderDetails = @"INSERT INTO [dbo].[Order Details] ([OrderID] ,[ProductID] ,[UnitPrice] ,[Quantity] ,[Discount]) VALUES (@OrderID ,@ProductID ,@UnitPrice ,@Quantitys ,@Discount)"; SqlConnection connection = new SqlConnection(new DBConn().ConnectionString); SqlTransaction tran = null; try { DataAccess dal = new DataAccess(); int result = 0; connection.Open(); tran = connection.BeginTransaction(); SqlCommand cmd = new SqlCommand(SqlOrder, connection, tran); SqlParameter[] ParamOrder = new SqlParameter[] { new SqlParameter("@CustomerID", orders.CustomerID), new SqlParameter("@EmployeeID", orders.EmployeeID), new SqlParameter("@OrderDate", orders.OrderDate), new SqlParameter("@RequiredDate", orders.RequiredDate), new SqlParameter("@ShippedDate", orders.ShippedDate), new SqlParameter("@Freight", orders.Freight), new SqlParameter("@ShipName", orders.ShipName) }; object identity = dal.ExecuteScalar(cmd, SqlOrder, CommandType.Text, ref connection, ref tran, ParamOrder); Order_details order_detail = orders.ORDER_DETAILS.FirstOrDefault(); if (order_detail != null) { SqlParameter[] ParamOrderDetails = new SqlParameter[] { new SqlParameter("@OrderID", identity), new SqlParameter("@ProductID", order_detail.ProductID), new SqlParameter("@UnitPrice", order_detail.UnitPrice), new SqlParameter("@Quantitys", order_detail.Quantity), new SqlParameter("@Discount", order_detail.Discount) }; result += dal.ExecuteSQL(cmd, SqlOrderDetails, CommandType.Text, ref connection, ref tran, ParamOrderDetails); } tran.Commit(); return(result); } catch (Exception ex) { tran.Rollback(); throw ex; } finally { if (connection.State != ConnectionState.Closed) { connection.Close(); } connection.Dispose(); } }