private void addOrder(OrderDetailModel items)
{
try
{
UCOrder ucOrder = new UCOrder();
ucOrder.lblNameItem.Text = items.ProductName;
ucOrder.lblQuanityItem.Text = "1";
ucOrder.Tag = items;
ucOrder.lblPriceItem.Text = money.Format2(items.Price.ToString());
SystemLog.LogPOS.WriteLog("addOrder::::::::::Item::::::" + items.ProductName + ":::::" + items.Price);
ucOrder.Width = flowLayoutPanel1.Width;
flowLayoutPanel1.Controls.Add(ucOrder);
//if (flagUcSeatClick > 0)
//{
// if (indexOfUcSeat == 0)
// flpOrder.Controls.SetChildIndex(ucOrder, 1 + countItemOfSeat);
// else
// flpOrder.Controls.SetChildIndex(ucOrder, indexOfUcSeat + countItemOfSeat);
//}
}
catch (Exception ex)
{
SystemLog.LogPOS.WriteLog("addOrder:::::::::::::::::::::::::" + ex.Message);
}
}
public async Task <HttpResponseMessage> DeleteAsync(OrderDetailModel _params)
{
var Res = Request.CreateResponse();
var Result = new Res();
try
{
if (_params != null)
{
await Task.Run(() => _orderDetailService.Delete(_params));
Result.Status = true;
Result.Message = "Xóa thành công";
Result.StatusCode = HttpStatusCode.OK;
}
else
{
Result.Status = false;
Result.Message = "Xóa thất bại";
Result.StatusCode = HttpStatusCode.InternalServerError;
}
Res.Content = new StringContent(JsonConvert.SerializeObject(Result));
return(Res);
}
catch (Exception ex)
{
Result.Status = false;
Result.Message = "Có lỗi xảy ra trong quá trình xóa " + ex.Message;
Result.StatusCode = HttpStatusCode.BadRequest;
throw new Exception(ex.Message);
}
}
private List <OrderModel> CreateOrderModelList(List <Order> orderList)
{
// 要返回的 OrderModel 列表
List <OrderModel> omList = new List <OrderModel>();
foreach (var item in orderList)
{
OrderModel om = new OrderModel(item);
List <OrderDetailModel> odmList = new List <OrderDetailModel>();
foreach (OrderDetail model in _orderDetailBLL.GetOrderDetailByOrderNo(item.OrderNo))
{
OrderDetailModel orm = new OrderDetailModel(model);
Goods good = _goodsBLL.GetGoodsById(model.GoodsId);
orm.GoodsName = good.Name;
orm.PicturePath = _goodsImagesBLL.GetPictureByGoodsId(model.GoodsId).ImagePath;
orm.Description = good.Description;
orm.GoodsCode = good.Code;
odmList.Add(orm);
}
om.GoodsModelList = odmList;
omList.Add(om);
}
return(omList);
}
public IActionResult OrderDetail(long orderId)
{
try
{
if (orderId > 0)
{
var orderDetail = iOrder.GetOrderDetail(orderId);
var invoiceList = iOrderInvoice.GetOrderInvoiceDetail(0, orderId);
if (orderDetail != null)
{
OrderDetailModel orderDetailModel = OrderHelper.BindOrderDetailModel(orderDetail, invoiceList);
return(Ok(ResponseHelper.Success(orderDetailModel)));
}
else
{
return(Ok(ResponseHelper.Error(MessageConstants.NoOrderFound)));
}
}
else
{
return(Ok(ResponseHelper.Error(MessageConstants.CompulsoryData)));
}
}
catch (Exception ex)
{
LogHelper.ExceptionLog(ex.Message + " ::::: " + ex.StackTrace);
return(Ok(ResponseHelper.Error(ex.Message)));
}
}
public void CheckoutCart(OrderModel order)
{
string userId = User.FindFirstValue(ClaimTypes.NameIdentifier);
var listCart = _context.ShoppingCarts.Where(s => s.UserID == userId).ToList();
order.Date = DateTime.Now;
order.UserID = userId;
order.PaymentID = 1;
order.TotalMoney = Total();
order.Status = true;
order.OrderDetails = new List <OrderDetailModel>();
foreach (var cart in listCart)
{
var orderDetail = new OrderDetailModel
{
ProductID = cart.ProductId,
Quantity = cart.Amount,
Status = true,
};
order.OrderDetails.Add(orderDetail);
}
_context.Orders.Add(order);
_context.SaveChanges();
}
public ActionResult Checkout(CheckoutViewModel checkoutViewModel)
{
checkoutViewModel.CourtItems = GetCourtItemList();
OrderModel orderModel = new OrderModel();
orderModel.FullName = checkoutViewModel.DeliveryInfoViewModelRequired.FirstName + " " + checkoutViewModel.DeliveryInfoViewModelRequired.LastName;
orderModel.Address = checkoutViewModel.DeliveryInfoViewModelRequired.Address + " " + checkoutViewModel.DeliveryInfoViewModelRequired.Floor;
orderModel.Phone = checkoutViewModel.DeliveryInfoViewModelRequired.PhoneNumber;
orderModel.Email = User.Identity.Name;
orderModel.DeliverEmail = checkoutViewModel.DeliveryInfoViewModelRequired.UserEmail;
orderModel.TotalCourtPrice = HelperClasses.HelperClasses.getTotalCourtPrice(checkoutViewModel.CourtItems);
orderModel.OrderDate = DateTime.Now;
orderModel.Completed = 0;
db.Orders.Add(orderModel);
db.SaveChanges();
foreach (CourtItem courtItem in checkoutViewModel.CourtItems)
{
OrderDetailModel orderDetailModel = new OrderDetailModel();
orderDetailModel.OrderID = orderModel.ID;
orderDetailModel.Type = courtItem.CrepeSize;
orderDetailModel.Ingredients = courtItem.Ingredients;
orderDetailModel.Quantity = courtItem.Quantity;
orderDetailModel.TotalPrice = courtItem.TotalPrice + "";
db.OrderDetails.Add(orderDetailModel);
db.SaveChanges();
}
db.CourtItems.RemoveRange(db.CourtItems.Where(x => x.Email == User.Identity.Name));
db.SaveChanges();
return(RedirectToAction("OrderHistory"));
}
public static WeakOrderDetailsEntity ToDto(OrderDetailModel model)
{
return(new WeakOrderDetailsEntity
{
OrdID = model.OrdID,
OrdNo = model.OrdNo,
OrdDate = model.OrdDate,
OffID = model.OffID,
OfdNo = model.OfdNo,
PrdID = model.PrdID,
SupID = model.SupID,
SupName = model.SupName,
SubAddress = model.SubAddress,
ClrID = model.ClrID,
ClrName = model.ClrName,
TypeProductID = model.TypeProductID,
TypeName = model.TypeName,
TrdID = model.TrdID,
TrdName = model.TrdName,
BrandID = model.BrandID,
BrandName = model.BrandName,
Description = model.Description,
Waranty = model.Waranty,
PrdEnabled = model.PrdEnabled,
//Amount = model.Amount,
TotalCost = model.TotalCost,
Cost = model.Cost,
AmountApprove = model.AmountApprove,
AmountRec = model.AmountRec,
SerialStatus = model.SerialStatus,
});
}
public static OrderDetailModel _ToDto(OrderDetailModel entity)
{
if (entity == null)
{
return(null);
}
return(new OrderDetailModel
{
OrdID = entity.TypeName,
OrdNo = entity.OrdNo,
OffID = entity.OffID,
OfdNo = entity.OfdNo,
PrdID = entity.PrdID,
//Amount = entity.Amount,
Cost = entity.Cost,
TotalCost = entity.TotalCost,
TrdID = entity.TrdID,
TrdName = entity.TrdName,
BrandID = entity.BrandID,
BrandName = entity.BrandName,
ClrID = entity.ClrID,
ClrName = entity.ClrName,
TypeProductID = entity.TypeProductID,
TypeName = entity.TypeName,
Description = entity.Description,
Waranty = entity.Waranty,
PrdEnabled = entity.PrdEnabled,
SupID = entity.SupID,
SupName = entity.SupName,
SubAddress = entity.SubAddress,
AmountApprove = entity.AmountApprove,
AmountRec = entity.AmountRec,
});
}
private void btnRight_Click(object sender, EventArgs e)
{
try
{
foreach (Control ctr in flpNewTable.Controls)
{
UCOrder ucOrder = (UCOrder)ctr;
if (ucOrder.BackColor == Color.FromArgb(0, 102, 204))
{
OrderDetailModel itemOrder = (OrderDetailModel)ucOrder.Tag;
OrderSlpitNew.FloorID = lblNewTable.Text;
OrderSlpitNew.ShiftID = OrderMain.ShiftID;
OrderSlpitNew.ListOrderDetail.Remove(itemOrder);
OrderMain.addItemToList(itemOrder);
OrderSlpitNew.SubTotal();
OrderMain.SubTotal();
OrderMain.isTransferTableAll = 0;
RefeshOrderMain(OrderMain, flpOldTable);
RefeshOrderMain(OrderSlpitNew, flpNewTable);
}
}
}
catch (Exception ex)
{
LogPOS.WriteLog("frmTransferTable::::::::::::::::::btnLeft_Click::::::::::::::::::::" + ex.Message);
}
}
void ucOrder_Click(object sender, EventArgs e)
{
try
{
UCOrder ucOder = (UCOrder)sender;
OrderDetailModel item = (OrderDetailModel)ucOder.Tag;
foreach (Control ctr in flpOldTable.Controls)
{
if (ctr is UCOrder)
{
if (ctr.BackColor == Color.FromArgb(0, 102, 204))
{
ctr.BackColor = Color.FromArgb(255, 255, 255);
ctr.ForeColor = Color.FromArgb(51, 51, 51);
}
}
}
ucOder.BackColor = Color.FromArgb(0, 102, 204);
ucOder.ForeColor = Color.FromArgb(255, 255, 255);
}
catch (Exception ex)
{
LogPOS.WriteLog("frmTransferTable::::::::::::::::::::::::addOrder::::::::::::::" + ex.Message);
}
}
// Lấy các chi tiết hóa đơn của đơn hàng
public List <OrderDetailModel> getListDetailOrder(long id)
{
List <OrderDetailModel> listDetail = new List <OrderDetailModel>();
string sql = "SELECT chi_tiet_don_hang.*, san_pham.ten_san_pham FROM chi_tiet_don_hang INNER JOIN san_pham " +
"ON san_pham.ma_san_pham = chi_tiet_don_hang.ma_san_pham" +
" WHERE ma_don_hang = @id";
var command = new MySqlCommand(sql, MySqlDatabase.Connection);
command.CommandText = sql;
command.Parameters.AddWithValue("id", id);
var reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
OrderDetailModel detail = new OrderDetailModel();
detail.order_id = reader.GetInt32("ma_don_hang");
detail.product_id = reader.GetInt32("ma_san_pham");
detail.product_name = reader.GetString("ten_san_pham");
detail.price = reader.GetInt32("don_gia");
detail.count = reader.GetInt32("so_luong_ban");
detail.total = reader.GetInt32("thanh_tien");
listDetail.Add(detail);
}
}
else
{
listDetail = null;
}
reader.Close();
return(listDetail);
}
private void InsertOrder()
{
var cart = Session[Values.CartSession] as List <CartItem>;
if (cart != null && cart.Count > 0)
{
var order = new OrderModel()
{
ReceiverName = _receiverInformation.FullName,
ReceiverPhone = _receiverInformation.MobileNumber,
ReceiverAddress = _receiverInformation.Address + ", " + _receiverInformation.Street,
CreatedDateTime = DateTime.Now,
Amount = cart.Sum(item => item.Product.Price * item.Quantity),
Status = false,
UserId = 2 //Edit later
};
_orderService.InsertOrder(order);
foreach (var item in cart)
{
var orderDetail = new OrderDetailModel()
{
OrderId = order.Id,
ProductId = item.Product.Id,
UnitPrice = item.Product.Price,
Quantity = item.Quantity
};
_orderService.InsertOrderDetail(orderDetail);
}
Session.Remove(Values.CartSession);
}
}
public void InsertOrderDetail(OrderDetailModel orderDetailModel)
{
var orderDetail = Mapper.Map <OrderDetail>(orderDetailModel);
_shoppingContext.OrderDetails.Add(orderDetail);
_shoppingContext.SaveChanges();
}
public bool UniqueItemNum(string itemNum, int?id)
{
if (id == null)
{
id = 0;
}
OrderDetailModel findItem = db.GetDB().OrderDetails.Find(id);
string oldItemNum = "-1";
if (findItem != null)
{
oldItemNum = findItem.ItemNumber;
}
if (itemNum == oldItemNum)
{
return(true);
}
List <OrderDetailModel> orderDetailModels = db.GetDB().OrderDetails.ToList();
foreach (var i in orderDetailModels)
{
if (i.ItemNumber == itemNum)
{
return(false);
}
}
return(true);
}
public async Task CreateOrder(OrderDetailModel orderDetailModel)
{
foreach (var item in orderDetailModel.OrderModels)
{
var userItem = new UserItem
{
UserId = orderDetailModel.UserId,
ItemId = item.ItemId,
Amount = item.Amount
};
var userItemEntity = _context.UserItems
.Where(x => x.UserId == userItem.UserId &&
x.ItemId == userItem.ItemId)
.FirstOrDefault();
if (userItemEntity == null)
{
_context.UserItems.Add(userItem);
}
else
{
userItemEntity.Amount = userItem.Amount;
}
}
await _context.SaveChangesAsync();
}
/// <summary>
/// DELETE /api/orders/{id}
/// </summary>
/// <param name="id"></param>
/// <param name="data"></param>
/// <returns></returns>
public HttpResponseMessage Delete(int id, OrderDetailModel model)
{
var context = this.DbContext;
var entity = context.OrderDetails.Find(id);
if (entity == null)
{
throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.NotFound));
}
if (!this.User.CanDelete(entity))
{
throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.Forbidden));
}
// create the web event
var webEvent = new OrderDetailDeletedEvent(entity);
// delete the entity
context.OrderDetails.Remove(entity);
// persist changes to the database
context.SaveChanges();
// fire the web event
webEvent.Raise();
return(new HttpResponseMessage(HttpStatusCode.NoContent));
}
public OrderDetailModel ConvertToOrderDetailModel(OrderDetailDTO orderDetailDTO)
{
OrderDetailModel orderDetailModel = new OrderDetailModel();
orderDetailModel.Id = orderDetailDTO.Id;
orderDetailModel.ItemNumber = orderDetailDTO.ItemNumber;
orderDetailModel.Description = orderDetailDTO.Description;
orderDetailModel.Tariff = orderDetailDTO.Tariff;
orderDetailModel.Quantity = orderDetailDTO.Quantity;
orderDetailModel.Cartons = orderDetailDTO.Cartons;
orderDetailModel.Cube = orderDetailDTO.Cube;
orderDetailModel.KGS = orderDetailDTO.KGS;
orderDetailModel.UnitPrice = orderDetailDTO.UnitPrice;
orderDetailModel.RetailPrice = orderDetailDTO.RetailPrice;
orderDetailModel.Warehouse = orderDetailDTO.Warehouse;
orderDetailModel.Size = orderDetailDTO.Size;
orderDetailModel.Colour = orderDetailDTO.Colour;
orderDetailModel.OrderId = orderDetailDTO.OrderId;
if (orderDetailModel.OrderId == 0)
{
orderDetailModel.OrderId = db.GetDB().Orders.ToList().Last().Id;
}
orderDetailModel.Line = "";
orderDetailModel.Item = "";
return(orderDetailModel);
}
public static OrderDetailModel toOrderDetail(OrderModel order)
{
OrderDetailModel result = null;
if (order != null)
{
result = new OrderDetailModel();
result.userName = order.Ct_Name;
result.mobile = order.Ct_Mobile;
result.pictureUrl = WebConfig.reswebsite() + order.OrderImg;
result.successUrl = WebConfig.reswebsite() + order.SuccessImg;
result.pictureUrl2 = WebConfig.reswebsite() + order.OrderImg2;
result.successUrl2 = WebConfig.reswebsite() + order.SuccessImg2;
result.pictureUrl3 = WebConfig.reswebsite() + order.OrderImg3;
result.successUrl3 = WebConfig.reswebsite() + order.SuccessImg3;
result.pictureUrl4 = WebConfig.reswebsite() + order.OrderImg4;
result.successUrl4 = WebConfig.reswebsite() + order.SuccessImg4;
result.pictureUrl5 = WebConfig.reswebsite() + order.OrderImg5;
result.successUrl5 = WebConfig.reswebsite() + order.SuccessImg5;
result.status = order.OrderStatus;
result.orderId = order.orderId;
result.orderTime = StringHelper.GetUTCTime(order.orderTime);
result.address = order.Ct_Address;
result.remark = order.Memo;
result.note = order.Note;
result.cashcouponmoney = order.CashCouponAmount;
result.fianlamount = order.FianlAmount;
}
return(result);
}
public async Task <IActionResult> CreateOrder(OrderFillInModel order)
{
if (ModelState.IsValid)
{
OrderDetailModel detail = new OrderDetailModel
{
DiningTableId = order.TableNumber,
ServerId = int.Parse(order.Server),
FoodId = int.Parse(order.FoodName),
Quantity = order.Quantity
};
await _order.InsertOrderDetail(detail);
}
// Dropdown list content is null after data post, need to repopulate the list
var tables = await GetAllTables();
ViewBag.TableList = tables;
var servers = await GetAllServers();
ViewBag.ServerList = servers;
var foods = await GetFoodTypes();
ViewBag.FoodTypeList = foods;
return(View());
}
public int Update(OrderDetailModel entity)
{
TblOrderDetail obj = _mapper.Map <OrderDetailModel, TblOrderDetail>(entity);
_repository.Update(obj);
return(obj.OrderDetailId);
}
private void InsertOrder()
{
var customer = Session[Values.CUSTOMER_SESSION] as CustomerModel;
var cart = Session[Values.CartSession] as List <CartItem>;
if (cart != null && cart.Count > 0)
{
var order = new OrderModel()
{
ReceiverName = _receiverInformation.FullName,
ReceiverPhone = _receiverInformation.MobileNumber,
ReceiverAddress = _receiverInformation.Address + ", " + _receiverInformation.Street,
CreatedDateTime = DateTime.Now,
Amount = cart.Sum(item => item.Product.Price * item.Quantity),
CustomerId = customer.Id, //Edit later
Code = _codeGeneratingService.GenerateCode(Values.OrderPrefix),
PaymentId = payment.id
};
_orderService.InsertOrder(order);
foreach (var item in cart)
{
var orderDetail = new OrderDetailModel()
{
OrderId = order.Id,
ProductId = item.Product.Id,
UnitPrice = item.Product.Price,
Quantity = item.Quantity
};
_orderService.InsertOrderDetail(orderDetail);
_productService.DescreaseProduct(item.Product.Id, item.Quantity);
}
Session.Remove(Values.CartSession);
}
}
public ActionResult detail(int id)
{
Order o = new OrderHandler().GetOrder(id);
OrderModel om = new OrderModel();
om.Id = o.Id;
om.cellno = o.Cellno;
om.City = o.city.Name;
om.orderdate = o.Orderdate;
om.OrderHolder = o.OrderHolder;
om.totalAmount = o.TotalAmount;
om.status = o.status.Name;
foreach (var od in o.Detail)
{
OrderDetailModel odm = new OrderDetailModel();
odm.Id = od.Id;
odm.Quantity = od.Quantity;
odm.jewelry = od.jewelry.Name;
om.detail.Add(odm);
}
ViewBag.order = om;
UserModel currentUser = (UserModel)Session[WebUtil.CURRENT_USER];
if (currentUser != null)
{
User user = new UserHandler().GetUserById(currentUser.Id);
if (user.IsInRole(WebUtil.ADMIN_ROLE))
{
return(PartialView("~/Views/Shared/_OrderDetailView.cshtml", om));
}
}
return(PartialView("~/Views/Shared/_orderdetailuser.cshtml", om));
}
// PUT: api/OrderDetail2/5
public void Put(OrderDetailModel view)
{
int result = 0;
string constr = ConfigurationManager.ConnectionStrings["DeliviveConnection"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
string sql = "UPDATE [dbo].[Order_Detail] " +
" SET [Order_id] = " + view.Order_id +
",[Restaurant_id] = " + view.Restaurant_id +
",[Food_id] = " + view.Food_id +
",[Quantity] = " + view.Quantity +
"WHERE [OrderDetail_Id] = " + view.OrderDetail_id + ";";
using (SqlCommand cmd = new SqlCommand(sql))
{
cmd.Connection = con;
con.Open();
result = cmd.ExecuteNonQuery();
con.Close();
}
//if (result > 0)
// return Json("Successfully Updated Order_Detail!", JsonRequestBehavior.AllowGet);
//else
// return Json("Error on Updateing Order_Detail!");
}
}
public async Task <bool> SyncOrders(string shopifyurl, string token, int duration)
{
bool response;
try
{
string[] shosp = shopifyurl.Split(".");
string shopname = shosp[0];
var client = new HttpClient();
OrderDetailModel model = new OrderDetailModel();
model.shopifyurl = shopifyurl;
model.token = token;
model.duration = duration;
List <Order> orders = await new OrderHandler().GetAllOrders(model);
string json = JsonConvert.SerializeObject(orders);
List <OrderReturnModel> orderReturns = await new OrderHandler().GetOrderReturnModel(orders, shopname);
string apiUrl2 = $"{config.Value.ResponseUrl}/api/AddShopifyOrders";
var response2 = client.PostAsJsonAsync(apiUrl2, orderReturns).Result;
response2.EnsureSuccessStatusCode();
string responseBody1 = await response2.Content.ReadAsStringAsync();
var readString = JObject.Parse(responseBody1)["status"];
response = Convert.ToBoolean(readString);
}
catch (Exception)
{
return(false);
}
return(response);
}
public ActionResult Detail(string dfn, string ifn)
{
OrderDetailModel model = new OrderDetailModel();
model.Patient = this.CurrentPatient;
OrderDetailResult result = this.DashboardRepository.Orders.GetDetail(dfn, ifn);
if (!result.Success)
{
this.Error(result.Message);
}
else
{
model.OrderDetail = result.OrderDetail;
}
// *** Set return url ***
if (TempData.ContainsKey(ReturnUrl))
{
model.ReturnUrl = TempData[ReturnUrl].ToString();
TempData[ReturnUrl] = TempData[ReturnUrl];
}
return(View(model));
}
// GET: Admin/Order/Details/5
public async Task <IActionResult> Details(int?id)
{
if (id == null)
{
return(NotFound());
}
var order = await _context.Orders.
Include(m => m.Status).
Include(m => m.Details).
FirstOrDefaultAsync(m => m.Id == id);
var model = new OrderDetailModel {
Id = order.Id,
Contact = order.Contact,
ShippingAddress = order.ShippingAddress,
DatePlaced = order.DatePlaced,
PersonName = order.PersonName,
Status = order.Status.Name,
TotalItems = order.TotalItems,
TotalPrice = order.TotalPrice,
Details = await _context.OrderDetails.Include(d => d.Product).Where(d => d.Order.Id == order.Id).ToListAsync(),
Payment = await _context.Payments.Include(p => p.Order).SingleOrDefaultAsync(p => p.Order.Id == order.Id)
};
if (order == null)
{
return(NotFound());
}
return(View(model));
}
public async void Edit_Order_Valid(OrderDetailModel order)
{
var mockItemService = new Mock <IItemService>();
var mockCustomerService = new Mock <ICustomerService>();
var mockOrderService = new Mock <IOrderService>();
mockOrderService.Setup(x => x.Update(It.IsAny <Order>()))
.ReturnsAsync(1);
order.BillingAddress = TestUtilities.GetValidAddress();
order.ShippingAddress = TestUtilities.GetValidAddress();
order.Cart.Clear();
order.Cart.Add(TestUtilities.GetValidOrderItem());
order.Status = OrderStatus.Sent;
order.BillingContact = TestUtilities.GetValidContact();
IMapper mapper = TestUtilities.GetMapper(new ItemProfile(), new OrderProfile(), new SharedProfile());
OrderManager manager = new OrderManager(_logger, mapper, mockOrderService.Object, mockItemService.Object, mockCustomerService.Object, Mock.Of <IShipmentService>(), _eventService, Mock.Of <IIsotopeOrderingAuthorizationService>());
ApplicationResult result = await manager.Edit(order);
_output.WriteLine(result.Message);
CustomAssertions.AssertValidationErrorsDoNotExist(result);
}
public ActionResult Post(OrderDetailModel view)
{
int result = 0;
string constr = ConfigurationManager.ConnectionStrings["DeliviveConnection"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
string sql = "INSERT INTO [dbo].[Order_Detail] ([Order_id],[Restaurant_id,[Food_id,[Quantity]) VALUES ("
+ view.Order_id + "," + view.Restaurant_id + "," + view.Food_id + "," + view.Quantity + ");";
using (SqlCommand cmd = new SqlCommand(sql))
{
cmd.Connection = con;
con.Open();
result = cmd.ExecuteNonQuery();
con.Close();
}
if (result > 0)
{
return(Json("Successfully inserted!"));
}
else
{
return(Json("Error on inserting!"));
}
}
}
public OrderDetailModel Get(int id)
{
var list = hostelContext.PersonOrders.Where(d => d.OrderId == id).Select(d => new PersonOrderDetail()
{
Person = d.Person,
Status = d.Status,
ApplyTime = d.CreateTime.ToString("yyyy-MM-dd HH:mm:ss"),
ApplyNum = d.ApplyNum ?? 0,
GUID = d.GUID,
POrderId = d.Id,
OrderType = d.HotelOrder.OrderType,
OrderStart = d.HotelOrder.Start,
}).ToList();
foreach (var item in list)
{
if (item.OrderType == 1 && item.OrderStart < DateTime.Now.Date)
{
item.IsOffline = true;
}
var count = hostelContext.PersonEmploys.Count(d => d.PersonId == item.Person.Id && d.Evaluate != null);
if (count > 0)
{
item.Evaluate = (float)(hostelContext.PersonEmploys.Where(d => d.PersonId == item.Person.Id).Sum(d => d.Evaluate) * 1.0 / count);
}
item.GrabNum = hostelContext.GrabOrders.Where(f => f.POrderId == item.POrderId).Count();
}
var result = new OrderDetailModel {
TotalApply = list.Count, Persons = list
};
return(result);
}
// Thêm chi tiết đơn hàng
public bool InsertDetailOrder(OrderDetailModel detail)
{
string sql = "INSERT INTO chi_tiet_don_hang(ma_don_hang," +
"ma_san_pham," +
"so_luong_ban," +
"don_gia," +
"thanh_tien)" +
"VALUES(@orderid,@productid,@amount,@price,@total)";
var command = new MySqlCommand(sql, MySqlDatabase.Connection);
command.CommandText = sql;
command.Parameters.AddWithValue("orderid", detail.order_id);
command.Parameters.AddWithValue("productid", detail.product_id);
command.Parameters.AddWithValue("amount", detail.count);
command.Parameters.AddWithValue("price", detail.price);
command.Parameters.AddWithValue("total", detail.total);
var reader = command.ExecuteNonQuery();
if (reader > 0)
{
return(true);
}
else
{
return(false);
}
}
public override bool UpdateOrderDetail(OrderDetailModel model)
{
using (SqlConnection cn = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("proc_UPDATE_ORDERDETAIL", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ID", SqlDbType.Int).Value = model.Id;
cmd.Parameters.Add("@ID_RECIPE", SqlDbType.Int).Value = model.IdRecipe;
cmd.Parameters.Add("@STATUS", SqlDbType.Int).Value = model.Status;
cn.Open();
int re = ExecuteNonQuery(cmd);
return (re == 1);
}
}
public override OrderDetailModel GetByIdOrderDetail(int id)
{
using (SqlConnection cn = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("proc_GET_ORDERDETAIL_BY_ID", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ID", SqlDbType.Int).Value = id;
cn.Open();
IDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow);
if (reader.Read())
{
OrderDetailModel model = new OrderDetailModel {
(int)reader["id"],
(int)reader["IdRecipe"],
(int)reader["STATUS"]
};
}
else
return null;
}
}
private void addOrder(OrderDetailModel items,FlowLayoutPanel flp)
{
try
{
UCOrder ucOrder = new UCOrder();
ucOrder.lblNameItem.Text = items.ProductName;
ucOrder.Tag = items;
ucOrder.lblPriceItem.Text = items.Qty.ToString();
ucOrder.Click += ucOrder_Click;
LogPOS.WriteLog("addOrder::::::::::Item::::::" + items.ProductName + ":::::" + items.Price);
ucOrder.Width = flp.Width;
flp.Controls.Add(ucOrder);
}
catch (Exception ex)
{
LogPOS.WriteLog("addOrder:::::::::::::::::::::::::" + ex.Message);
}
}
void btnOpenItemSubItem_Click(object sender, EventArgs e)
{
try
{
frmOpenItem frm = new frmOpenItem(1);
if (frmOpacity.ShowDialog(this, frm) == System.Windows.Forms.DialogResult.OK)
{
//Order.Item itemTemp = new Order.Item();
OrderDetailModel itemTemp = new OrderDetailModel();
OrderOpenItemModel OpenItem = new OrderOpenItemModel();
OpenItem.ItemNameDesc = frm.items.ProductName;
OpenItem.ItemNameShort = frm.items.ProductName;
OpenItem.UnitPrice = Convert.ToInt32(frm.items.Price);
int resul = OrderService.InsertOpenItem(OpenItem);
if (resul == 1)
{
frm.items.DynID = OrderService.LastDynID();
frm.items.OrderID = OrderMain.OrderID;
frm.items.Qty = 1;
if (seat > 0)
frm.items.Seat = seat;
if (flagUcSeatClick == 1)
frm.items.Seat = numSeat;
itemTemp = frm.items;
OrderDetailModifireModel modifierTemp = new OrderDetailModifireModel();
modifierTemp.ModifireName = itemTemp.ProductName;
modifierTemp.Price = itemTemp.Price;
modifierTemp.OrderID = itemTemp.OrderID;
modifierTemp.ProductID = itemTemp.ProductID;
modifierTemp.DynID = itemTemp.DynID;
modifierTemp.Seat = itemTemp.Seat;
modifierTemp.ChangeStatus = 1;
OrderMain.addModifierToList(modifierTemp, keyItemTemp);
UCItemModifierOfMenu ucItemModifierOfMenu = new UCItemModifierOfMenu();
this.addModifreToOrder(ucItemModifierOfMenu, modifierTemp);
}
//Order.Modifier modifierTemp = new Order.Modifier();
}
}
catch (Exception ex)
{
LogPOS.WriteLog("btnOpenItemSubItem_Click::::::::::::::::::::::::::" + ex.Message);
}
}
void ucMenuOfGroup_Click(object sender, EventArgs e)
{
try
{
if (OrderMain.Status == 1)
{
OrderCompleted();
}
else
{
ucMenuOfGroup = (UCMenuOfGroup)sender;
OrderDetailModel item = new OrderDetailModel();
if (seat > 0)
item.Seat = seat;
ProductionModel itemProduct = (ProductionModel)ucMenuOfGroup.Tag;
colorName = itemProduct.Color;
item.ProductName = itemProduct.ProductNameSort;
item.Price = Convert.ToDouble(itemProduct.CurrentPrice);
item.ProductID = itemProduct.ProductID;
item.Qty = 1;
item.OrderID = OrderMain.OrderID;
if (flagUcSeatClick == 1)
item.Seat = numSeat;
if (OrderMain.IsLoadFromData)
item.ChangeStatus = 1;
//ProductionModel itemPrint = new ProductionModel();
//itemPrint = ProductService.GetPrinterType(itemProduct.ProductID);
//if (itemPrint != null)
//{
// item.Printer = itemPrint.Printer;
// item.PrintJob = itemPrint.PrinterJob;
//}
//else
//{
// itemPrint = ProductService.GetPrinterTypeByCate(itemProduct.CategoryID);
// if (itemPrint != null)
// {;
// item.Printer = itemPrint.Printer;
// item.PrintJob = itemPrint.PrinterJob;
// }
//}
var dataPrint = ProductService.GetListPrintJob(itemProduct.ProductID);
foreach (PrinteJobDetailModel itemPrint in dataPrint)
{
PrinteJobDetailModel p = new PrinteJobDetailModel();
p.ProductID = itemPrint.ProductID;
p.PrinterID = itemPrint.PrinterID;
item.ListPrintJob.Add(p);
}
OrderMain.addItemToList(item);
addOrder(item);
lblSubtotal.Text = "$" + money.Format2(OrderMain.SubTotal().ToString());
ucMenuOfGroup.lblNameMenuOfGroup.BackColor = Color.FromArgb(0, 122, 204);
timeChangeColor.Enabled = true;
timeChangeColor.Start();
}
}
catch (Exception ex)
{
LogPOS.WriteLog("ucMenuOfGroup_Click:::::::::::::::::::::::::::::" + ex.Message);
}
}
void ucOrder_Click(object sender, EventArgs e)
{
try
{
UCOrder ucOder = (UCOrder)sender;
OrderDetailModel item = (OrderDetailModel)ucOder.Tag;
ItemMain = item;
indexControl = flpOrder.Controls.GetChildIndex(ucOder);
foreach (Control ctr in flpOrder.Controls)
{
if (ctr is UCOrder || ctr is UCItemModifierOfMenu)
{
if (ctr.BackColor == Color.FromArgb(0, 102, 204) || ctr.BackColor == Color.FromArgb(27, 162, 97))
{
ctr.BackColor = Color.FromArgb(215, 214, 216);
ctr.ForeColor = Color.FromArgb(51, 51, 51);
}
}
}
ucOder.BackColor = Color.FromArgb(0, 102, 204);
ucOder.ForeColor = Color.FromArgb(255, 255, 255);
LoadModifrieOfMenu(CurrentPageIndexModi);
}
catch (Exception ex)
{
LogPOS.WriteLog("ucOrder_Click:::::::::::::::::::::::::::" + ex.Message);
}
}
private void addOrder(OrderDetailModel items)
{
try
{
UCOrder ucOrder = new UCOrder();
ucOrder.lblNameItem.Text = items.ProductName;
ucOrder.Tag = items;
ucOrder.lblPriceItem.Text = money.Format2(items.Price.ToString());
ucOrder.Width = flpTKAItem.Width;
LogPOS.WriteLog("addOrder::::::::::Item::::::" + items.ProductName + ":::::" + items.Price);
flpTKAItem.Controls.Add(ucOrder);
}
catch (Exception ex)
{
LogPOS.WriteLog("addOrder:::::::::::::::::::::::::" + ex.Message);
}
}
private void ModifireItemInOrder(OrderDateModel Order, OrderDetailModel Item)
{
for (int i = 0; i < Order.ListOrderDetail.Count; i++)
{
if (Order.ListOrderDetail[i].KeyItem == Item.KeyItem)
{
Order.ListOrderDetail[i].Price = Item.Price;
}
}
}
public void addItemToListAddSeat(OrderDetailModel item)
{
item.Total = item.Price * item.Qty;
ListOrderDetail.Add(item);
}
public frmChangePrice(OrderDetailModel Item)
{
InitializeComponent();
ucKeyPadOrder1.txtResult = txtHiden;
ItemMain = Item;
}
private void addOrder(OrderDetailModel items)
{
try
{
UCOrder ucOrder = new UCOrder();
ucOrder.lblNameItem.Text = items.ProductName;
ucOrder.lblQuanityItem.Text = "1";
ucOrder.Tag = items;
ucOrder.lblPriceItem.Text = money.Format2(items.Price.ToString());
SystemLog. LogPOS.WriteLog("addOrder::::::::::Item::::::" + items.ProductName + ":::::" + items.Price);
ucOrder.Width = flowLayoutPanel1.Width;
flowLayoutPanel1.Controls.Add(ucOrder);
//if (flagUcSeatClick > 0)
//{
// if (indexOfUcSeat == 0)
// flpOrder.Controls.SetChildIndex(ucOrder, 1 + countItemOfSeat);
// else
// flpOrder.Controls.SetChildIndex(ucOrder, indexOfUcSeat + countItemOfSeat);
//}
}
catch (Exception ex)
{
SystemLog.LogPOS.WriteLog("addOrder:::::::::::::::::::::::::" + ex.Message);
}
}
public void addItemToList(OrderDetailModel item)
{
item.KeyItem = ListOrderDetail.Count + 1;
item.Total = item.Price * item.Qty;
ListOrderDetail.Add(item);
}
