public ActionResult CartProduct() { string date = Request["OrderDate"]; int id = Convert.ToInt32(Request["CustomerID"]); string status = Request["status"]; int ProductID = Convert.ToInt32(Request["ProductID"]); orders order = new orders(); order.OrderDate = date; order.CustomerID = id; order.status = status; order.ProductID = ProductID; dbo.AddProductMember(order); return(RedirectToAction("CartMember", new { id = Session["CustomerID"] })); }
orders createorder(orderinfo param) { orders order = new orders(); order.ordersInfo = Newtonsoft.Json.JsonConvert.SerializeObject(param); order.startlocation = param.startingPoint; order.endlocation = param.endingPoint; order.state = 0; order.userprice = (float)param.price; order.driverprice = (float)param.driverprice; order.orderType = param.riderType; order.routeid = int.Parse(param.routeid); order.StartTime = param.startDate; return(order); }
public HttpResponseMessage Delete(string id) { orders orders = new orders(); string outMessage = string.Empty; if (orders.Delete(id, out outMessage)) { var message = Request.CreateResponse(HttpStatusCode.OK); return(message); } else { return(Request.CreateErrorResponse(HttpStatusCode.Forbidden, outMessage)); } }
private void MakeOrder_Click(object sender, RoutedEventArgs e) { DateTime myTime = DateTime.Now.ToLocalTime(); orders item = new orders() { time = myTime, status_id = status, table_id = tabl_id, waiter_id = wait_id }; _db.orders.Add(item); _db.SaveChanges(); MessageBox.Show("Столик успішно заброньованo."); }
// GET: orders/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } orders orders = db.Orders.Find(id); if (orders == null) { return(HttpNotFound()); } ViewBag.customerId = new SelectList(db.Customers, "customerId", "customerLastName", orders.customerId); return(View(orders)); }
private bool guardarPedido(string[] pedidos, string id, string side) { try{ string pedido = ""; orderDta orders = new orderDta(); // Abro el objeto json e inserto el nuevo pedido var service = HttpContext.RequestServices.GetService(typeof(Microsoft.AspNetCore.Hosting.IHostingEnvironment)) as Microsoft.AspNetCore.Hosting.IHostingEnvironment; string folderName = "json/"; string webRootPath = service.WebRootPath; string Path = System.IO.Path.Combine(webRootPath, folderName); // Cargo el json en la entidad orderDta od = JsonConvert.DeserializeObject <orderDta>(System.IO.File.ReadAllText(Path + @"/orders.json")); orders = od; orders order = new orders(); order.mesa = id; order.fecha_hora = DateTime.Now.ToString(); order.entregado = false; order.side = side; foreach (string m in pedidos) { if (!m.Trim().Equals("")) { pedido += m.Trim() + "<br>"; } } order.orden = pedido; od.order.Add(order); // vuelvo a guardar el objeto en el documento json. string objeto = JsonConvert.SerializeObject(od); System.IO.File.WriteAllText(Path + @"/orders.json", objeto); // Uso el inmemory para guardar el pedido de esa mesa y que no vuelvan a hacerlo hasta 3000 seg despues. var cacheEntryOptions = new MemoryCacheEntryOptions().SetSlidingExpiration(TimeSpan.FromSeconds(300)); memoryCache.Set("mesa_" + id + side, pedido, cacheEntryOptions); return(true); } catch (Exception ex) { return(false); } }
public ActionResult OrderDetails(string idOrdersAsString) { try { using (var dc = new MySQLEntities()) { SelectList districts = new SelectList(dc.districts.ToList(), "iddistricts", "name"); ViewBag.Districts = districts; SelectList statuses = new SelectList(dc.status.ToList(), "idstatus", "name"); ViewBag.Statuses = statuses; SelectList customers = new SelectList(dc.customers.ToList(), "idcustomers", "name"); ViewBag.Customers = customers; SelectList worktypes = new SelectList(dc.worktypes.ToList(), "idWorkTypes", "name"); ViewBag.Worktypes = worktypes; SelectList masters = new SelectList(dc.masters.ToList(), "idMasters", "name"); ViewBag.Masters = masters; SelectList works = new SelectList(dc.works.ToList(), "idWorks", "name"); ViewBag.Works = works; var order = new orders(); if (idOrdersAsString == "") { order.idOrders = Guid.NewGuid(); } else { Guid idOrders = new Guid(idOrdersAsString); order = dc.orders.Find(idOrders); } var model = new OrderAndTable(order) { order = order, }; return(PartialView(model)); }; } catch (Exception ex) { return(HttpNotFound()); } }
int IOrdersRepository.AddOrder(orders order) { _efDbContext.Orders.Add(order); _efDbContext.SaveChanges(); var notyfications = new client_notyfications { Id_Client = order.Id_Client, AsRead = false, Message = "Złożono zamówienie o numerze " + order.Id + " w dniu " + order.InsertTime.ToShortDateString() }; _efDbContext.ClientNotyfications.Add(notyfications); _efDbContext.SaveChanges(); return(order.Id); }
public HttpResponseMessage Post([FromBody] orders obj) { orders orders = new orders(); string outMessage = string.Empty; if (orders.Create(obj, out outMessage)) { obj.id = outMessage; var message = Request.CreateResponse(HttpStatusCode.Created, obj); message.Headers.Location = new Uri(Request.RequestUri + obj.id); return(message); } else { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, outMessage)); } }
public async Task <string> ChangeCashPaymentStatus(string paymentstatus, int oid) { orders obj = _ordersServices.GetById(oid);// await _usermanager.GetUserAsync(User); if (obj == null) { return("NotFound"); } else { obj.deliveryboyCheckStaus = "completed"; obj.paymentstatus = paymentstatus; await _ordersServices.UpdateAsync(obj); return("success"); } return(""); }
/// <summary> /// 贡献报表分析 /// </summary> /// <returns></returns> public ActionResult Contribute() { orders searchEntity = new orders(); var db = new LinqHelper().Db; var sql = from line in db.orders_line join order in db.orders on line.odd_order_id equals order.odr_id select new { line.odd_price, line.odd_count, order.odr_cust_name } into tab group tab by tab.odr_cust_name into newGroup select new ContributeReportModel { Name = newGroup.Key, TotalMoney = newGroup.Sum(n => n.odd_count * n.odd_price) }; ViewData["pagerHelper"] = new PageHelper <ContributeReportModel>(sql.ToList(), 1, 10); ViewData["reportData"] = new JavaScriptSerializer().Serialize(ViewData["pagerHelper"] as PageHelper <ContributeReportModel>); SetYeasList(); return(View(searchEntity)); }
public ActionResult View_Collect_Order(String name) { using (var db = new DataBaseContext()) { staff current_staff_obj = db.staff_repository.Where(x => x.name == name).Select(x => x).FirstOrDefault(); List <orders> order_lis = db.orders_repository.Where(i => i.staff_obj.department_obj.department_name == current_staff_obj.department_obj.department_name && i.order_status == "Approved_by_Clerk").ToList(); for (int i = 0; i < order_lis.Count; i++) { orders temp_order = order_lis[i]; order_lis[i].item_obj = temp_order.item_obj; } return(Json(new { status = "ok", order_lis })); } }
//lay schedule_id va room id public List <orders> getRoom_namefordrp() { List <orders> li = new List <orders>(); con.Open(); SqlCommand cmd = new SqlCommand("select * from schedules,rooms where schedules.room_id=rooms.room_id and schedules.schedule_status=0", con); SqlDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { orders orr = new orders(); orr.schedule_id = (int)rd["schedule_id"]; orr.room_name = (string)rd["room_name"]; li.Add(orr); } con.Close(); return(li); }
protected void Button1_Click(object sender, EventArgs e) { Ord = new orders(); Ord.setP_id(p_id.Text); Ord.setPr_number(pr_number.Text); Ord.setS_amount(Convert.ToInt32(amount.SelectedValue)); Ord.setS_date(s_date.Text); Ord.setS_e_id(s_e_id.Text); Ord.setS_get(Convert.ToDouble(s_get.Text)); Ord.setS_id(s_id.Text); Ord.setS_price(Convert.ToInt32(s_price.Text)); Ord.setS_return(Convert.ToDouble(s_return.Text)); Ord.setS_summary(Convert.ToDouble(s_summary.Text)); Ord.setS_way(s_way.Text); bool flag = SS.salePhone(Ord); if (flag) { Response.Write("<script>alert('购买成功!');</script>"); // 建立实例 IncomeExpenseAction IEA = new IncomeExpenseAction(); // 新建收支明细对象 IEA.addIncomeExpense(); // 设置交易内容 IEA.setIEDeal(Ord.getS_summary(), "", "", "", ""); // 设置交易人内容 IEA.setIEDealMan(Ord.getS_date(), "收入", "现金交易", Ord.getS_e_id()); // 设置交易备注 IEA.setIENote(""); // 提交并操作 IEA.submit(); } else { Response.Write("<script>alert('购买失败!');</script>"); } }
public ActionResult Contribute(FormCollection forms) { var db = new LinqHelper().Db; List <ContributeReportModel> list = new List <ContributeReportModel>(); var sql = from line in db.orders_line join order in db.orders on line.odd_order_id equals order.odr_id select new { line.odd_price, line.odd_count, order.odr_cust_name, order.odr_date } into tab group tab by tab.odr_cust_name into newGroup select new ContributeReportModel { Name = newGroup.Key, TotalMoney = newGroup.Sum(n => n.odd_count * n.odd_price), Year = newGroup.Select(n => n.odr_date).FirstOrDefault() }; if (!string.IsNullOrEmpty(forms["odr_cust_name"])) { var s = forms["odr_cust_name"]; sql = sql.Where(c => c.Name.Contains(s)); } if (int.Parse(forms["year"]) > 0) { foreach (var item in sql.ToList()) { if (item.Year.Year.ToString() == forms["year"]) { list.Add(item); } } } else { list = sql.ToList(); } int curPage = int.Parse(forms["curPage"]); orders searchEntity = new orders(); SetYeasList(); UpdateModel <orders>(searchEntity); ViewData["pagerHelper"] = new PageHelper <ContributeReportModel>(list, curPage, 3); ViewData["reportData"] = new JavaScriptSerializer().Serialize(ViewData["pagerHelper"] as PageHelper <ContributeReportModel>); return(View(searchEntity)); }
public IActionResult PurchasePorduct(int productid, int amount) { int? id = HttpContext.Session.GetInt32("Id"); products PurchasedProduct = _context.products.FirstOrDefault(x => x.id == productid); orders neworder = new orders() { usersid = (int)id, productsid = productid, amount = amount, price = Math.Round(PurchasedProduct.price * amount, 2), created_at = DateTime.Now, updated_at = DateTime.Now }; _context.Add(neworder); PurchasedProduct.inventory -= neworder.amount; _context.SaveChanges(); return(RedirectToAction("UserOrder")); }
public ActionResult sendmail(ApplicationUser user, orders o) { var mail = new MailMessage(); var login = new NetworkCredential("*****@*****.**", "mohamed447"); mail.From = new MailAddress("*****@*****.**"); mail.To.Add(new MailAddress(user.Email)); mail.Subject = "Order"; var cust = db.Users.Find(o.custId); mail.Body = ("you have order from :" + cust.UserName + "<br>" + "Delivery address is :" + cust.Delivery_address + "<br/>" + "Customer number is :" + cust.phone); var smtpclient = new SmtpClient("smtp.gmail.com", 587); smtpclient.EnableSsl = true; smtpclient.Credentials = login; smtpclient.UseDefaultCredentials = true; smtpclient.Send(mail); return(RedirectToAction("Index")); }
private void getdata(int id) { accountinfo.Visible = false; createBtn.Text = "Save"; bankdiv.Visible = false; trans_date_time.Visible = false; totalprice.Visible = false; // get data from the given id OrderModel db = new OrderModel(); orders user = db.Get_order_userinfo(id); // fill text boxes with the new data FullName.Text = user.full_name; email.Text = user.email; ContactNum.Text = Convert.ToString(user.contact_num); address.Text = user.current_address; }
public OrderMasterData(orders sd) { Command = sd.command; RequestId = NewGuid(sd.requestId); ManId = sd.ManifestId; ORD_NO = sd.ORD_NO; DLR_NO = (int)sd.DLR_NO; DLR_PO = sd.DLR_PO; ORD_DTE = sd.ORD_DTE; SHP_DTE = sd.SHP_DTE; SHIP_DTE = sd.SHIP_DTE; CMNT1 = sd.CMNT1; CMNT2 = sd.CMNT2; DLR_NME = sd.DLR_NME; DLR_ADDR = sd.DLR_ADDR; DLR_ADDR2 = sd.DLR_ADDR2; SHP_NME = sd.SHP_NME; SHP_ADDR = sd.SHP_ADDR; SHP_ADDR2 = sd.SHP_ADDR2; SHP_CSZ = sd.SHP_CSZ; SHP_TEL = sd.SHP_TEL; SHP_CT = sd.SHP_CT; SHP_ZIP = sd.SHP_ZIP; CUS_NME = sd.CUS_NME; CUS_ADDR = sd.CUS_ADDR; CUS_CSZ = sd.CUS_CSZ; CUS_TEL = sd.CUS_TEL; RTE_CDE = sd.RTE_CDE; ORD_TYPE = sd.ORD_TYPE; ENT_BY = sd.ENT_BY; ORD_AMT = sd.ORD_AMT; ENT_BY = sd.ENT_BY; WIN_QTY = sd.WIN_QTY; STK_QTY = sd.STK_QTY; CMP_QTY = sd.CMP_QTY; SHP_QTY = sd.SHP_QTY; SHP_AMT = sd.SHP_AMT; MISC_TEXT = sd.MISC_TEXT; IsSelected = false; }
public Int64 Update(orders objorders) { Int64 result = 0; try { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "orders_Update"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = ConnectionString; SqlParameter param = new SqlParameter(); param.ParameterName = "@oid"; param.Value = objorders.oid; param.SqlDbType = SqlDbType.BigInt; param.Direction = ParameterDirection.InputOutput; cmd.Parameters.Add(param); cmd.Parameters.AddWithValue("@uid", objorders.uid); cmd.Parameters.AddWithValue("@productquantites", objorders.productquantites); cmd.Parameters.AddWithValue("@billpaidornot", objorders.billpaidornot); cmd.Parameters.AddWithValue("@amount", objorders.amount); cmd.Parameters.AddWithValue("@discount", objorders.discount); cmd.Parameters.AddWithValue("@tax", objorders.tax); cmd.Parameters.AddWithValue("@totalamount", objorders.totalamount); cmd.Parameters.AddWithValue("@orderdate", objorders.orderdate); cmd.Parameters.AddWithValue("@isdelete", objorders.isdelete); ConnectionString.Open(); cmd.ExecuteNonQuery(); result = Convert.ToInt64(param.Value); } catch (Exception ex) { ErrHandler.writeError(ex.Message, ex.StackTrace); return(result); } finally { ConnectionString.Close(); } return(result); }
public IActionResult Update(orders order) { if (HttpContext.Session.GetString("accRole").Equals("Admin") || HttpContext.Session.GetString("accRole").Equals("Technician")) { try { var result = db.orders.FirstOrDefault(item => item.Order_id.Equals(order.Order_id)); if (db.bills.FirstOrDefault(item => item.Bill_order_id.Equals(order.Order_id)) == null) { result.Order_feasibility = order.Order_feasibility; result.Order_status = order.Order_status; if (result.Order_status.Equals("Complete")) { var plans = db.plans_orders.Where(item => item.Plans_orders_order_id.Equals(order.Order_id)).ToList(); foreach (var item in plans) { item.Plans_orders_status = "Connected"; } } db.SaveChanges(); return(RedirectToAction("Index", "Orders")); } else { ViewBag.Msg = "This order can not be edited anymore because it has been billed!"; } return(View(@"~/Views/Admin/orders/Update.cshtml", result)); } catch (Exception ex) { ModelState.AddModelError("Error: ", ex.Message); } } return(View(@"~/Views/Admin/ErrorPemission.cshtml")); }
//check update private void updateCheckBtn_Click(object sender, RoutedEventArgs e) { CheckTable item = (checksGrid.SelectedItem as CheckTable); checks item1 = _db.checks.First(c => c.id == item.id); item1.count = item.count; menu item4 = _db.menu.First(c => c.id == item1.menu_id); item4.price = item.price; item4.size = item.size; item4.unit_of_measurement_id = _db.units_of_measurement.First(c => c.name == item.unit_measurement).id; item4.dish_name = item.dishname; orders item2 = _db.orders.First(c => c.id == item1.order_id); item2.waiter_id = _db.waiters.First(c => c.name == item.waiter_name).id; item2.table_id = _db.platens.First(c => c.number == item.id_table).id; _db.SaveChanges(); checksGrid.ItemsSource = GetCheck(); MessageBox.Show("Зміни успішно збережено"); }
public static orders Map(this ordersDTO dto) { var order = new orders() { id = dto.id, customer_name = dto.customer_name, customer_email = dto.customer_email, customer_mobile = dto.customer_mobile, created_at = dto.created_at, updated_at = dto.updated_at, status = dto.status, price = dto.price, transaction_id = dto.transaction_id, user_email = dto.user_email, url_payment = dto.url_payment, paymentStatus = dto.paymentStatus, }; return(order); }
// -----------------------------------------------------------------------------------// // ------------------------------------ History_Request_Items-------------------------------------// public ActionResult View_History_Request_Items() { using (var db = new DataBaseContext()) { string user_name = Session["UserName"].ToString(); staff current_staff_obj = db.staff_repository.Where(x => x.name == user_name).Select(x => x).FirstOrDefault(); List <orders> orders_lis = db.orders_repository.Where(or => or.order_status == "Approved_by_Head" && or.staff_obj.staffId == current_staff_obj.staffId).ToList(); for (int i = 0; i < orders_lis.Count; i++) { orders temp_order = orders_lis[i]; orders_lis[i].item_obj = temp_order.item_obj; } ViewBag.order_lis = (List <orders>)orders_lis; } return(View()); }
public HttpResponseMessage DeleteUsers(int id) { if (Thread.CurrentPrincipal.Identity.AuthenticationType == "Admin") { orders orders = db.orders.FirstOrDefault(order => order.id == id); if (orders == null) { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } db.orders.Remove(orders); db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }
public ActionResult View_Collect_Order() { string user_name = Session["UserName"].ToString(); using (var db = new DataBaseContext()) { staff current_staff_obj = db.staff_repository.Where(x => x.name == user_name).Select(x => x).FirstOrDefault(); List <orders> order_lis = db.orders_repository.Where(i => i.staff_obj.department_obj.department_name == current_staff_obj.department_obj.department_name && i.order_status == "Approved_by_Clerk").ToList(); for (int i = 0; i < order_lis.Count; i++) { orders temp_order = order_lis[i]; order_lis[i].item_obj = temp_order.item_obj; } ViewBag.Order_List_Approved_by_Clerk = order_lis; } return(View()); }
public IActionResult AddOders(orders model) { IARresponse = BadRequest(); //string res = null; try { if (db.AddOrders(model) == "") { IARresponse = Ok(new { res = "Items Odered Successfully" }); } else { IARresponse = BadRequest(new { res = "Something Went Wrong... Try Again" }); } } catch (Exception ex) { IARresponse = BadRequest(new { res = ex.Message }); } return(IARresponse); }
protected void btnOderUser_Click(object sender, EventArgs e) { try { orders o = new orders(); o.schedule_id = int.Parse(drppickroom.SelectedValue.ToString()); o.service_id = int.Parse(drppickservice.SelectedValue.ToString()); o.quantity = int.Parse(txtpickquantity.Text.ToString()); o.bill_id = ord.getBill_id(int.Parse(drppickroom.SelectedValue.ToString())); ord.addOrder(o); ord.updateService_price(int.Parse(drppickroom.SelectedValue.ToString())); ord.updateTotal_price(int.Parse(drppickroom.SelectedValue.ToString())); err_msg.ForeColor = System.Drawing.Color.White; err_msg.Text = "Đặt dịch vụ thành công"; } catch { err_msg.ForeColor = System.Drawing.Color.White; err_msg.Text = "Đã xảy ra lỗi, không đặt được"; } }
public static isaCommand MyQueryReader_Orders(SqlDataReader reader, Func <byte[], Task> cb) { orders ord = new orders(); try { ord.requestId = Guid.Empty.ToByteArray(); ord.ManifestId = reader.GetInt64(reader.GetOrdinal("ManifestId")); ord.DSP_SEQ = reader.GetInt32(reader.GetOrdinal("DSP_SEQ")); ord.CustomerId = reader.GetInt32(reader.GetOrdinal("CustomerId")); ord.DLR_NO = reader.GetInt64(reader.GetOrdinal("DLR_NO")); ord.ORD_NO = reader.GetInt64(reader.GetOrdinal("ORD_NO")); ord.CLR = reader.GetString(reader.GetOrdinal("CLR")); ord.MDL_CNT = reader.GetInt32(reader.GetOrdinal("MDL_CNT")); ord.MDL_NO = reader.GetInt32(reader.GetOrdinal("MDL_NO")); ord.WIN_CNT = reader.GetInt32(reader.GetOrdinal("WIN_CNT")); ord.command = eCommand.OrdersLoad; } catch (Exception ex) { } return(ord); }
public static ordersDTO Map(this orders entity) { var dto = new ordersDTO() { id = entity.id, customer_name = entity.customer_name, customer_email = entity.customer_email, customer_mobile = entity.customer_mobile, created_at = entity.created_at, updated_at = entity.updated_at, status = entity.status, price = entity.price, transaction_id = entity.transaction_id, user_email = entity.user_email, url_payment = entity.url_payment, paymentStatus = entity.paymentStatus, }; return(dto); }