public OperationResult Delete(string CustomerID, string ProductNo, string ShipTo)
{
var model = SALES_ESIORDERFORMList.FirstOrDefault(t => t.CustomerID == CustomerID && t.ProductNo == ProductNo && t.ShipTo == ShipTo);
SALES_ESIORDERFORMRepository.Delete(model);
return(new OperationResult(OperationResultType.Success, "successfully deleted"));
}
public OperationResult Insert(SALES_ESIORDERFORMModel model)
{
var entity = new SALES_ESIORDERFORM
{
CustomerID = model.CustomerID,
ProductNo = model.ProductNo,
ShipTo = model.ShipTo,
Qty0 = model.Qty0,
Qty1 = model.Qty1,
Qty2 = model.Qty2,
Qty3 = model.Qty3,
Qty4 = model.Qty4,
Qty5 = model.Qty5,
Qty6 = model.Qty6,
Qty7 = model.Qty7,
Qty8 = model.Qty8,
Qty9 = model.Qty9,
Qty10 = model.Qty10,
Qty11 = model.Qty11,
Qty12 = model.Qty12,
Qty13 = model.Qty13,
QtyTotal = model.QtyTotal,
Cost0 = model.Cost0,
Cost1 = model.Cost1,
Cost2 = model.Cost2,
Cost3 = model.Cost3,
Cost4 = model.Cost4,
Cost5 = model.Cost5,
Cost6 = model.Cost6,
Cost7 = model.Cost7,
Cost8 = model.Cost8,
Cost9 = model.Cost9,
Cost10 = model.Cost10,
Cost11 = model.Cost11,
Cost12 = model.Cost12,
Cost13 = model.Cost13,
CostTotal = model.CostTotal,
Price0 = model.Price0,
Price1 = model.Price1,
Price2 = model.Price2,
Price3 = model.Price3,
Price4 = model.Price4,
Price5 = model.Price5,
Price6 = model.Price6,
Price7 = model.Price7,
Price8 = model.Price8,
Price9 = model.Price9,
Price10 = model.Price10,
Price11 = model.Price11,
Price12 = model.Price12,
Price13 = model.Price13,
PriceTotal = model.PriceTotal,
ProdCategoryCode = model.ProdCategoryCode,
IDate = model.IDate,
ContactID = model.ContactID,
CurrentPrice = model.CurrentPrice,
PriceType = model.PriceType,
Status = model.Status,
Forecast = model.Forecast,
};
SALES_ESIORDERFORMRepository.Insert(entity);
return(new OperationResult(OperationResultType.Success, "Added successfully"));
}
public IEnumerable <SALES_ESIORDERFORM_MASTER> QueryEntities(int count, string strWhere, string strOrder)
{
return(SALES_ESIORDERFORMRepository.QueryEntities(count, strWhere, strOrder));
}
public IEnumerable <MyFavourite_QTY_MASTER> GetQTY(string customerID, string productNo)
{
return(SALES_ESIORDERFORMRepository.GetQTY(customerID, productNo));
}
public IEnumerable <CustomizedProduct_PAGE_MASTER> GetCustomizedProducts(string strwhere, string custnmbr, string sortModle, int pagesize, int pageIndex, out int totalCount)
{
return(SALES_ESIORDERFORMRepository.GetCustomizedProducts(strwhere, custnmbr, sortModle, pagesize, pageIndex, out totalCount));
}
public List <Location> GetEOFShipToCount(string strWhere)
{
return(SALES_ESIORDERFORMRepository.GetEOFShipToCount(strWhere));
}
public IEnumerable <ESIORDERFORM_PAGE_MASTER> GetByCustIDAndShipto(string customer, string contactID, string shipTo, int curPage, int pageRows, string strWhere, string orderby, out int pageCount)
{
return(SALES_ESIORDERFORMRepository.GetByCustIDAndShipto(customer, contactID, shipTo, curPage, pageRows, strWhere, orderby, out pageCount));
}
public OperationResult Update(UpdateSALES_ESIORDERFORMModel model)
{
var entity = SALES_ESIORDERFORMList.First(t => t.CustomerID == model.CustomerID && t.ProductNo == model.ProductNo && t.ShipTo == model.ShipTo);
entity.CustomerID = model.CustomerID;
entity.ProductNo = model.ProductNo;
entity.ShipTo = model.ShipTo;
entity.Qty0 = model.Qty0;
entity.Qty1 = model.Qty1;
entity.Qty2 = model.Qty2;
entity.Qty3 = model.Qty3;
entity.Qty4 = model.Qty4;
entity.Qty5 = model.Qty5;
entity.Qty6 = model.Qty6;
entity.Qty7 = model.Qty7;
entity.Qty8 = model.Qty8;
entity.Qty9 = model.Qty9;
entity.Qty10 = model.Qty10;
entity.Qty11 = model.Qty11;
entity.Qty12 = model.Qty12;
entity.Qty13 = model.Qty13;
entity.QtyTotal = model.QtyTotal;
entity.Cost0 = model.Cost0;
entity.Cost1 = model.Cost1;
entity.Cost2 = model.Cost2;
entity.Cost3 = model.Cost3;
entity.Cost4 = model.Cost4;
entity.Cost5 = model.Cost5;
entity.Cost6 = model.Cost6;
entity.Cost7 = model.Cost7;
entity.Cost8 = model.Cost8;
entity.Cost9 = model.Cost9;
entity.Cost10 = model.Cost10;
entity.Cost11 = model.Cost11;
entity.Cost12 = model.Cost12;
entity.Cost13 = model.Cost13;
entity.CostTotal = model.CostTotal;
entity.Price0 = model.Price0;
entity.Price1 = model.Price1;
entity.Price2 = model.Price2;
entity.Price3 = model.Price3;
entity.Price4 = model.Price4;
entity.Price5 = model.Price5;
entity.Price6 = model.Price6;
entity.Price7 = model.Price7;
entity.Price8 = model.Price8;
entity.Price9 = model.Price9;
entity.Price10 = model.Price10;
entity.Price11 = model.Price11;
entity.Price12 = model.Price12;
entity.Price13 = model.Price13;
entity.PriceTotal = model.PriceTotal;
entity.ProdCategoryCode = model.ProdCategoryCode;
entity.IDate = model.IDate;
entity.ContactID = model.ContactID;
entity.CurrentPrice = model.CurrentPrice;
entity.PriceType = model.PriceType;
entity.Status = model.Status;
entity.Forecast = model.Forecast;
SALES_ESIORDERFORMRepository.Update(entity);
return(new OperationResult(OperationResultType.Success, "update completed"));
}