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));
}
