public JsonResult GetOrderDetailById(int id)
{
var orderService = new eSalesService.OrderService(this.GetDBConnectionString());
var store = new eSaleModel.Store();
store.identifier = "ProductName";
store.items = orderService.GetOrderDetailById(id);
return(this.Json(store, JsonRequestBehavior.AllowGet));
}
public JsonResult GetProductNameList()
{
var productService = new eSalesService.ProductService(this.GetDBConnectionString());
var store = new eSaleModel.Store();
store.identifier = "id";
store.items = productService.GetProductNameList();
return(this.Json(store, JsonRequestBehavior.AllowGet));
}
public JsonResult GetProductList()
{
var result = new eSaleModel.Product();
var productService = new eSalesService.ProductService(this.GetDBConnectionString());
var store = new eSaleModel.Store();
result.ProductId = 0;
result.ProductName = "%" + null + "%";
result.SupplierId = 0;
result.CategoryId = 0;
return(this.Json(productService.GetProductByCondition(result), JsonRequestBehavior.AllowGet));
}
public JsonResult GetOrder()
{
var result = new eSaleModel.Order();
var orderService = new eSalesService.OrderService(this.GetDBConnectionString());
var store = new eSaleModel.Store();
result.OrderId = 0;
result.CustName = "%" + null + "%";
result.EmpId = 0;
result.ShipperId = 0;
result.OrderDate = null;
result.RequiredDate = null;
result.ShippedDate = null;
store.identifier = "OrderId";
store.items = orderService.GetOrderByCondition(result);
return(this.Json(store, JsonRequestBehavior.AllowGet));
}
public JsonResult GetOrderByCondition(eSaleModel.Order condition)
{
var result = new eSaleModel.Order();
var orderService = new eSalesService.Order2Service(this.GetDBConnectionString());
var store = new eSaleModel.Store();
result.O_OrderId = "%" + Convert.ToString(condition.OrderId) + "%";
result.CustName = "%" + (condition.CustName) + "%";
result.EmpId = condition.EmpName == null ? 0 : Int32.Parse(condition.EmpName);
result.ShipperId = condition.ShipperName == null ? 0 : Int32.Parse(condition.ShipperName);
result.OrderDate = condition.OrderDate;
result.RequiredDate = condition.RequiredDate;
result.ShippedDate = condition.ShippedDate;
var data = orderService.GetOrderByCondition(result);
return(this.Json(data, JsonRequestBehavior.AllowGet));
}
public JsonResult GetInsertRow()
{
List <eSaleModel.Product> item = new List <eSaleModel.Product>();
var productService = new eSalesService.ProductService(this.GetDBConnectionString());
var store = new eSaleModel.Store();
item.Add(new eSaleModel.Product()
{
ProductName = "Product HHYDP",
UnitPrice = (decimal)18.00,
ProductId = 1,
Count = 1,
Sum = 1
});
store.identifier = "ProductId";
store.items = item;
return(this.Json(store, JsonRequestBehavior.AllowGet));
}
