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