public JsonResult DeleteOrder(eSaleModel.ViewModel.ProductDetailWithId data)
{
var orderService = new eSalesService.OrderService(this.GetDBConnectionString());
try
{
//orderService.InsertOrderDetail(data);
eSaleModel.OrderDetails orderDetail = new eSaleModel.OrderDetails();
//productDetail = data.items[0];
orderDetail.OrderId = data.id;
orderService.DeleteOrderDetail(orderDetail);
orderService.DeleteOrder(orderDetail);
return(this.Json(true));
}
catch (Exception e)
{
var ee = e;
return(this.Json(false));
}
}
public JsonResult UpdateOrderDetail(eSaleModel.ViewModel.ProductDetailWithId data)
{
var orderService = new eSalesService.OrderService(this.GetDBConnectionString());
try
{
//orderService.InsertOrderDetail(data);
eSaleModel.OrderDetails orderDetail = new eSaleModel.OrderDetails();
//productDetail = data.items[0];
orderDetail.OrderId = data.id;
orderService.DeleteOrderDetail(orderDetail);
if (data.items.Count > 0)
{
orderDetail.ProductId = Convert.ToInt16(data.items[0].ProductName[0]);
orderDetail.UnitPrice = (decimal)data.items[0].UnitPrice[0];
orderDetail.Qty = data.items[0].Qty[0];
orderService.InsertOrderDetail(orderDetail);
}
if (data.items.Count > 1)
{
for (int i = data.items[0]._S._arrayOfAllItems.Count - 1; i > (data.items[0]._S._arrayOfAllItems.Count - 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 = Convert.ToInt16(data.items[0]._S._arrayOfAllItems[i].UnitPrice[0]);
orderDetail2.Qty = data.items[0]._S._arrayOfAllItems[i].Qty[0];
orderService2.InsertOrderDetail(orderDetail2);
}
}
return(this.Json(true));
}
catch (Exception e)
{
var ee = e;
return(this.Json(false));
}
}
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));
}
}
/// <summary>
/// 刪除訂單明細
/// </summary>
/// <param name="orderDetail"></param>
public void DeleteOrderDetail(eSaleModel.OrderDetails orderDetail)
{
string sqlD = "DELETE FROM Sales.OrderDetails WHERE OrderId=@OrderId";
using (SqlConnection conn = new SqlConnection(this.DbConn))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sqlD, conn);
cmd.Parameters.Add(new SqlParameter("@OrderId", orderDetail.OrderId));
try
{
var aa = cmd.ExecuteNonQuery();
}
catch (Exception e)
{
var aaa = e;
}
conn.Close();
}
}
public DataTable InsertOrderDetail(eSaleModel.OrderDetails orderDetail)
{
DataTable dt = new DataTable();
string sql = @" Insert INTO Sales.OrderDetails
(
OrderID,ProductID,UnitPrice,Qty,Discount
)
VALUES
(
@OrderID,@ProductID,@UnitPrice,@Qty,@Discount
)
" ;
using (SqlConnection conn = new SqlConnection(this.DbConn))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add(new SqlParameter("@OrderId", orderDetail.OrderId));
cmd.Parameters.Add(new SqlParameter("@ProductID", orderDetail.ProductId));
cmd.Parameters.Add(new SqlParameter("@UnitPrice", orderDetail.UnitPrice));
cmd.Parameters.Add(new SqlParameter("@Qty", orderDetail.Qty));
cmd.Parameters.Add(new SqlParameter("@Discount", orderDetail.Discount == null ? 0 : orderDetail.Discount));
//SqlDataAdapter sqlAdapter = new SqlDataAdapter(cmd);
//sqlAdapter.Fill(dt);
try
{
if (orderDetail.Qty > 0)
{
var aa = cmd.ExecuteNonQuery();
}
}
catch (Exception e)
{
var aaa = e;
}
}
return(dt);
}
/// <summary>
/// 刪除訂單明細
/// </summary>
/// <param name="data">訂單明細</param>
/// <returns></returns>
public void DeleteOrderDetail(eSaleModel.OrderDetails data)
{
eSaleDao.OrderDao orderDao = new eSaleDao.OrderDao(this.DbConn);
orderDao.DeleteOrderDetail(data);
}
/// <summary>
/// 新增訂單明細
/// </summary>
/// <param name="data">訂單明細</param>
/// <returns></returns>
public void InsertOrderDetail(eSaleModel.OrderDetails data)
{
eSaleDao.OrderDao orderDao = new eSaleDao.OrderDao(this.DbConn);
orderDao.InsertOrderDetail(data);
}
