public void DeleteById(int id) { ORDERS obj = new ORDERS() { ID = id }; Delete(obj); }
public bool Delete(OrdersVM entity) { ORDERS ord = new ORDERS { ORDER_ID = entity.ORDER_ID }; ordersRepo.Delete(ord, entity.ORDER_ID); return(true); }
public ORDERS GetOrderById(int id) { var order = new ORDERS(); using (OrderGraberDBEntities dbContext = new OrderGraberDBEntities()) { order = dbContext.ORDERS.FirstOrDefault(x => x.order_id == id); } return(order); }
private void OutputDocPdf(ORDERS Order) { using (var memoryF = BL.PDF.PdfGenerator.DocPDF(Order)) { Response.Clear(); Response.ContentType = "application/pdf"; Response.OutputStream.Write(memoryF.GetBuffer(), 0, memoryF.GetBuffer().Length); Response.OutputStream.Close(); HttpContext.Current.ApplicationInstance.CompleteRequest(); } }
public ActionResult GuncelleOrders(int id, string durum, string aciklama) { using (sayazilimEntities db = new sayazilimEntities()) { ORDERS emp = db.ORDERS.Where(x => x.ID == id).FirstOrDefault <ORDERS>(); emp.Durumu = durum; // emp.IptalAciklama = aciklama; db.SaveChanges(); return(Json(new { success = true, message = "Durum Güncellendi" }, JsonRequestBehavior.AllowGet)); } }
///<summary> ///ORDERS /// </summary> public static void insert2Order(ORDERS newOrder) { string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString(); ECMSDataContext db = new ECMSDataContext(connectString); //Add new ORDERS to database db.ORDERS.InsertOnSubmit(newOrder); //Save changes to Database. db.SubmitChanges(); }
protected bool orderExist(ORDERS numOrdre, int id) { foreach (ArrayList ordrePresent in listOrder(numOrdre)) { if ((int)ordrePresent[1] == id) { return(true); } } return(false); }
public List <ORDERS> Search(ORDERS Order, int PageSize, int PageIndex, out int TotalRecords, string OrderExp, SortDirection SortDirection) { var result = Context.ORDERS.Include("CUSTOMER").Include("D_ORDER_STATUS").AsQueryable(); if (Order != null) { if (!String.IsNullOrWhiteSpace(Order.CustomerName)) { result = result.Where(o => (o.CUSTOMER.Name + " " + o.CUSTOMER.Surname).Contains(Order.CustomerName)); } if (Order.ID != 0) { result = result.Where(o => o.ID == Order.ID); } if (Order.SearchStartDate.HasValue) { result = result.Where(o => o.DateCreated >= Order.SearchStartDate.Value); } if (Order.SearchEndDate.HasValue) { result = result.Where(o => o.DateCreated <= Order.SearchEndDate.Value); } if (Order.Status.HasValue) { result = result.Where(o => o.Status == Order.Status.Value); } } TotalRecords = result.Count(); if (!String.IsNullOrEmpty(OrderExp) && OrderExp.Equals("CustomerName")) { if (SortDirection == SortDirection.Ascending) { result = result.OrderBy(c => c.CUSTOMER.Name).ThenBy(c => c.CUSTOMER.Surname); } else { result = result.OrderByDescending(c => c.CUSTOMER.Name).ThenBy(c => c.CUSTOMER.Surname); } } else { GenericSorterCaller <ORDERS> sorter = new GenericSorterCaller <ORDERS>(); result = sorter.Sort(result, String.IsNullOrEmpty(OrderExp) ? "ID" : OrderExp, SortDirection); } // pagination return(result.Skip(PageIndex * PageSize).Take(PageSize).ToList()); }
public Task <bool> DeleteAsync(OrdersVM entity) { return(Task.Run <bool>(() => { ORDERS ord = new ORDERS { ORDER_ID = entity.ORDER_ID }; ordersRepo.Delete(ord, entity.ORDER_ID); return true; })); }
public bool DeleteOrder(int id) { ORDERS order = db.ORDERS.Find(id); if (order == null) { return(false); } db.ORDERS.Remove(order); db.SaveChanges(); return(true); }
private void AddOrderToDB(decimal orderPrice, int orderID) { ORDERS myOrder = new ORDERS() { ClientID = (int)_session.CurrentClientID, OrderPrice = orderPrice }; _uOW.ORDERs.Add(myOrder); _uOW.Complete(); UpdateOrderTracker(orderID); }
private void setBonus(ORDERS order, int bonusID, decimal BonusUsed) { BONUS bonus = new BONUS() { ID = bonusID }; ORDER_BONUS ordBonus = new ORDER_BONUS() { OrderID = order.ID, BonusID = bonusID, Value = BonusUsed, ORDERS = order, BONUS = bonus }; order.BonusUsed = BonusUsed; order.ORDER_BONUS.Add(ordBonus); }
private void popolateReturn(ORDERS singleOrder) { litNumber.Text = String.Format(FashionZone.BL.Configuration.OrderNrFormatting, singleOrder.ID); chkCompleted.Checked = singleOrder.Completed; chkVerified.Checked = singleOrder.Verified; txtAmount.Text = singleOrder.TotalAmount.ToString("N2"); if (singleOrder.Status.HasValue) { ddlStatus.SelectedValue = singleOrder.Status.Value.ToString(); } repOrderDett.DataSource = singleOrder.ORDER_DETAIL; repOrderDett.DataBind(); }
public static void updatePrecription(string str_id, ORDERS updateOrder) { string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString(); ECMSDataContext db = new ECMSDataContext(connectString); //Get ORDERS for update ORDERS oldOrder = db.ORDERS.FirstOrDefault(e => e.id.Equals(str_id)); oldOrder = updateOrder; //Save changes to Database. db.SubmitChanges(); }
public bool UpdateOrder(ORDERS editOrder) { bool result = false; using (OrderGraberDBEntities dbContext = new OrderGraberDBEntities()) { var recordToEdit = dbContext.ORDERS.FirstOrDefault(x => x.order_id == editOrder.order_id); recordToEdit.client_id = editOrder.client_id; recordToEdit.order_date = editOrder.order_date; recordToEdit.total_order = editOrder.total_order; recordToEdit.state = editOrder.state; } return(result); }
protected ArrayList listOrder(ORDERS numOrdre) { ArrayList retour = new ArrayList(); foreach (ArrayList ordre in _listeOrdres) { if (((int)ordre[0] == (int)numOrdre)) { retour.Add(ordre); } } return(retour); }
//提交订单 public void check(int addrId) { int book_numbers = Convert.ToInt32(Session["select_book_number"]);//Get the size of selected book list int user_id = Convert.ToInt32(Session["user_id"]); List <CARTLIST> order_list = new List <CARTLIST>(); for (int i = 0; i < book_numbers; i++) { order_list.Add(db.Database.SqlQuery <CARTLIST>("select * from CARTLIST where USER_ID=" + user_id.ToString() + " and BOOK_ID =" + Session["select_book" + i.ToString()]).FirstOrDefault()); } CART cart = db.CART.Find(user_id);//购物车项 //var cartlist = db.CARTLIST.SqlQuery("select * from CARTLIST where USER_ID=" + user_id.ToString()).ToList();//购物车清单 //int count = db.Database.SqlQuery<int>("select QUANTITY from CARTLIST where USER_ID=" + user_id.ToString()).FirstOrDefault();//项数 int amout = 0; int total_price = 0; for (int i = 0; i < book_numbers; i++) { total_price += Convert.ToInt32(order_list[i].TOTAL_PRICE); amout += Convert.ToInt32(order_list[i].QUANTITY); } ORDERS new2 = new ORDERS(); int max = db.Database.SqlQuery <int>("select max(ID) from ORDERS").FirstOrDefault(); //找到ID的最大值 max++; //作为新ID int post_cost = 15 - 3 * amout; if (post_cost < 0) { post_cost = 0; } new2.ID = max; new2.USER_ID = user_id; new2.ADDRESS_ID = addrId; new2.QUANTITY = book_numbers; new2.PRICE = total_price; new2.TIME_START = DateTime.Now.ToString(); new2.STATUS = "NO"; new2.POST_COST = post_cost; db.ORDERS.Add(new2); for (int i = 0; i < book_numbers; i++) { ORDER_INCLUDE temp = new ORDER_INCLUDE(); temp.ORDER_ID = max; temp.BOOK_ID = order_list[i].BOOK_ID; temp.QUANTITY = order_list[i].QUANTITY; temp.TOTAL_PRICE = order_list[i].TOTAL_PRICE; db.ORDER_INCLUDE.Add(temp); } for (int i = 0; i < book_numbers; i++) { removeCart(Convert.ToInt32(Session["select_book" + i.ToString()]), user_id); } db.SaveChanges(); }
public static void deleteOrder(string str_id) { string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString(); ECMSDataContext db = new ECMSDataContext(connectString); //Get ORDERS to Delete ORDERS deleteOrder = db.ORDERS.FirstOrDefault(e => e.id.Equals(str_id)); //Delete ORDERS db.ORDERS.DeleteOnSubmit(deleteOrder); //Save changes to Database. db.SubmitChanges(); }
protected ArrayList getOrder(ORDERS numOrdre, int complement) { foreach (ArrayList ordre in _listeOrdres) { if (((int)ordre[0] == (int)numOrdre)) { if (((complement == 0) || ((int)ordre[1] == complement))) { return(ordre); } } } return(createOrder(numOrdre)); }
private int GetOrderID() { List <ORDERS> myOrders = _uOW.ORDERs.GetAllOrders().Cast <ORDERS>().ToList(); if (myOrders.Count == 0) { return(1); } else { ORDERS lastOrder = myOrders.Last(); return(lastOrder.OrderID + 1); } }
protected void Page_Load(object sender, EventArgs e) { servCommfac = new ServiceCommon(base.factoryConnectionString); if (Request["type"] == "GetBatch") { string batchOrderID = Request["BatchOrderID"]; string batchSerialID = Request["BatchSerialID"]; string batchProductID = Request["BatchProductID"]; string zBatchNodes = ""; ccWhere.Clear(); ccWhere.AddComponent("Order_ID", batchOrderID, SearchComponent.Equals, SearchPad.And); ccWhere.AddComponent("serial", batchSerialID, SearchComponent.Equals, SearchPad.And); ccWhere.AddComponent("Productid", batchProductID, SearchComponent.Equals, SearchPad.And); DataTable dt = servCommfac.GetListTop(0, "isnull(Name,'') as Name,isnull(Maker,'') as Maker,isnull(batchNo,'') as batchNo", "OrdersElement", ccWhere); foreach (DataRow dr in dt.Rows) { zBatchNodes = zBatchNodes + "{" + "\"ElementName\":" + "\"" + dr["Name"].ToString() + "\"" + ",\"ElementMaker\":" + "\"" + dr["Maker"].ToString() + "\"" + ",\"BatchNo\":" + "\"" + dr["batchNo"].ToString() + "\"},"; } zBatchNodes = zBatchNodes.Trim(','); if (zBatchNodes == "") { zBatchNodes = "{}"; } else { zBatchNodes = "[" + zBatchNodes + "]"; } Response.Write(zBatchNodes); Response.End(); } else { orderID = Request["orderID"]; serialID = Request["serial"]; ccWhere.Clear(); ccWhere.AddComponent("Order_ID", orderID, SearchComponent.Equals, SearchPad.NULL); ccWhere.AddComponent("serial", serialID, SearchComponent.Equals, SearchPad.And); IList <ORDERS> listOrder = servCommfac.GetListTop <ORDERS>(0, "hospital,doctor,Patient,Order_ID,indate,preoutDate,OutDate,Sex,Age", "orders", ccWhere); if (listOrder.Count > 0) { orderModel = listOrder[0]; } GetProcedureList(orderID, serialID); } }
public static List <ORDERS> GetOrders(int CustID) { ORDERS order = null; List <ORDERS> orders = new List <ORDERS>(); try { using (OracleConnection con = new OracleConnection(conlink)) { if (con.State == ConnectionState.Closed) { con.Open(); } string query = "SELECT * FROM ORDERS WHERE CUSTID =" + CustID; OracleCommand cmd = new OracleCommand(query, con); OracleDataReader reader = cmd.ExecuteReader(); if (reader != null) { if (reader.HasRows) { while (reader.Read()) { order = new ORDERS() { CUSTID = int.Parse(reader["CUSTID"].ToString()), ORDERNUM = int.Parse(reader["ORDERNUM"].ToString()), ORDERTOTAL = int.Parse(reader["ORDERTOTAL"].ToString()), OREDERDATE = DateTime.Parse(reader["OREDERDATE"].ToString()), DELIVERYDATE = DateTime.Parse(reader["DELIVERYDATE"].ToString()) }; orders.Add(order); } reader.Close(); } } if (con.State == ConnectionState.Open) { con.Close(); } } } catch (Exception ex) { throw ex; } return(orders); }
public async Task <MessageModel <string> > Post([FromBody] ORDERS request) { var data = new MessageModel <string>(); var id = await _ORDERSServices.Add(request); data.success = id > 0; if (data.success) { data.response = id.ObjToString(); data.msg = "添加成功"; } return(data); }
public async Task <MessageModel <string> > Put([FromBody] ORDERS request) { var data = new MessageModel <string>(); if (request.ORIGREC > 0) { data.success = await _ORDERSServices.Update(request); if (data.success) { data.msg = "更新成功"; data.response = request?.ORIGREC.ObjToString(); } } return(data); }
public void CancelOrderById(int OrderId) { ORDERS order = _orderDAO.GetById(OrderId); PRODUCT_ATTRIBUTE prodAttr; // put back to the warehouse each product that was in the order // version is not needed as the availability is incremented, so no risk foreach (ORDER_DETAIL item in order.ORDER_DETAIL) { prodAttr = null; prodAttr = _productDAO.GetProductAttributeById(item.ProdAttrID); prodAttr.Availability += item.Quantity; _productDAO.UpdateProductAttribute(prodAttr, false); } order.Canceled = true; order.Completed = false; order.Status = 6; _orderDAO.Update(order, false); // TODO Revert BONUS if (order.BonusUsed.HasValue && order.BonusUsed.Value > 0) { decimal usedValue = 0; foreach (ORDER_BONUS b in order.ORDER_BONUS) { usedValue += b.Value.Value; } DateTime validity = order.ORDER_BONUS.Max(b => b.BONUS.Validity).Value; BONUS bon = new BONUS() { CustomerID = order.CustomerID, DateAssigned = DateTime.Today, Validity = validity, Description = "Per anullim porosie", Value = usedValue, ValueRemainder = usedValue }; _bonusDAO.Insert(bon); } Context.SaveChanges(); }
private void setBonus(ORDERS order) { int bonusID = 0; if (Int32.TryParse(ddlBonus.SelectedValue, out bonusID) && bonusID != -1) { BONUS bonus = new BONUS() { ID = bonusID, Version = Version.Where(b => b.Key == bonusID).FirstOrDefault().Value }; ORDER_BONUS ordBonus = new ORDER_BONUS() { OrderID = order.ID, BonusID = bonusID, Value = BonusUsed, ORDERS = order, BONUS = bonus }; order.BonusUsed = BonusUsed; order.ORDER_BONUS.Add(ordBonus); } }
public bool SaveOrder(_Order o) { try { if (o.IsNew) { db.ORDERS.Add(new ORDERS() { UserName = o.UserName, StartDate = o.StartDate, EndDate = o.EndDate, ActualDate = o.ActualDate, Number = o.Number, Payed = o.Payed }); var curr = db.CARS.Where(a => a.Number == o.Number).FirstOrDefault(); curr.IsFree = false; } else { ORDERS order = db.ORDERS.Find(o.OrderId); if (order == null) { return(false); } order.UserName = o.UserName; order.StartDate = o.StartDate; order.EndDate = o.EndDate; order.ActualDate = o.ActualDate; order.Number = o.Number; order.Payed = o.Payed; } db.SaveChanges(); } catch { return(false); } return(true); }
public void Update(ORDERS Order, bool Attach = true) { if (Attach) { Context.ORDERS.Attach(Order); } var entry = Context.ObjectStateManager.GetObjectStateEntry(Order); // excluding datecreated from the updatable fields entry.SetModifiedProperty("DateShipped"); entry.SetModifiedProperty("Verified"); entry.SetModifiedProperty("Completed"); entry.SetModifiedProperty("Canceled"); entry.SetModifiedProperty("Comments"); entry.SetModifiedProperty("ShippingID"); entry.SetModifiedProperty("ShippingAddress"); entry.SetModifiedProperty("BillingAddress"); entry.SetModifiedProperty("Status"); entry.SetModifiedProperty("ShippingDetails"); entry.SetModifiedProperty("TrackingNumber"); entry.SetModifiedProperty("DateDelivered"); }
/// <summary> /// Writes the info order. /// </summary> /// <param name="order">The order.</param> /// <param name="phOrd">The ph ord.</param> /// <param name="miniTitlesFontStyleIns">The mini titles font style ins.</param> private static void WriteInfoOrder(ORDERS order, ref Phrase phOrd, Font miniTitlesFontStyleIns) { string paymentOrder = String.Empty; decimal paid = 0; switch (order.PAYMENT.Type) { case (int)PaymentType.CA: paymentOrder = "Cash"; paid = order.PAYMENT.CASH_PAYMENT.Amount.Value; break; case (int)PaymentType.PP: paymentOrder = "PayPal"; paid = order.PAYMENT.PAYPAL_PAYMENT.Amount.Value; break; case (int)PaymentType.EP: paymentOrder = "EasyPay"; paid = order.PAYMENT.EASYPAY_PAYMENT.Amount; break; } if (order != null) { string addSh = string.Format( @"Fatura nr: {0} Data faturës: {1} Tipi i pagimit: {2} Paguar: {3} Blerësi:{4} {5} Kodi: {6}", String.Format(FashionZone.BL.Configuration.OrderNrFormatting, order.ID), order.DateCreated.ToString("dd/MM/yyyy hh:mm"), paymentOrder, paid.ToString("N2") + (order.PAYMENT.Type == (int)PaymentType.EP ? " Lek" : " €"), order.CustomerName, order.CUSTOMER.Email, order.VerificationNumber); phOrd = new Phrase(addSh, miniTitlesFontStyleIns); } }
public string Update(ORDERS Order, bool Attach = true) { string retString = String.Empty; CUSTOMER customer = _customerDAO.GetById(Order.CustomerID.Value); // first buy of this customer & invited by someone if ((!customer.FirstBuy.HasValue || !customer.FirstBuy.Value) && Order.PAYMENT.Type == (int)PaymentType.CA && Order.Completed) { if (customer.InvitedFrom.HasValue) { insertCustomerBonus(customer); retString = "Bonus added to inviter " + customer.CUSTOMER2.Email; Util.Mailer.SendBonus(customer, customer.CUSTOMER2.Email, Configuration.BonusValue + " € bonus per ju ne FZone"); } customer.FirstBuy = true; _customerDAO.Update(customer, true, false); } _orderDAO.Update(Order, Attach); // payment if (Order.PAYMENT != null) { if (Order.PAYMENT.Type == (int)PaymentType.CA) { var entry = Context.ObjectStateManager.GetObjectStateEntry(Order.PAYMENT.CASH_PAYMENT); entry.SetModifiedProperty("Receiver"); entry.SetModifiedProperty("Comments"); entry.SetModifiedProperty("PaidOn"); } else if (Order.PAYMENT.Type == (int)PaymentType.PP) { //TODO } } Context.SaveChanges(); return(retString); }