//called to refresh all the fields and datagridview private void populateFields(Button disableButton, Button enableButton, int index) { orders = OrderDB.GetOrders(); txtOrderID.Text = orders[index].OrderID.ToString(); txtCustomerID.Text = orders[index].CustomerID; dtpOrderDate.Value = (DateTime)orders[index].OrderDate; dtpRequiredDate.Value = (DateTime)orders[index].RequiredDate; if (orders[index].ShippedDate != null) // if the shippeddate is not null { dtpShippedDate.Format = DateTimePickerFormat.Long; dtpShippedDate.Value = (DateTime)orders[index].ShippedDate; isNull = false; } else //shipped date is null { dtpShippedDate.CustomFormat = " "; dtpShippedDate.Format = DateTimePickerFormat.Custom; isNull = true; } List <OrderDetails> orderDetails_List = OrderDetailsDB.GetOrdersDetails(orders[index].OrderID); dgvOrderDetails.DataSource = orderDetails_List; txtTotalCharges.Text = CalculateCharges(orderDetails_List).ToString("c"); Disablebuttion(disableButton, enableButton, index); }
protected void dtlProduct_ItemCommand(object source, DataListCommandEventArgs e) { if (e.CommandName == "delete") { var contentid = ConvertUtility.ToInt32(e.CommandArgument); try { var orderProductInfo = OrderProductDB.GetInfo(_orderid, contentid); var deletePriceSum = orderProductInfo.PriceSum; OrderProductDB.Delete(_orderid, contentid); var orderInfo = OrderDB.GetInfo(_orderid); orderInfo.Order_Quantity = orderInfo.Order_Quantity - 1; orderInfo.Order_Price = orderInfo.Order_Price - deletePriceSum; OrderDB.Update(orderInfo); lblUpdateStatus.Text = MiscUtility.UPDATE_SUCCESS; } catch { lblUpdateStatus.Text = MiscUtility.UPDATE_ERROR; } } if (e.CommandName == "updaterow") { //try //{ var contentid = ConvertUtility.ToInt32(e.CommandArgument); var txtQuantity = (TextBox)e.Item.FindControl("txtQuantity"); var orderProductInfo = OrderProductDB.GetInfo(_orderid, contentid); var newQuantity = ConvertUtility.ToInt32(txtQuantity.Text); var newPriceSum = orderProductInfo.Price * newQuantity; var balancePrice = orderProductInfo.PriceSum - newPriceSum; orderProductInfo.Quantity = newQuantity; orderProductInfo.PriceSum = newPriceSum; OrderProductDB.Update(orderProductInfo); var orderInfo = OrderDB.GetInfo(_orderid); orderInfo.Order_Price = orderInfo.Order_Price - balancePrice; OrderDB.Update(orderInfo); lblUpdateStatus.Text = MiscUtility.UPDATE_SUCCESS; //} //catch //{ // lblUpdateStatus.Text = MiscUtility.UPDATE_ERROR; //ex.ToString(); //} } }
private bool SaveOrder(Order order) { if (!ModelState.IsValid) { return(false); } var addressId = SaveAddressAsync(order.Address).Result; var orderDb = new OrderDB(); var orderDbItem = _orderContext.Orders.FirstOrDefault(); if (orderDbItem == null) { orderDb.Id = 1; } else { var orderId = _orderContext.Orders.Max(x => x.Id); orderId++; orderDb.Id = orderId; } orderDb.Status = 0; orderDb.Description = order.Description; orderDb.AddressId = addressId; List <OrderDbItem> productDbList = new List <OrderDbItem>(); order.Items.ForEach(x => productDbList.Add(OrderDbItem.ConvertProduct(x.Product, x.Count))); orderDb.Items = JsonConvert.SerializeObject(productDbList); _orderContext.Add(orderDb); _orderContext.SaveChanges(); // SaveOrderInformation() return(true); }
public CreateAnOrder(Customer aCust) { OrdDb = new OrderDB(); prodDb = new ProductDB(); anOrd = new Order(aCust); custDb = new CustomerDB(); }
private void button1_Click(object sender, EventArgs e) { form1 = (MainForm)this.Owner; //电话(手机)号码格式 string pattern = "^1[0-9]{10}$"; Regex rx = new Regex(pattern); if (textBox1.Text == "" || textBox2.Text == "") { MessageBox.Show("Please enter enough information!!!"); } else if (textBox1.Text != "" && !rx.IsMatch(textBox2.Text)) { MessageBox.Show("Telephone number's format is wrong!!!"); } else { using (var db = new OrderDB()) { int orderNum = 0; string pipeNum = db.Order.ToList().LastOrDefault <Order>().Id.Split('-')[3]; Int32.TryParse(pipeNum, out orderNum); Order.num = orderNum; } form1.myService.Add(new Order(new Customer(textBox1.Text, textBox2.Text), new List <OrderDetail>())); MessageBox.Show("Add order succeed!!!"); } }
protected override void OnPreRender(EventArgs e) { base.OnPreRender(e); OrderInfo info = OrderDB.GetInfo(_orderid); if (info == null) { return; } lblID.Text = info.Order_ID.ToString(); lblDateTime.Text = ConvertUtility.ToDateTime(info.Order_CreateDate).ToString("dd/MM/yyyy HH:mm"); lnkFullname.Text = info.Order_Fullname; lnkFullname.NavigateUrl = AppEnv.ADMIN_CMD + "memberupdate&memberid=" + info.Member_ID; lblEmail.Text = info.Order_Email; lblPhone.Text = info.Order_Tel; lblAddress.Text = info.Order_Address.Replace("\n", "<br>"); lblDistrict.Text = info.Order_District; lblCity.Text = info.Order_City; lblContent.Text = info.Order_Note.Replace("\n", "<br>"); MiscUtility.SetSelected(dropStatus.Items, info.Order_Status.ToString()); lblQuantity.Text = ConvertUtility.ToInt32(info.Order_Quantity).ToString(); lblPrice.Text = String.Format("{0:0,0}", info.Order_Price) + " VNÐ"; dtlProduct.DataSource = OrderDB.GetProductByOrderID(_orderid); dtlProduct.DataBind(); }
public void SetUp() { orderDB = new OrderDB(connectionString); productDB = new ProductDB(connectionString); customerDB = new CustomerDB(connectionString); orderLogic = new OrderLogic(connectionString); }
public object DeleteType(string id, string SHOP_ID) { using (var db = new OrderDB()) { db.BeginTransaction(); try { var curType = (from p in db.FoodTypes where p.ID == id select p).FirstOrDefault(); if (curType is null) { throw new Exception("当前类别不存在!"); } db.FoodTypes .Where(c => c.SEQ > curType.SEQ && c.ShopId == SHOP_ID && c.STATE == 'A') .Set(c => c.SEQ, c => c.SEQ - 1) .Update(); db.Delete(curType); db.CommitTransaction(); } catch (Exception ex) { db.RollbackTransaction(); throw ex; } return(true); } }
private void LstBoxProductIDs_SelectionChanged(object sender, SelectionChangedEventArgs e) { btnOrderDetails.IsEnabled = true; OrderDB showOrderDetails = new OrderDB(); showOrderDetails.ShowOrderDetails(lstBoxProductIDs, txtProductID, txtUnitPrice, txtQuantity, txtDiscount, txtOrderTotal); }
private void orderIDComboBox_SelectedIndexChanged(object sender, EventArgs e) { int selectedID = (int)orderIDComboBox.SelectedValue; try { current = OrderDB.GetOrderByID(selectedID); DisplayCurrentCustomerData(); ordDetails = OrderDetailsDB.GetOrderDetailIDs(selectedID); orderDetailDataGridView.DataSource = ordDetails; //ordDetails //Calculating order total float total = 0; foreach (OrderDetail order in ordDetails) { total += order.OrderTotal; } string Total = total.ToString(); textOrderTotal.Text = total.ToString("c2"); } catch (Exception ex) { MessageBox.Show("Error while retrieving customer with selected ID: " + ex.Message, ex.GetType().ToString()); } }
/// <summary> /// The Update method will update a certain order /// </summary> /// <param name="id">The id<see cref="int"/></param> /// <param name="updateOrder">The updateOrder<see cref="OrderDTO"/></param> /// <returns>The <see cref="string"/></returns> public string Update(int id, OrderDTO updateOrder) { OrderDB newOrder = Converter.Cast(updateOrder); _orderRepo.Update(id, newOrder); return("update succcessfully"); }
public List <Order> GetAllOrders() { using (var db = new OrderDB()) { return(db.Order.Include("items").ToList <Order>()); } }
public static IList <OrderDB> Cast(IList <ClientOrder> clientOrders) { var list = new List <OrderDB>(); foreach (var order in clientOrders) { if (order != null) { var newobj = new OrderDB() { IdOrder = order.IdOrder, NameCompany = order.NameCompany, OriginAddress = order.OriginAddress, OriginCity = order.OriginCity, OriginState = order.OriginState, OriginCountry = order.OriginCountry, DestinationAddress = order.DestinationAddress, DestinationCity = order.DestinationCity, DestinationCountry = order.DestinationCountry, DestinationState = order.DestinationState, Description = order.Description, Status = order.Status, IdLoad = order.IdLoad, IdShipment = order.IdShipment, WeigthOrder = order.WeigthOrder, CostOrder = order.CostOrder }; list.Add(newobj); } } return(list); }
public void ChangeOrderStatus(int orderId, OrderStatus newStatus) { OrderDB orderDB = new OrderDB(); Order order = orderDB.GetById(orderId); order.StatusID = newStatus; order.Update(); }
public static IList <OrderDB> Cast(IEnumerable <OrderDTO> orders) { var orderList = new List <OrderDB>(); foreach (var order in orders) { var newObject = new OrderDB() { IdOrder = order.IdOrder, NameCompany = order.NameCompany, OriginAddress = order.OriginAddress, OriginCity = order.OriginCity, OriginState = order.OriginState, OriginCountry = order.OriginCountry, DestinationAddress = order.DestinationAddress, DestinationCity = order.DestinationCity, DestinationCountry = order.DestinationCountry, DestinationState = order.DestinationState, Description = order.Description, Status = order.Status, IdLoad = order.IdLoad, IdShipment = order.IdShipment, WeigthOrder = order.WeigthOrder, CostOrder = order.CostOrder }; orderList.Add(newObject); } return(orderList); }
private void customerIDComboBox_SelectedIndexChanged(object sender, EventArgs e) { // get CustomerID from combo box string custID = customerIDComboBox.Text; var temp = from customer in customers where customer.CustomerID == custID select customer; foreach (var c in temp) { companyNameTextBox.Text = c.CompanyName; contactNameTextBox.Text = c.ContactName; contactTitleTextBox.Text = c.ContactTitle; addressTextBox.Text = c.Address; cityTextBox.Text = c.City; postalCodeTextBox.Text = c.PostalCode; countryTextBox.Text = c.Country; regionTextBox.Text = c.Region; phoneTextBox.Text = c.Phone; faxTextBox.Text = c.Fax; } // get the orders for that customer id and populate the orders table List <Order> orders = OrderDB.GetOrdersByID(custID); //var temp2 = from order in orders where order.CustomerID == custID select order; dataGridView1.DataSource = orders; }
public object GetDeskList() { using (var db = new OrderDB()) { var result = from p in db.ShopDesks where p.ShopId == SHOP_ID select p; return(result.ToList()); } }
public List <Order> QueryByCustormer(String custormer) { using (var db = new OrderDB()) { return(db.Order.Include("items") .Where(o => o.Customer.Equals(custormer)).ToList <Order>()); } }
public Order GetOrder(String Id) { using (var db = new OrderDB()) { return(db.Order.Include("Items"). SingleOrDefault(o => o.Id == Id)); } }
// Database test constructor. Only used for testing. public OrderLogic(string connectionString) { orderDB = new OrderDB(connectionString); cl = new CustomerLogic(connectionString); productDB = new ProductDB(connectionString); orderLineDB = new OrderLineDB(connectionString); productLogic = new ProductLogic(connectionString); customerDB = new CustomerDB(connectionString); }
public OrderLogic() { orderDB = new OrderDB(); cl = new CustomerLogic(); productDB = new ProductDB(); orderLineDB = new OrderLineDB(); productLogic = new ProductLogic(); customerDB = new CustomerDB(); }
public ActionResult Details(int id) { //creation of multiple variables to check conditions and for the display IOrderDB order = new OrderDB(Configuration); IOrderManager om = new OrderManager(order); ICustomerDB customer = new CustomerDB(Configuration); ICustomerManager cm = new CustomerManager(customer); ICityDB citydb = new CityDB(Configuration); ICityManager cityman = new CityManager(citydb); IDelivery_staffDB dsDB = new Delivery_staffDB(Configuration); IDelivery_staffManager dsM = new Delivery_staffManager(dsDB); IDishDB dish = new DishDB(Configuration); IDishManager dishManager = new DishManager(dish); IOrder_dishesDB order_Dishes = new Order_dishesDB(Configuration); IOrder_dishesManager odm = new Order_dishesManager(order_Dishes); IRestaurantDB restaurant = new RestaurantDB(Configuration); IRestaurantManager restaurantManager = new RestaurantManager(restaurant); //Creations of multiple ViewData for the display var customerlist = cm.GetCustomers(); ViewData["Customers"] = customerlist; var citylist = cityman.GetCities(); ViewData["City"] = citylist; var allOrders = om.GetOrders(); ViewData["AllOrders"] = allOrders; var allStaff = dsM.GetDelivery_staffs(); ViewData["AllStaffs"] = allStaff; var allDishes = dishManager.GetAllDishes(); ViewData["AllDishes"] = allDishes; var allOrderDishes = odm.GetAllOrders_dishes(); ViewData["AllOrderDishes"] = allOrderDishes; var allRestaurants = restaurantManager.GetRestaurants(); ViewData["AllRestaurants"] = allRestaurants; ViewBag.nameDL = HttpContext.Session.GetString("nameDL"); var od = om.GetOrders_ds(id); //Get all orders according to the deliverer's id List <Order> odtrie = new List <Order>(); //Creation of a list which will only contain the non delivery order(s) foreach (Order o in od) { if (o.status.Equals("non delivery")) { odtrie.Add(o); } } return(View(odtrie)); //Display the non delivery order(s) }
public void Add(Order order) { using (var db = new OrderDB()) { db.Order.Add(order); //db.Order.Attach(order); //db.Entry(order).State = EntityState.Added; db.SaveChanges(); } }
public List <Order> QueryByGoods(String product) { using (var db = new OrderDB()) { var query = db.Order.Include("items") .Where(o => o.Items.Where( item => item.Product.Equals(product)).Count() > 0); return(query.ToList <Order>()); } }
public void GetAllOrdersShouldReturnAllOrders() { using (var context = new Entity.p0storeContext(options)){ OrderDB _orderDB = new OrderDB(context); var orders = _orderDB.GetAllOrder(); int count = orders.Count; Assert.Equal(1, count); } }
public void Delete(String orderId) { using (var db = new OrderDB()) { var order = db.Order.Include("Items").SingleOrDefault(o => o.Id == orderId); db.OrderItem.RemoveRange(order.Items); db.Order.Remove(order); db.SaveChanges(); } }
public bool UserIsExsist(string name) { using (var db = new OrderDB()) { var isExsit = from p in db.Shops where p.ACCOUNT == name select p; return(isExsit.Count() > 0); } }
public void Update(Order order) { using (var db = new OrderDB()) { db.Order.Attach(order); db.Entry(order).State = EntityState.Modified; order.Items.ForEach( item => db.Entry(item).State = EntityState.Modified); db.SaveChanges(); } }
static void Main(string[] args) { OrderDB orderdb = new OrderDB(); DataSet ds = orderdb.GetOrderDetails(4); Console.WriteLine(ds.Tables[0].Rows[0][0].ToString()); OrderDB.Orders orders = new OrderDB.Orders(); orders.UpdateOrderDetailQuantity(5, "155", 99); Console.WriteLine("Updated!"); Console.ReadLine(); }
public RedeemResponse Redeem(string orderNumber, string email) { OrderDB db = new OrderDB(); Order2 order = db.GetOrder(orderNumber); if (order == null) { return(new RedeemResponse { Message = "", Success = false }); } else if (String.IsNullOrWhiteSpace(email) || !Regex.IsMatch(email, "[a-zA-Z0-9]*@[a-zA-Z0-9]*\\.{1}[a-zA-Z]{1,}")) { return(new RedeemResponse { Success = false, Message = "Email required to redeem password." }); } else if (order.EMail != null && !order.EMail.Equals(email)) { return(new RedeemResponse { Success = false, Message = "An email has already been set." }); } order.EMail = email; if (order.PasswordClaimed == null) { order.PasswordClaimed = DateTime.Now; db.SaveOrder(order); } RedeemResponse resp = new RedeemResponse(); resp.OrderInfoText = "Addr: " + order.Address + "\n" + "Mail: " + order.EMail + "\n" + "Name: " + order.Name + "\n" + "Password: "******"\n" + (order.PasswordClaimed != null ? "REDEEMED" : ""); resp.Success = true; resp.Message = ""; return(resp); }
protected void btnSave_Click(object sender, EventArgs e) { int orcId = Convert.ToInt32(Request.QueryString["orc_id"]); int forId = Convert.ToInt32(Request.QueryString["for_id"]); bool success = false; OrderDB orderbd = new OrderDB(); Order order = new Order(); RequestItemBD requestbd = new RequestItemBD(); RequestItem item = new RequestItem(); order.RegisterDate = DateTime.Now; order.IdSupplier = forId; order.IdBudget = orcId; if (orderbd.Insert(order)) { int lastOrderId = orderbd.SelectLastOrder(); for (int i = 0; i < gdvItems.Rows.Count; i++) { item.Desc = gdvItems.Rows[i].Cells[0].Text; item.TypeOfItem = gdvItems.Rows[i].Cells[1].Text; item.Qty = Convert.ToInt32(gdvItems.Rows[i].Cells[2].Text); item.Price = Convert.ToDouble(gdvItems.Rows[i].Cells[3].Text); item.PedId = lastOrderId; if (requestbd.Insert(item)) { success = true; } else { success = false; } } } else { success = false; } if (success) { Response.Redirect("ListOrders.aspx?orc_id=" + orcId + "&success=true"); } else { lblMessage.Text = "Erro ao salvar o pedido."; } }
public List<Order> GetOrders() { OrderDB orderDB = new OrderDB(); return orderDB.GetAll(); }
/// <summary> /// TODO: change to boolean /// </summary> /// <param name="orderID"></param> public void DeleteOrderByID(int orderID) { OrderDB orderDB = new OrderDB(); Order order = orderDB.GetById(orderID); //Make a check for nulls order.Delete(); }