public OperationResult Insert(EOrderDetailModel model)
{
var entity = new EOrderDetail
{
OrderType = model.OrderType,
OrderID = model.OrderID,
Sn = model.Sn,
Sku = model.Sku,
Skudesc = model.Skudesc,
WareId = model.WareId,
Unit = model.Unit,
UnitCost = model.UnitCost,
UnitPrice = model.UnitPrice,
QtyonSales = model.QtyonSales,
Orderqty = model.Orderqty,
Bkoqty = model.Bkoqty,
Fullqty = model.Fullqty,
Discount = model.Discount,
Tax = model.Tax,
OrderStats = model.OrderStats,
CommText = model.CommText,
FullDate = model.FullDate,
CretDate = model.CretDate,
ModiDate = model.ModiDate,
CretID = model.CretID,
Class1 = model.Class1,
};
EOrderDetailRepository.Insert(entity);
return(new OperationResult(OperationResultType.Success, "Added successfully"));
}
public int InsertEOrderDetail(EOrderDetailModel model)
{
var entity = new EOrderDetail
{
OrderType = model.OrderType,
OrderID = model.OrderID,
Sn = model.Sn,
Sku = model.Sku,
Skudesc = model.Skudesc,
WareId = model.WareId,
Unit = model.Unit,
UnitCost = model.UnitCost,
UnitPrice = model.UnitPrice,
QtyonSales = model.QtyonSales,
Orderqty = model.Orderqty,
Bkoqty = model.Bkoqty,
Fullqty = model.Fullqty,
Discount = model.Discount,
Tax = model.Tax,
OrderStats = model.OrderStats,
CommText = model.CommText,
FullDate = model.FullDate,
CretDate = model.CretDate,
ModiDate = model.ModiDate,
CretID = model.CretID,
Class1 = model.Class1,
};
return(EOrderDetailRepository.Insert(entity));
}
public void UpdateOrderDetailQty(int orderID, string sku, float qty)
{
var model = EOrderDetailList.FirstOrDefault(t => t.OrderID == orderID && t.Sku == sku);
model.Orderqty = qty;
EOrderDetailRepository.Update(model);
}
public OperationResult Delete(int OrderID, string Sku)
{
var model = EOrderDetailList.FirstOrDefault(t => t.OrderID == OrderID && t.Sku == Sku);
EOrderDetailRepository.Delete(model);
return(new OperationResult(OperationResultType.Success, "successfully deleted"));
}
public OperationResult Update(UpdateEOrderDetailModel model)
{
var entity = EOrderDetailList.First(t => t.OrderID == model.OrderID && t.Sku == model.Sku);
entity.OrderType = model.OrderType;
entity.OrderID = model.OrderID;
entity.Sn = model.Sn;
entity.Sku = model.Sku;
entity.Skudesc = model.Skudesc;
entity.WareId = model.WareId;
entity.Unit = model.Unit;
entity.UnitCost = model.UnitCost;
entity.UnitPrice = model.UnitPrice;
entity.QtyonSales = model.QtyonSales;
entity.Orderqty = model.Orderqty;
entity.Bkoqty = model.Bkoqty;
entity.Fullqty = model.Fullqty;
entity.Discount = model.Discount;
entity.Tax = model.Tax;
entity.OrderStats = model.OrderStats;
entity.CommText = model.CommText;
entity.FullDate = model.FullDate;
entity.CretDate = model.CretDate;
entity.ModiDate = model.ModiDate;
entity.CretID = model.CretID;
entity.Class1 = model.Class1;
EOrderDetailRepository.Update(entity);
return(new OperationResult(OperationResultType.Success, "update completed"));
}
public IEnumerable <EOrderDetail_MASTER> QueryEntities(int orderId)
{
return(EOrderDetailRepository.QueryEntities(orderId));
}
public int DeleteOrderDetail(int orderID, string sku)
{
var model = EOrderDetailList.FirstOrDefault(t => t.OrderID == orderID && t.Sku == sku);
return(EOrderDetailRepository.Delete(model));
}
