public ActionResult Orders_Destroy([DataSourceRequest]DataSourceRequest request, OrdersModel order) { if (this.ModelState.IsValid) { this.orderService.Delete(order.Id); } return this.Json(new[] { order }.ToDataSourceResult(request, this.ModelState)); }
protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e) { OrdersModel orders = (OrdersModel)e.Item.DataItem; MemberModel member = bll_member.GetModel(orders.MemberId.ToString()); string username = "******"; if (member != null) { username = member.Username + " ( " + member.Realname + " )"; } ((HtmlTableCell)e.Item.FindControl("Eval_Member")).InnerHtml = username; ((HtmlTableCell)e.Item.FindControl("Eval_PayWay")).InnerText = XMLHelper.GetXmlDataVal(orders.PayWay.ToString(), "PayWay"); ((HtmlTableCell)e.Item.FindControl("Eval_Price")).InnerText = orders.Price.ToString("C0", nfi); ((HtmlTableCell)e.Item.FindControl("Eval_Status")).InnerHtml = bll_orders.GetStatus(orders, "stat"); ((HtmlTableCell)e.Item.FindControl("Eval_CreateTime")).InnerText = DateHelper.ToShortDate(orders.CreateTime); }
private void bwDelete_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) { this.Cursor = null; btnDelete.IsEnabled = true; btnSearch.IsEnabled = true; if (e.Error != null) { MessageBox.Show(e.Error.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error); return; } orders = null; dgOrder.ItemsSource = null; btnUpdateOrder.IsEnabled = false; dgSizeRun.ItemsSource = null; btnUpdateSizeRun.IsEnabled = false; MessageBox.Show("Deleted!", this.Title, MessageBoxButton.OK, MessageBoxImage.Information); }
private async ValueTask CompletedOrders() { var url = $"api/orders/completedorders?Username={_username}"; var response = await OrderHttpClientService.GetAsync(url); if (response.StatusCode == (int)System.Net.HttpStatusCode.OK) { OrdersModel = JsonSerializer.Deserialize <OrdersModel>(response.Content, new JsonSerializerOptions { PropertyNameCaseInsensitive = true }); } else { _errorMessage = $"Error: {response.Error}"; OrdersModel = new OrdersModel(); } }
public bool AddOrder(OrdersModel order) { if ( string.IsNullOrWhiteSpace(order.Firstname) || string.IsNullOrWhiteSpace(order.Lastname) || string.IsNullOrWhiteSpace(order.Adress) || string.IsNullOrWhiteSpace(order.Email) || string.IsNullOrWhiteSpace(order.UserId) || order.Postcode <= 0 || string.IsNullOrWhiteSpace(order.City) || order.Total <= 0 ) { return(false); } return(this.ordersRepository.AddOrder(order)); }
public ActionResult OrdersBilgi(int id) { string strcon = ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString; OrdersModel yonetim = new OrdersModel(); string sorg = @"Select SiparisNo ,ID,GenelToplam,SiparisNotu,IslemTarihi,Sikayet,Aciklama,(Select CASE When GSM =null then Telefon1 else GSM end from Cari where CariID=Cari.ID )as CariTel,Teslimat, (Select CariUnvan from Cari where CariID=Cari.ID )as CariUnvan,Tarif,(Select Adres from Cari where CariID=Cari.ID)as Adres,(Select CariGrubu from Cari where CariID=Cari.ID) as CariGrubu from ORDERS where ID='" + id + "'"; using (SqlConnection con = new SqlConnection(strcon)) { con.Open(); using (SqlCommand ordersgetir = new SqlCommand(sorg, con)) { using (SqlDataReader dr = ordersgetir.ExecuteReader()) { while (dr.Read()) { OrdersModel yt = new OrdersModel(); yt.SiparisNo = dr["SiparisNo"].ToString(); yt.GenelToplam = Convert.ToDecimal(dr["GenelToplam"]); yt.CariUnvan = dr["CariUnvan"].ToString(); yt.Adres = dr["Adres"].ToString(); yt.CariGrubu = dr["CariGrubu"].ToString(); yt.IslemTarihi = dr["IslemTarihi"].ToString(); yt.SiparisNotu = dr["SiparisNotu"].ToString(); yt.Sikayet = dr["Sikayet"].ToString(); yt.Aciklama = dr["Aciklama"].ToString(); yt.Tarif = dr["Tarif"].ToString(); yt.Telefon1 = dr["CariTel"].ToString(); yt.Teslimat = dr["Teslimat"].ToString(); yt.ID = Convert.ToInt32(dr["ID"]); yonetim = yt; } } } } return(Json(new { success = true, data = yonetim }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(OrdersModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_Orders set "); strSql.Append("Orderdate=@Orderdate,"); strSql.Append("UserId=@UserId,"); strSql.Append("Total=@Total,"); strSql.Append("DeliveryID=@DeliveryID,"); strSql.Append("DeliveryDate=@DeliveryDate,"); strSql.Append("States=@States,"); strSql.Append("Remark=@Remark"); strSql.Append(" where OrdersID=@OrdersID"); SqlParameter[] parameters = { new SqlParameter("@Orderdate", SqlDbType.Date, 3), new SqlParameter("@UserId", SqlDbType.Int, 4), new SqlParameter("@Total", SqlDbType.Money, 8), new SqlParameter("@DeliveryID", SqlDbType.Int, 4), new SqlParameter("@DeliveryDate", SqlDbType.Date, 3), new SqlParameter("@States", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.NVarChar, 500), new SqlParameter("@OrdersID", SqlDbType.Int, 4) }; parameters[0].Value = model.Orderdate; parameters[1].Value = model.UserId; parameters[2].Value = model.Total; parameters[3].Value = model.DeliveryID; parameters[4].Value = model.DeliveryDate; parameters[5].Value = model.States; parameters[6].Value = model.Remark; parameters[7].Value = model.OrdersID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void bwReport_DoWork(object sender, DoWorkEventArgs e) { DataTable dt = new DeliveryDataSet().Tables["DeliveryTable"]; List <String> productNoList = rawMaterialList.Select(r => r.ProductNo).Distinct().ToList(); foreach (string productNo in productNoList) { OrdersModel order = orderList.Where(o => o.ProductNo == productNo).FirstOrDefault(); List <Int32> materialTypeIdList = rawMaterialList.Select(r => r.MaterialTypeId).Distinct().ToList(); //Red! materialTypeIdList.Remove(11); materialTypeIdList.Remove(6); materialTypeIdList.Remove(12); materialTypeIdList.Remove(13); foreach (int materialTypeId in materialTypeIdList) { RawMaterialModel rawMaterial = rawMaterialList.Where(r => r.ProductNo == productNo && r.MaterialTypeId == materialTypeId).FirstOrDefault(); if (rawMaterial != null && rawMaterial.ETD.Date != new DateTime(2000, 1, 1) && rawMaterial.ETD.Date == dateSearch.Date && rawMaterial.ActualDate.Date == new DateTime(2000, 1, 1)) { DataRow dr = dt.NewRow(); dr["ProductNo"] = productNo; if (order != null) { dr["ArticleNo"] = order.ArticleNo; dr["ShoeName"] = order.ShoeName; dr["Quantity"] = order.Quantity; dr["ETD"] = order.ETD; } dr["SupplierETD"] = rawMaterial.ETD; dr["Remarks"] = rawMaterial.Remarks; MaterialTypeModel materialType = materialTypeList.Where(m => m.MaterialTypeId == rawMaterial.MaterialTypeId).FirstOrDefault(); if (materialType != null) { dr["Supplier"] = materialType.Name; } dt.Rows.Add(dr); } } } e.Result = dt; }
private void btnSearch_Click(object sender, RoutedEventArgs e) { if (String.IsNullOrEmpty(txtProductNo.Text) == true) { return; } if (bwSearch.IsBusy == false) { this.Cursor = Cursors.Wait; productNo = txtProductNo.Text; btnSearch.IsEnabled = false; btnDelete.IsEnabled = false; orders = null; btnUpdateOrder.IsEnabled = false; dt = new DataTable(); btnUpdateSizeRun.IsEnabled = false; bwSearch.RunWorkerAsync(); } }
protected void Page_Load(object sender, EventArgs e) { WebUtility.AdminLoginAuth(); if (!bll_admin.RuleAuth("用户_订单管理")) { WebUtility.ShowError(WebUtility.ERROR101); } orders = bll_orders.GetModel(Request.QueryString["pkid"]); if (orders == null) { WebUtility.ShowError(WebUtility.ERROR102); } if (!Page.IsPostBack) { BindInfo(); } }
public JsonResult Put(int id, [FromBody] OrdersViewModel model) { if (!ModelState.IsValid) { Response.StatusCode = (int)HttpStatusCode.BadRequest; return Json(new { message = Validation.getValidationErrors(model) }); } if (model.Items == null || model.Items.Count() == 0) { return Json(new { message = "Список товаров не может быть пустыми" }); } IEnumerable<int> validItems = ItemsService.getValidItemsList(dapperService, model.Items).Select(x => x.Id); if (validItems == null || validItems.Count() == 0) { return Json(new { message = "Следующие товары не существует в базе", model.Items }); } List<int> inValidItems = new List<int>(); foreach (var i in model.Items) { if (!validItems.Contains(i)) { inValidItems.Add(i); } } if (inValidItems != null && inValidItems.Count() > 0) { return Json(new { message = "Следующие товары не существует в базе", Items = inValidItems }); } if (!RegionsService.checkForExists(dapperService, model.RegionId)) { return Json(new { message = $"RegionId={model.RegionId} не существует в базе" }); } OrdersModel item = new OrdersModel() { Id = id, RegionId = model.RegionId, ItemsIds = model.Items }; bool isSaved = ordersService.Update(item, id); return Json(new { message = isSaved ? "Сохранено" : "Не cохранено" }); }
public JsonResult Post([FromBody] OrdersViewModel model) { if (!ModelState.IsValid) { Response.StatusCode = (int)HttpStatusCode.BadRequest; return Json(new { message = Validation.getValidationErrors(model) }); } if (model.Items == null || model.Items.Count() == 0) { return Json(new { message = "Список товаров не может быть пустыми" }); } if (!Int32.TryParse(User.Claims.FirstOrDefault(x => x.Type == ClaimTypes.NameIdentifier)?.Value, out int id)) { return Json(new { message = "Пользователь не существует" }); } IEnumerable<int> validItems = ItemsService.getValidItemsList(dapperService, model.Items).Select(x => x.Id); if (validItems == null || validItems.Count() == 0) { return Json(new { message = "Следующие товары не существует в базе", model.Items }); } List<int> inValidItems = new List<int>(); foreach(var i in model.Items) { if(!validItems.Contains(i)){ inValidItems.Add(i); } } if(inValidItems != null && inValidItems.Count() > 0) { return Json(new { message = "Следующие товары не существует в базе" , Items = inValidItems }); } if (!RegionsService.checkForExists(dapperService, model.RegionId)) { return Json(new { message = $"RegionId={model.RegionId} не существует в базе"}); } OrdersModel items = new OrdersModel(model){ UserId = id }; bool isSaved = ordersService.Save(items); return Json(new { message = isSaved ? "Сохранено" : "Не cохранено" }); }
public void UpdateOrder(OrdersModel ordersModel) { using (var context = new WebShopContext()) { var result = context.OrdersModel.SingleOrDefault(b => b.OrderId == ordersModel.OrderId); if (result != null) { try { context.OrdersModel.Attach(ordersModel); context.Entry(ordersModel).State = EntityState.Modified; context.SaveChanges(); } catch (Exception ex) { throw; } } } }
public IActionResult SaveOrder([FromBody] OrdersModel order) { Logger.LogDebug("Entering SaveOrder"); try { order.PizzaIds = new List <string>(order.Pizzas.Count); foreach (var pizza in order.Pizzas) { PizzaRepository.SavePizza(pizza); order.PizzaIds.Add(pizza.Id); } OrdersRepository.SaveOrder(order); return(Created($"api/orders/{order.Id}", order)); } catch (Exception ex) { LogException(ex); return(StatusCode(500, "There was an error when trying to save the order.")); } }
private async Task <BaseModel> CreateAsync(CartModelItem model, long userId) { var paymentId = await GetPaymentIdAsync(model.TransactionId); var order = OrderMapper.MapCartModelToEntity(model, userId, paymentId); var response = new OrdersModel(); if (model == null) { response.Errors.Add(ErrorConstants.ModelIsNull); return(response); } var result = await _orderRepository.CreateAsync(order); if (!result) { response.Errors.Add(ErrorConstants.ImpossibleToCreateOrder); } return(response); }
/// <summary> /// Gets a list of orders of a status. No order details /// </summary> /// <param name="status">Status to search for</param> /// <returns>Model - list of orders, also status</returns> public OrdersModel GetOrders(string status) { var result = _apiService.GetRequest($"orders?direction=in&status={status.ToUpper()}"); var responseModel = JsonConvert.DeserializeObject <GetOrdersResponseModel>(result); var model = new OrdersModel(responseModel, status); foreach (var order in model.Orders) { var orderEntity = _dataService.GetOrder(order.OrderId) as Data.Entities.BricklinkOrder; if (orderEntity != null) { order.RealName = orderEntity.BuyerRealName; } } return(model); }
public ActionResult Edit(OrdersModel order) { string mainConn = ConfigurationManager.ConnectionStrings["DatabaseConn"].ConnectionString; using (SqlConnection sqlconn = new SqlConnection(mainConn)) { sqlconn.Open(); string query = "Update Orders Set Order_Date=@Order_Date,Computer_ID=@Computer_ID,Order_Value=@Order_Value,Discount=@Discount,Amount=@Amount where Order_ID=@Order_ID"; SqlCommand cmd = new SqlCommand(query, sqlconn); cmd.Parameters.AddWithValue("@Order_ID", order.Order_ID); cmd.Parameters.AddWithValue("@Order_Date", order.Order_Date); cmd.Parameters.AddWithValue("@Computer_ID", order.Computer_ID); cmd.Parameters.AddWithValue("@Order_Value", order.Order_Value); cmd.Parameters.AddWithValue("@Discount", order.Discount); cmd.Parameters.AddWithValue("@Amount", order.Amount); cmd.ExecuteNonQuery(); } return(RedirectToAction("Index")); }
public ActionResult Update(OrdersModel model) { if (!ModelState.IsValid) { return(new AjaxResult().Alert(T(Constants.Messages.InvalidModel))); } OrderInfo item = model.Id == 0 ? new OrderInfo() : service.GetById(model.Id); item.DeliveryTime = model.DeliveryTime; item.DeliveryPlace = model.DeliveryPlace; item.PaymentType = model.PaymentType; item.Notes = model.Notes; item.IsPaid = model.IsPaid; item.IsDeliverySuccessful = model.IsDeliverySuccessful; service.Save(item); return(new AjaxResult().NotifyMessage("UPDATE_ENTITY_COMPLETE").Alert(T("Cập nhật thành công."))); }
public JsonResult Get(int id) { if (id < 1) { return Json(new { message = "заказ не найден" }); } OrdersModel result = ordersService.Get(id); if(result == null) { return Json(new { message = "заказ не найден" }); ; } return Json(new { message = $"Заказы {result.User.FullName} Кол-во товаров:{result.Items.Count}", order = new { cutomerName = result.User.FullName, result.Sum, regionName = result.Region.Name, result.CreatedTime }, result.Items, }); ; }
public void InsertOrder(OrdersModel ordersModel) { try { OpenSqlConnection(); SqlCommand sqlCommand = CreateCommandSc("InsertOrder"); sqlCommand.Parameters.Add(new SqlParameter("@UserId", ordersModel.UserId)); sqlCommand.Parameters.Add(new SqlParameter("@Date", ordersModel.Date)); sqlCommand.Parameters.Add(new SqlParameter("@Price", ordersModel.Price)); ExecutedNonQuery(); } catch (SqlException ex) { throw new System.Exception(ex.Message); } finally { CloseSqlConnection(); } }
/// <summary> /// 得到一个对象实体 /// </summary> public OrdersModel DataRowToModel(DataRow row) { OrdersModel model = new OrdersModel(); if (row != null) { if (row["OrdersID"] != null && row["OrdersID"].ToString() != "") { model.OrdersID = int.Parse(row["OrdersID"].ToString()); } if (row["Orderdate"] != null && row["Orderdate"].ToString() != "") { model.Orderdate = DateTime.Parse(row["Orderdate"].ToString()); } if (row["UserId"] != null && row["UserId"].ToString() != "") { model.UserId = int.Parse(row["UserId"].ToString()); } if (row["Total"] != null && row["Total"].ToString() != "") { model.Total = decimal.Parse(row["Total"].ToString()); } if (row["DeliveryID"] != null && row["DeliveryID"].ToString() != "") { model.DeliveryID = int.Parse(row["DeliveryID"].ToString()); } if (row["DeliveryDate"] != null && row["DeliveryDate"].ToString() != "") { model.DeliveryDate = DateTime.Parse(row["DeliveryDate"].ToString()); } if (row["States"] != null && row["States"].ToString() != "") { model.States = int.Parse(row["States"].ToString()); } if (row["Remark"] != null) { model.Remark = row["Remark"].ToString(); } } return(model); }
private void btnDelete_Click(object sender, EventArgs e) { if (grvData.SelectedRowsCount < 1) { return; } try { string code = grvData.GetFocusedRowCellValue(colCode).ToString(); int id = TextUtils.ToInt(grvData.GetFocusedRowCellValue(colID)); int orderRequirePaidID = TextUtils.ToInt(grvData.GetFocusedRowCellValue(colOrderRequirePaidID)); if (MessageBox.Show("Bạn có chắc muốn xóa mã vụ việc [" + code + "]?", TextUtils.Caption, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { if (id > 0) { PaymentTableItemBO.Instance.Delete(id); if (orderRequirePaidID > 0) { OrderRequirePaidModel paid = (OrderRequirePaidModel)OrderRequirePaidBO.Instance.FindByPK(orderRequirePaidID); paid.Status = 1; OrderRequirePaidBO.Instance.Update(paid); } ArrayList listOrder = OrdersBO.Instance.FindByAttribute("OrderCode", code); if (listOrder.Count > 0) { OrdersModel order = (OrdersModel)listOrder[0]; order.StatusTT = 1; OrdersBO.Instance.UpdateQLSX(order); } } grvData.DeleteSelectedRows(); } } catch (Exception) { } }
public bool AddOrder(OrdersModel order) { using (var connection = new MySqlConnection(this.connectionString)) { try { var orderId = connection.QuerySingleOrDefault <int>( "insert into Orders ( first_name, last_name, email, adress, post_code, city, total) values( @first_name, @last_name, @email, @adress, @post_code, @city, @total ); select last_insert_id()", new { first_name = @order.Firstname, last_name = @order.Lastname, email = order.Email, adress = @order.Adress, post_code = @order.Postcode, city = @order.City, total = @order.Total }); return(this.AddProductsToOrder(order.UserId, orderId) ? this.DeleteCart(order.UserId) : false); } catch (Exception) { return(false); } } //return true; }
private void addOrdersButton_Click(object sender, RoutedEventArgs e) { OrdersModel order = new OrdersModel(); order.idParts = int.Parse(idPartsText.Text); order.amount = int.Parse(amountText.Text); order.orderDate = RoundUp(DateTime.Now, TimeSpan.FromMinutes(1)); order.realizationDate = order.orderDate.AddDays(int.Parse(deliveryTimeText.Text)); order.status = "w realizacji"; order.bookedAmount = 0; DatabaseAccess.saveOrders(order); idPartsText.Text = ""; partNameText.Text = ""; amountText.Text = ""; deliveryTimeText.Text = ""; loadOrdersList(); }
private void bwAddMore_DoWork(object sender, DoWorkEventArgs e) { string productNo = ""; txtProductNo.Dispatcher.Invoke((Action)(() => { productNo = txtProductNo.Text; })); orderSearch = OrdersController.SelectTop1(productNo); sizeRunSearchList = SizeRunController.Select(productNo); if (releaseTo == ERelease.ReleaseToOutsole) { outsoleReleaseMaterialSearchList = OutsoleReleaseMaterialController.Select(productNo); } else { outsoleReleaseMaterialSearchList = OutsoleReleaseWHInspectionController.Select(productNo); } outsoleMaterialSearchList = OutsoleMaterialController.Select(productNo); }
//new public int AddOrderAndDetails(NewOrderModel data) { bool result = false; int orderId; OrdersModel objOrder = new OrdersModel(); try { objOrder.OrderID = data.OrderID; objOrder.CustomerID = data.CustomerID; objOrder.TotalQty = data.TotalQty; objOrder.TotalAmount = data.TotalAmount; orderId = AddNewOrder(objOrder); if (orderId > 0) { DataTable dtOrders = new DataTable(); dtOrders = GetOrderDetailsTable(data.lstOrderDetails, orderId); if (dtOrders != null && dtOrders.Rows.Count == data.lstOrderDetails.Count) { result = AddAllOrderDetails(dtOrders, orderId); } //for (int i = 0; i < data.lstOrderDetails.Count; i++) //{ // data.lstOrderDetails[i].OrderID = orderId; // result = AddOrderDetails(data.lstOrderDetails[i]); //} } } catch (Exception ex) { throw ex; } return(orderId); }
public List <OrdersModel> GetOrders() { string sqlQuery = "SELECT * FROM orders"; List <OrdersModel> orderslist = new List <OrdersModel>(); //Using SqlConnection to establish connection to database //using SqlCommand passing in the SqlConnection and the sqlQuery using (SqlConnection con = new SqlConnection(CONNECTION)) using (SqlCommand cmd = new SqlCommand(sqlQuery, con)) { //open the connection con.Open(); //SqlDataReader is used because we are reading data from the database using (SqlDataReader reader = cmd.ExecuteReader()) { //while there are records in the database while (reader.Read()) { //store each value into the properties of productViewModel OrdersModel temp = new OrdersModel() { orderID = Convert.ToInt32(reader["orderID"]), orderDate = reader["orderDate"].ToString(), }; //Add the product object to the List of product orderslist.Add(temp); Console.WriteLine(" +================================================================+"); Console.WriteLine(" +----------------------------------------------------------------+"); Console.WriteLine(" ORDER ID " + " | " + temp.orderID); Console.WriteLine(" ORDER DATE " + " | " + temp.orderDate); } } } return(orderslist); }
public ActionResult PlaceOrder(string order, string restaurant) { OrdersModel newOrder = new OrdersModel { order = order, restaurantName = restaurant, employee = "DEFAULT EMPLOYEE", //This should get value from the authenthicated employee orderDate = DateTime.Now.Date.ToString("dd/MM/yyyy") }; try { db.OrdersModels.Add(newOrder); db.SaveChanges(); } catch (Exception e) { Console.WriteLine(e.Message); } return(RedirectToAction("Index")); }
public ActionResult GetOrders(int id) { Dictionary <string, List <CartEntry> > orders2 = new Dictionary <string, List <CartEntry> >(); List <CartEntry> orders = _context.CartEntries.Where(entry => entry.UserId == id && entry.OrderId != null).ToList(); foreach (CartEntry entry in orders) { if (!orders2.ContainsKey(entry.OrderId)) { orders2.Add(entry.OrderId, new List <CartEntry>()); orders2.SingleOrDefault(order => order.Key == entry.OrderId); } orders2.SingleOrDefault(order => order.Key == entry.OrderId); } OrdersModel ordersModel = new OrdersModel() { Orders = orders2 }; return(View("OrdersView", ordersModel)); }
public IEnumerable <OrdersModel> GetList(string itemName, string regionName, int page, ref int itemsCount) { List <OrdersModel> items = new List <OrdersModel>(); db.ClearParams(); db.AddParam("@page", DbType.Int32, page == 1 ? 0 : (page - 1) * Pagination.ItemsForPage); db.AddParam("@ItemsForPage", DbType.Int32, Pagination.ItemsForPage); string query = @" select distinct o.*, u.FirstName + ' ' + u.LastName as CustomerName from Orders o left join Users u on u.Id = o.UserId inner join Regions r on r.Id = o.RegionId inner join OrderItems oi on oi.OrderId = o.Id inner join Items i on i.Id = oi.ItemId where (r.Name LIKE N'%" + regionName + "%' and i.Name LIKE N'%" + itemName + "%') order by o.Id OFFSET @page ROWS FETCH NEXT @ItemsForPage ROWS ONLY; select count(distinct o.Id) as ItemsCount from Orders o left join Users u on u.Id = o.UserId inner join Regions r on r.Id = o.RegionId inner join OrderItems oi on oi.OrderId = o.Id inner join Items i on i.Id = oi.ItemId where (r.Name LIKE N'%" + regionName + "%' and i.Name LIKE N'%" + itemName + "%')"; using (IDataReader reader = db.Select(query)) { while (reader.Read()) { OrdersModel ret = new OrdersModel(); ret.Id = (int)reader["Id"]; ret.Status = (int)reader["Status"]; ret.Sum = (decimal)reader["Sum"]; ret.CreatedTime = (DateTime)reader["CreatedTime"]; ret.UserId = ret.User.Id = (int)reader["UserId"]; ret.RegionId = ret.User.Id = (int)reader["RegionId"]; ret.Region.Name = RegionsService.GetRegionFullAreaName(db, ret.RegionId); ret.User.FullName = (string)reader["CustomerName"]; items.Add(ret); } if (reader.NextResult()) { while (reader.Read()) { itemsCount = (int)reader["ItemsCount"]; } } } return(items); }
public IHttpActionResult Put(OrdersModel model) { var order = manager.GetById(model.Id); order.IsOffer = false; if (String.IsNullOrEmpty(order.OrderNumber)) { order.OrderNumber = numberProvider.GetNextOrderNumber(); } if (order.Customers.IsProspectiveCustomer) { order.Customers.IsProspectiveCustomer = false; var lastCustomerNumber = customerManager.GetEntities().Max(o => o.Number); order.Customers.Number = lastCustomerNumber + 1; } manager.SaveChanges(); return(Ok(new { id = model.Id })); }
public ActionResult Orders_Create([DataSourceRequest]DataSourceRequest request, OrdersModel order) { if (this.ModelState.IsValid) { var entity = new Order { RepairStartDate = order.RepairStartDate, RepairEndDate = order.RepairEndDate, DeliverDate = order.DeliverDate, Status = order.Status, ProblemDescription = order.ProblemDescription, Solution = order.Solution, WarrantyStatus = order.WarrantyStatus, WarrantyCard = order.WarrantyCard, WarrantyDate = order.WarrantyDate, LabourPrice = order.LabourPrice, CreatedOn = order.CreatedOn }; this.orderService.Create(entity); } return this.Json(new[] { order }.ToDataSourceResult(request, this.ModelState)); }
public ActionResult ViewOrders(DateTime startDate, DateTime endDate) { OrdersModel model = new OrdersModel(startDate, endDate); endDate = endDate.Date + new TimeSpan(1, 0, 0, 0); using (ClothesShopEntities entity = new ClothesShopEntities()) { model.AddRange(entity.Orders.Where(order => order.OrderDate >= startDate && order.OrderDate <= endDate).OrderBy(order => order.OrderDate) .Select(order => new OrderItem() { Date = order.OrderDate, ID = order.ID, Username = order.User.Username })); } return View(model); }
public ActionResult Orders_Update([DataSourceRequest]DataSourceRequest request, OrdersModel order) { var orderStored = this.orderService.GetById(order.Id); if (this.ModelState.IsValid) { orderStored.RepairStartDate = order.RepairStartDate; orderStored.RepairEndDate = order.RepairEndDate; orderStored.DeliverDate = order.DeliverDate; orderStored.Status = order.Status; orderStored.ProblemDescription = order.ProblemDescription; orderStored.Solution = order.Solution; orderStored.WarrantyStatus = order.WarrantyStatus; orderStored.WarrantyCard = order.WarrantyCard; orderStored.WarrantyDate = order.WarrantyDate; orderStored.LabourPrice = order.LabourPrice; orderStored.CreatedOn = order.CreatedOn; this.orderService.Update(orderStored); } return this.Json(new[] { order }.ToDataSourceResult(request, this.ModelState)); }