public ActionResult GetUpdateDialog(int id)
{
eSalesService.OrderService orderService = new eSalesService.OrderService(this.GetDBConnectionString());
eSalesService.EmpService empService = new eSalesService.EmpService(this.GetDBConnectionString());
eSalesService.CusService cusService = new eSalesService.CusService(this.GetDBConnectionString());
eSalesService.ShipService shipService = new eSalesService.ShipService(this.GetDBConnectionString());
eSaleModel.Order orderData = new eSaleModel.Order();
orderData = orderService.GetOrderById(id);
ViewBag.OrderId = orderData.OrderId;
ViewBag.OrderDate = orderData.OrderDate;
ViewBag.RequiredDate = orderData.RequiredDate;
ViewBag.ShippedDate = orderData.ShippedDate;
ViewBag.Freight = orderData.Freight;
ViewBag.ShipCountry = orderData.ShipCountry;
ViewBag.ShipCity = orderData.ShipCity;
ViewBag.ShipRegion = orderData.ShipRegion;
ViewBag.ShipPostalCode = orderData.ShipPostalCode;
ViewBag.ShipAddress = orderData.ShipAddress;
ViewBag.ShipName = orderData.ShipAddress;
//ViewBag.OrderId = "updateProductGrid" + id;
ViewBag.EmpNameData = new SelectList(empService.GetEmpNameData(), "Value", "Text", orderData.EmpId);
ViewBag.CustNameData = new SelectList(cusService.GetCusNameData(), "Value", "Text", orderData.CustId);
ViewBag.ShipperNameData = new SelectList(shipService.GetShipperNameData(), "Value", "Text", orderData.ShipperId);
return(PartialView());
}
public JsonResult GetOrderById(int id)
{
var result = new eSaleModel.Order();
var orderService = new eSalesService.OrderService(this.GetDBConnectionString());
result = orderService.GetOrderById(id);
return(this.Json(result, 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));
}
}
