public JsonResult InsertOrder(eSaleModel.Order orderData) { var orderService = new eSalesService.OrderService(this.GetDBConnectionString()); try { var result = new eSaleModel.Order(); result.CustId = Int32.Parse(orderData.CustName); result.EmpId = Int32.Parse(orderData.EmpName); result.OrderDate = orderData.OrderDate; result.RequiredDate = orderData.RequiredDate; result.ShippedDate = orderData.ShippedDate; result.ShipperId = Int32.Parse(orderData.ShipperName); result.Freight = orderData.Freight; result.ShipCountry = orderData.ShipCountry; result.ShipCity = orderData.ShipCity; result.ShipRegion = orderData.ShipRegion; result.ShipPostalCode = orderData.ShipPostalCode; result.ShipAddress = orderData.ShipAddress; var error = new eSaleModel.ViewModel.ErrorMsg(); error.Orderid = orderService.InsertOrder(result); error.State = true; return(this.Json(error, JsonRequestBehavior.AllowGet)); }catch (Exception e) { var error = new eSaleModel.ViewModel.ErrorMsg(); error.Describe = "尚未填寫完成"; error.State = false; return(this.Json(error, JsonRequestBehavior.AllowGet)); } }
public JsonResult InsertOrderDetail(eSaleModel.ViewModel.ProductDetailWithId data) { var orderService = new eSalesService.OrderService(this.GetDBConnectionString()); eSaleModel.ViewModel.SearchOrderGrid searchOrderGrid = new eSaleModel.ViewModel.SearchOrderGrid(); eSaleModel.Order orderData = new eSaleModel.Order(); try { eSaleModel.OrderDetails orderDetail = new eSaleModel.OrderDetails(); orderDetail.OrderId = data.id; orderDetail.ProductId = Convert.ToInt16(data.items[0].ProductName[0]); orderDetail.UnitPrice = data.items[0].UnitPrice[0]; orderDetail.Qty = data.items[0].Qty[0]; orderService.InsertOrderDetail(orderDetail); if (data.items.Count > 1) { for (int i = 1; i < data.items.Count; i++) { var orderService2 = new eSalesService.OrderService(this.GetDBConnectionString()); eSaleModel.OrderDetails orderDetail2 = new eSaleModel.OrderDetails(); orderDetail2.OrderId = data.id; orderDetail2.ProductId = Convert.ToInt16(data.items[0]._S._arrayOfAllItems[i].ProductName[0]); orderDetail2.UnitPrice = data.items[0]._S._arrayOfAllItems[i].UnitPrice[0]; orderDetail2.Qty = data.items[0]._S._arrayOfAllItems[i].Qty[0]; orderService2.InsertOrderDetail(orderDetail2); } } searchOrderGrid.State = true; searchOrderGrid.Order = orderService.GetOrderById(data.id); return(this.Json(searchOrderGrid)); } catch (Exception e) { var error = new eSaleModel.ViewModel.ErrorMsg(); error.Orderid = data.id; error.State = false; return(this.Json(error)); } }
public JsonResult UpdateOrder(eSaleModel.Order orderData) { var orderService = new eSalesService.OrderService(this.GetDBConnectionString()); try { var result = new eSaleModel.Order(); result.OrderId = orderData.OrderId; result.CustId = Int32.Parse(orderData.CustName); result.EmpId = Int32.Parse(orderData.EmpName); result.OrderDate = orderData.OrderDate; result.RequiredDate = orderData.RequiredDate; result.ShippedDate = orderData.ShippedDate; result.ShipperId = Int32.Parse(orderData.ShipperName); result.Freight = orderData.Freight; result.ShipCountry = orderData.ShipCountry; result.ShipCity = orderData.ShipCity; result.ShipRegion = orderData.ShipRegion; result.ShipPostalCode = orderData.ShipPostalCode; result.ShipAddress = orderData.ShipAddress; result.ShipName = orderData.ShipName; var error = new eSaleModel.ViewModel.ErrorMsg(); error.State = true; error.Orderid = orderService.UpdateOrder(result); //var aa = orderService.UpdateOrder(result); return(this.Json(error, JsonRequestBehavior.AllowGet)); } catch (Exception e) { var error = new eSaleModel.ViewModel.ErrorMsg(); //var msg = Convert.ToString(e); //var start = msg.IndexOf("參數化查詢"); //var end = msg.IndexOf("必須有參數"); //error.Describe = msg.Substring(start+8,end-start-9); error.Describe = "尚未填寫完成"; error.State = false; return(this.Json(error, JsonRequestBehavior.AllowGet)); } }
public JsonResult DeleteOrder(OrderDetailViewModel orderData) { var orderService = new eSalesService.Order2Service(this.GetDBConnectionString()); try { var result = new OrderDetailViewModel(); result.OrderId = orderData.OrderId; var msg = orderService.DeleteOrder(result); return(this.Json(msg, JsonRequestBehavior.AllowGet)); } catch (Exception e) { var error = new eSaleModel.ViewModel.ErrorMsg(); error.Describe = "尚未填寫完成"; error.State = false; return(this.Json(error, JsonRequestBehavior.AllowGet)); } }
public JsonResult UpdateOrder(OrderDetailViewModel orderData) { var orderService = new eSalesService.Order2Service(this.GetDBConnectionString()); try { var result = new OrderDetailViewModel(); result.CustId = Int32.Parse(orderData.CustName); result.EmpId = Int32.Parse(orderData.EmpName); result.OrderDate = orderData.OrderDate; result.RequiredDate = orderData.RequiredDate; result.ShippedDate = orderData.ShippedDate; result.ShipperId = Int32.Parse(orderData.ShipperName); result.OrderId = orderData.OrderId; result.Freight = orderData.Freight == null ? 0 : orderData.Freight; result.ShipCountry = orderData.ShipCountry == null ? string.Empty : orderData.ShipCountry; result.ShipCity = orderData.ShipCity == null ? string.Empty : orderData.ShipCity; result.ShipRegion = orderData.ShipRegion == null ? string.Empty : orderData.ShipRegion; result.ShipPostalCode = orderData.ShipPostalCode == null ? string.Empty : orderData.ShipPostalCode; result.ShipAddress = orderData.ShipAddress == null ? string.Empty : orderData.ShipAddress; result.ShipName = orderData.ShipName == null ? string.Empty : orderData.ShipName; result.Products = orderData.Products; var msg = orderService.UpdateOrder(result); return(this.Json(msg, JsonRequestBehavior.AllowGet)); } catch (Exception e) { var error = new eSaleModel.ViewModel.ErrorMsg(); error.Describe = "尚未填寫完成"; error.State = false; return(this.Json(error, JsonRequestBehavior.AllowGet)); } }