public ActionResult EditOrder(EditOrderModel model)
{
try
{
if (ModelState.IsValid)
{
// get order
var order = db.Orders.Where(r => r.orderId == model.OrderId).FirstOrDefault();
if (order != null)
{
// update order
order.phone = model.Phone;
order.fullname = model.FullName;
order.address = model.Address;
order.note = model.Note;
order.status = model.Status;
db.SaveChanges();
return(RedirectToAction("ListOrders"));
}
else
{
ModelState.AddModelError("", "Đơn hàng mã #" + model.OrderId + " không tồn tại trong hệ thống!");
}
}
}
catch (Exception ex)
{
ModelState.AddModelError("", ex.ToString());
EventWriter.WriteEventLog("SaleController - EditOrder: " + ex.ToString());
}
return(View(model));
}
public ActionResult EditOrder(OrderEditModel model)
{
IOrderRepository orderRepository = new OrderRepository();
//Order order = orderRepository.getOrder(model.id);
EditOrderModel orderEdit = new EditOrderModel();
orderEdit.id = model.id;
orderEdit.idStatus = model.idStatus;
orderEdit.load.Name = model.load.Name;
orderEdit.load.Price = model.load.Price;
orderEdit.load.Weight = model.load.Weight;
orderEdit.load.LoadType = model.load.LoadType;
orderEdit.vehicle.Name = model.vehicle.Name;
orderEdit.route.StartPoint = model.route.StartPoint;
orderEdit.route.EndPoint = model.route.EndPoint;
orderEdit.customer.Name = model.customer.Name;
orderEdit.customer.Surname = model.customer.Surname;
orderEdit.customer.Address = model.customer.Address;
orderEdit.customer.PhoneNumber = model.customer.PhoneNumber;
orderEdit.customer.Firm = model.customer.Firm;
orderEdit.driver.Name = model.driver.Name;
orderEdit.driver.Surname = model.driver.Surname;
orderEdit.driver.Address = model.driver.Address;
orderEdit.driver.PhoneNumber = model.driver.PhoneNumber;
orderEdit.driver.Firm = model.driver.Firm;
orderRepository.updateOrder(orderEdit);
return(RedirectToAction("OrderList", "Order"));
}
public ActionResult EditOrder(int id)
{
var model = new EditOrderModel();
try
{
// Get order
var order = db.Orders.Where(r => r.orderId == id).FirstOrDefault();
if (order != null)
{
// Get order details
var orderDetails = db.OrderDetails.Where(r => r.orderId == id).ToList();
var statusOptions = new SelectListItem[]
{
new SelectListItem {
Value = "1", Text = "Đang Mở", Selected = (order.status == (int)Order.Status.STATUS_OPENED)
},
new SelectListItem {
Value = "2", Text = "Đã tiếp nhận", Selected = (order.status == (int)Order.Status.STATUS_PENDIND)
},
new SelectListItem {
Value = "3", Text = "Đang xử lý", Selected = (order.status == (int)Order.Status.STATUS_PROCESSING)
},
new SelectListItem {
Value = "4", Text = "Hoàn tất", Selected = (order.status == (int)Order.Status.STATUS_FINISHED)
},
new SelectListItem {
Value = "5", Text = "Đã đóng", Selected = (order.status == (int)Order.Status.STATUS_CLOSED)
}
};
// Create view model
model.OrderId = order.orderId;
model.OrderDate = order.date.ToString("dd/MM/yyyy");
model.Phone = order.phone;
model.FullName = order.fullname;
model.Address = order.address;
model.Amount = order.amount;
model.Status = order.status;
model.Note = order.note;
model.Title = order.title;
model.StatusOptions = statusOptions;
model.OrderDetails = orderDetails;
}
else
{
ModelState.AddModelError("", "Đơn hàng mã #" + id + " không tồn tại trong hệ thống!");
}
}
catch (Exception ex)
{
ModelState.AddModelError("", ex.ToString());
EventWriter.WriteEventLog("SaleController - EditOrder: " + ex.ToString());
}
return(View(model));
}
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var model = new EditOrderModel
{
Order = OrderService.GetOrderDetails(id),
OrderStatus = OrderHistoryEnu.GetAllOrderStatus(),
Riders = UserService.GetUsersByype("0")
};
return(View(model));
}
public void Update(EditOrderModel order)
{
var orderToBeEdited = _context.Orders.SingleOrDefault(x => x.Id == order.Id);
var userAdded = _context.Users.SingleOrDefault(u => u.Id == order.UserResponsibleId);
var userResponsible = _context.Users.SingleOrDefault(u => u.Id == order.UserResponsibleId);
var userInvoice = _context.Users.SingleOrDefault(u => u.Id == order.UserResponsibleId);
orderToBeEdited.Id = order.Id;
orderToBeEdited.Status = order.Status;
orderToBeEdited.UserAdded = userAdded;
orderToBeEdited.UserInvoice = userInvoice;
orderToBeEdited.UserResponsible = userResponsible;
orderToBeEdited.ClientId = order.ClientId;
_context.SaveChanges();
}
public async Task <Order> EditOrder(EditOrderModel model)
{
var order = await _db.Orders.FirstOrDefaultAsync(x => x.Id == model.Id);
if (order == null)
{
return(null);
}
order.OrderDate = model.OrderDate;
_db.Orders.Attach(order);
_db.Entry(order).Property(x => x.OrderDate).IsModified = true;
await _db.SaveChangesAsync();
return(order);
}
//[ValidateAntiForgeryToken]
public ActionResult Edit([Bind(Include = "Id,Status,Address,Instructions,PickedBy,DeliveryCost,Comments")] OrderLocal order)
{
var response = OrderService.EditOrder_Admin(order);
if (response.Status)
{
return(RedirectToAction("Index"));
}
ModelState.AddModelError(string.Empty, response.Error);
var refMOdel = new EditOrderModel
{
Order = OrderService.GetOrderDetails(order.Id.ToString()),
OrderStatus = OrderHistoryEnu.GetAllOrderStatus(),
Riders = UserService.GetUsersByype("0")
};
return(View(refMOdel));
}
public IActionResult EditOrder(string id)
{
Order order = context.Orders.Include(w => w.Car).Where(c => c.OrderId == id).First();
if (order != null)
{
EditOrderModel editOrder = new EditOrderModel();
editOrder.OrderId = order.OrderId;
editOrder.UserId = order.UserId;
editOrder.CarId = order.Car.Id;
editOrder.Address = order.Address;
editOrder.Phone = order.Phone;
editOrder.UserName = order.UserName;
editOrder.Cars = context.Cars.ToList();
return(View(editOrder));
}
return(RedirectToAction("Index"));
}
public async Task <IActionResult> EditOrder(EditOrderModel order)
{
if (ModelState.IsValid)
{
Car car = await context.Cars.FindAsync(order.CarId);
User user = await userManager.FindByIdAsync(order.UserId);
if (car != null)
{
if (user != null)
{
Order newOrder = await context.Orders.FindAsync(order.OrderId);
if (newOrder != null)
{
newOrder.Car = car;
newOrder.UserId = user.Id;
newOrder.UserName = order.UserName;
newOrder.Phone = order.Phone;
newOrder.Address = order.Address;
await context.SaveChangesAsync();
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Order not found");
}
}
else
{
ModelState.AddModelError("", "User not found");
}
}
else
{
ModelState.AddModelError("", "Car not found");
}
}
return(View(order));
}
public ActionResult EditOrder(EditOrderModel model)
{
try
{
if (ModelState.IsValid)
{
DataManager.EditOrder(model);
}
}
catch
{
ViewBag.Text = string.Empty;
ViewBag.Error = "Something went wrong!";
return(this.View("Index", DataManager.GetOrderListFromDB()));
}
ViewBag.Text = "Order edited!";
ViewBag.Error = string.Empty;
return(this.View("Index", DataManager.GetOrderListFromDB()));
}
public void updateOrder(EditOrderModel model)
{
Order order = getOrder(model.id);
order.idStatus = model.idStatus;
Load load = Entities.Loads.Where(x => x.id == order.idLoad).FirstOrDefault();
TypesFreight typeFreight = Entities.TypesFreights.Where(x => x.id == load.IdType).FirstOrDefault();
TypesVehicle typeVehicle = Entities.TypesVehicles.Where(x => x.id == order.idTypeVehicles).FirstOrDefault();
Route route = Entities.Routes.Where(x => x.id == order.idRoutes).FirstOrDefault();
Customer customer = Entities.Customers.Where(x => x.id == order.idCustomer).FirstOrDefault();
Driver driver = Entities.Drivers.Where(x => x.id == order.idDriver).FirstOrDefault();
load.Name = model.load.Name;
load.Price = model.load.Price;
load.Weight = model.load.Weight;
typeFreight.TypeName = model.load.LoadType;
typeVehicle.TypeName = model.vehicle.Name;
if (model.route.StartPoint != null)
{
route.StartPoint = model.route.StartPoint;
Tuple <double, double> from = Geocoding.GeocodingProvider.getLatLong(model.route.StartPoint);
route.StartLat = from != null ? from.Item1 : 0;
route.StartLong = from != null ? from.Item2 : 0;
}
if (model.route.EndPoint != null)
{
route.EndPoint = model.route.EndPoint;
Tuple <double, double> to = Geocoding.GeocodingProvider.getLatLong(model.route.EndPoint);
route.EndLat = to != null ? to.Item1 : 0;
route.EndLong = to != null ? to.Item2 : 0;
}
customer.Name = model.customer.Name;
customer.Surname = model.customer.Surname;
customer.Address = model.customer.Address;
customer.PhoneNumber = model.customer.PhoneNumber;
customer.Firm = model.customer.Firm;
if (driver != null)
{
driver.Name = model.driver.Name;
driver.Surname = model.driver.Surname;
driver.Address = model.driver.Address;
driver.PhoneNumber = model.driver.PhoneNumber;
driver.Firm = model.driver.Firm;
}
else
{
Driver newDriver = new Driver
{
Name = model.driver.Name,
Surname = model.driver.Surname,
Address = model.driver.Address,
PhoneNumber = model.driver.PhoneNumber,
Firm = model.driver.Firm
};
Entities.Drivers.Add(newDriver);
Entities.SaveChanges();
order.idDriver = newDriver.id;
}
Entities.SaveChanges();
}
public void Put([FromBody] EditOrderModel order)
{
_orders.Update(order);
}
/// <summary>
/// Gets the order for edit.
/// </summary>
/// <param name="OrderId">The order identifier.</param>
/// <param name="pageNo">The page no.</param>
/// <param name="rowsPerPage">The rows per page.</param>
/// <param name="searchString">The search string.</param>
/// <param name="column">The column.</param>
/// <param name="direction">The direction.</param>
/// <returns></returns>
public EditOrderModel GetOrderForEdit(long OrderId, int pageNo, int rowsPerPage, string searchString, string column, string direction, string hostingURL)
{
EditOrderModel editOrderModel = new EditOrderModel();
OrderProductListModel orderProductListModel = new OrderProductListModel();
List <OrderProductListDataModel> orderProductListDataModels = new List <OrderProductListDataModel>();
try
{
try
{
SqlParameter[] parameter = new SqlParameter[6];
parameter[0] = new SqlParameter("PAGENO", pageNo);
parameter[1] = new SqlParameter("RECORDPERPAGE", rowsPerPage);
parameter[2] = new SqlParameter("SEARCHSTRING", searchString);
parameter[3] = new SqlParameter("COLUMN", column);
parameter[4] = new SqlParameter("DIRECTION", direction);
parameter[5] = new SqlParameter("ORDERID", OrderId);
DataSet dataSet = DBHelper.GetDataTable("ORDERPRODUCTLIST", parameter, DBHelper.ParseString(settings.Value.AppDbContext));
if (dataSet != null && dataSet.Tables != null && dataSet.Tables.Count > 0)
{
DataTable dtProducts = dataSet.Tables[0];
DataTable dtTotal = dataSet.Tables[1];
DataTable dtImage = dataSet.Tables[2];
DataTable dtSizeGroup = dataSet.Tables[3];
DataTable dtProductSizeGroup = dataSet.Tables[4];
DataTable dtOrder = new DataTable();
DataTable dtOrderDetail = new DataTable();
if (dataSet.Tables.Count > 5)
{
dtOrder = dataSet.Tables[5];
dtOrderDetail = dataSet.Tables[6];
}
if (dtProducts != null && dtProducts.Rows.Count > 0)
{
foreach (DataRow item in dtProducts.Rows)
{
OrderProductListDataModel orderProductListModelObject = new OrderProductListDataModel();
orderProductListModelObject.ColorId = DBHelper.ParseString(item["ProductColorId"]);
orderProductListModelObject.Color = DBHelper.ParseString(item["ColorName"]);
orderProductListModelObject.Price = DBHelper.ParseString(item["Price"]);
orderProductListModelObject.ProductId = DBHelper.ParseString(item["ProductId"]);
orderProductListModelObject.ProductName = DBHelper.ParseString(item["Name"]);
orderProductListModelObject.SubTotal = "0";
orderProductListModelObject.Quantity = "0";
if (dtOrderDetail != null && dtOrderDetail.Rows.Count > 0)
{
DataRow[] drOrderDetail = dtOrderDetail.Select("ProductColorFK='" + DBHelper.ParseString(item["ProductColorId"]) + "' and ProductFK='" + DBHelper.ParseString(item["ProductId"]) + "'");
if (drOrderDetail != null && drOrderDetail.Length > 0)
{
orderProductListModelObject.IsSelected = true;
orderProductListModelObject.Quantity = DBHelper.ParseString(drOrderDetail[0]["Quantity"]);
orderProductListModelObject.SubTotal = DBHelper.ParseString(DBHelper.ParseDouble(orderProductListModelObject.Quantity) * DBHelper.ParseDouble(orderProductListModelObject.Price));
}
}
DataRow[] drSizeGroup = dtSizeGroup.Select("SizeFK='" + DBHelper.ParseString(item["SizeId"]) + "'");
if (drSizeGroup != null && drSizeGroup.Length > 0)
{
foreach (var size in drSizeGroup)
{
orderProductListModelObject.SizeGroup += size["Name"] + "/";
}
orderProductListModelObject.SizeGroup = orderProductListModelObject.SizeGroup.TrimEnd('/');
orderProductListModelObject.SizeGroup += " - ";
}
DataRow[] drProductSizeGroup = dtProductSizeGroup.Select("ProductFK='" + DBHelper.ParseString(item["ProductId"]) + "'");
if (drProductSizeGroup != null && drProductSizeGroup.Length > 0)
{
foreach (var size in drProductSizeGroup)
{
orderProductListModelObject.SizeGroup += size["Name"] + "/";
}
orderProductListModelObject.SizeGroup = orderProductListModelObject.SizeGroup.TrimEnd('/');
}
DataRow[] drImage = dtImage.Select("ProductColorFK='" + item["ProductColorId"] + "'");
if (drImage != null && drImage.Length > 0)
{
orderProductListModelObject.Image = hostingURL + Constants.ProductImagesPath.Replace(@"\", "/") + "/" + DBHelper.ParseString(drImage[0]["Image"]);
}
orderProductListDataModels.Add(orderProductListModelObject);
}
orderProductListModel.Items = orderProductListDataModels;
orderProductListModel.Total = DBHelper.ParseString(dtTotal.Rows.Count);
editOrderModel.ProductList = orderProductListModel;
}
if (dtOrder != null && dtOrder.Rows.Count > 0)
{
editOrderModel.CustomerAddressId = DBHelper.ParseString(dtOrder.Rows[0]["UserAddressFK"]);
editOrderModel.CustomerId = DBHelper.ParseString(dtOrder.Rows[0]["UserFK"]);
}
}
return(editOrderModel);
}
catch (Exception ex)
{
LogHelper.ExceptionLog(ex.Message + " ::::: " + ex.StackTrace);
throw ex;
}
}
catch (Exception ex)
{
LogHelper.ExceptionLog(ex.Message + " ::::: " + ex.StackTrace);
throw ex;
}
}
