public OperationResult Delete(string Id) { var model = PROD_MASTERList.FirstOrDefault(t => t.ID == Id); PROD_MASTERRepository.Delete(model); return(new OperationResult(OperationResultType.Success, "successfully deleted")); }
public void GetSellingPrice(string itemnmbr, string custnmbr, out double sellPrice, out string priceType) { try { PROD_MASTERRepository.GetSellingPrice(itemnmbr, custnmbr, out sellPrice, out priceType); } catch (Exception ex) { sellPrice = 0; priceType = string.Empty; } }
public OperationResult Insert(PROD_MASTERModel model) { var entity = new PROD_MASTER { ID = model.ID, ProductNo = model.ProductNo, ProductName = model.ProductName, Description = model.Description, ProductType = model.ProductType, StndCost = model.StndCost, CurrCost = model.CurrCost, ListPrice = model.ListPrice, SpecialPrice = model.SpecialPrice, ClearPrice = model.ClearPrice, ProdCategoryID = model.ProdCategoryID, CategoryCode = model.CategoryCode, SchdlUOM = model.SchdlUOM, PriceShed = model.PriceShed, BaseUOFM = model.BaseUOFM, AvailableQTY = model.AvailableQTY, ProdGroupID = model.ProdGroupID, ProdSubclassID = model.ProdSubclassID, LeadTime = model.LeadTime, QtySales = model.QtySales, QtyMin = model.QtyMin, QtyMax = model.QtyMax, CustomerID = model.CustomerID, StockType = model.StockType, SalesRepID = model.SalesRepID, PriceBookItem = model.PriceBookItem, PriceLevel = model.PriceLevel, BarCode = model.BarCode, Ranking = model.Ranking, Notes = model.Notes, Substitute1 = model.Substitute1, Substitute2 = model.Substitute2, Qty1 = model.Qty1, Qty3 = model.Qty3, Qty6 = model.Qty6, Qty12 = model.Qty12, Sales1 = model.Sales1, Sales3 = model.Sales3, Sales6 = model.Sales6, Sales12 = model.Sales12, GPD1 = model.GPD1, GPD3 = model.GPD3, GPD6 = model.GPD6, GPD12 = model.GPD12, LastDate = model.LastDate, CreateDate = model.CreateDate, Creator = model.Creator, Modifier = model.Modifier, ModiDate = model.ModiDate, Status = model.Status, P01 = model.P01, P02 = model.P02, P03 = model.P03, P04 = model.P04, P05 = model.P05, P06 = model.P06, P07 = model.P07, P08 = model.P08, P09 = model.P09, P10 = model.P10, IsCommend = model.IsCommend, IsHot = model.IsHot, ExteriorPart = model.ExteriorPart, ExteriorPartPrice = model.ExteriorPartPrice, ViewTimes = model.ViewTimes, SmallPic = model.SmallPic, BigPic = model.BigPic, LocationStocks1 = model.LocationStocks1, LocationStocks2 = model.LocationStocks2, LocationStocks3 = model.LocationStocks3, LocationStocks4 = model.LocationStocks4, LocationStocks5 = model.LocationStocks5, LocationStocks6 = model.LocationStocks6, LocationStocks7 = model.LocationStocks7, LocationStocks8 = model.LocationStocks8, LocationStocks9 = model.LocationStocks9, LocationStocks10 = model.LocationStocks10, LocationStocks11 = model.LocationStocks11, LocationStocks12 = model.LocationStocks12, LocationStocks13 = model.LocationStocks13, LocationStocks14 = model.LocationStocks14, LocationStocks15 = model.LocationStocks15, LocationAllocate1 = model.LocationAllocate1, LocationAllocate2 = model.LocationAllocate2, LocationAllocate3 = model.LocationAllocate3, LocationAllocate4 = model.LocationAllocate4, LocationAllocate5 = model.LocationAllocate5, LocationAllocate6 = model.LocationAllocate6, LocationAllocate7 = model.LocationAllocate7, LocationAllocate8 = model.LocationAllocate8, LocationAllocate9 = model.LocationAllocate9, LocationAllocate10 = model.LocationAllocate10, LocationAllocate11 = model.LocationAllocate11, LocationAllocate12 = model.LocationAllocate12, LocationAllocate13 = model.LocationAllocate13, LocationAllocate14 = model.LocationAllocate14, LocationAllocate15 = model.LocationAllocate15, Introduction = model.Introduction, Brand = model.Brand, Item01 = model.Item01, Item02 = model.Item02, Item03 = model.Item03, Item04 = model.Item04, Item05 = model.Item05, }; PROD_MASTERRepository.Insert(entity); return(new OperationResult(OperationResultType.Success, "Added successfully")); }
public IEnumerable <PROD_MASTER_PAGE> QueryEntities(int count, string strWhere, string strOrder) { return(PROD_MASTERRepository.QueryEntities(count, strWhere, strOrder)); }
public OperationResult Update(UpdatePROD_MASTERModel model) { var entity = PROD_MASTERList.First(t => t.ID == model.ID); entity.ID = model.ID; entity.ProductNo = model.ProductNo; entity.ProductName = model.ProductName; entity.Description = model.Description; entity.ProductType = model.ProductType; entity.StndCost = model.StndCost; entity.CurrCost = model.CurrCost; entity.ListPrice = model.ListPrice; entity.SpecialPrice = model.SpecialPrice; entity.ClearPrice = model.ClearPrice; entity.ProdCategoryID = model.ProdCategoryID; entity.CategoryCode = model.CategoryCode; entity.SchdlUOM = model.SchdlUOM; entity.PriceShed = model.PriceShed; entity.BaseUOFM = model.BaseUOFM; entity.AvailableQTY = model.AvailableQTY; entity.ProdGroupID = model.ProdGroupID; entity.ProdSubclassID = model.ProdSubclassID; entity.LeadTime = model.LeadTime; entity.QtySales = model.QtySales; entity.QtyMin = model.QtyMin; entity.QtyMax = model.QtyMax; entity.CustomerID = model.CustomerID; entity.StockType = model.StockType; entity.SalesRepID = model.SalesRepID; entity.PriceBookItem = model.PriceBookItem; entity.PriceLevel = model.PriceLevel; entity.BarCode = model.BarCode; entity.Ranking = model.Ranking; entity.Notes = model.Notes; entity.Substitute1 = model.Substitute1; entity.Substitute2 = model.Substitute2; entity.Qty1 = model.Qty1; entity.Qty3 = model.Qty3; entity.Qty6 = model.Qty6; entity.Qty12 = model.Qty12; entity.Sales1 = model.Sales1; entity.Sales3 = model.Sales3; entity.Sales6 = model.Sales6; entity.Sales12 = model.Sales12; entity.GPD1 = model.GPD1; entity.GPD3 = model.GPD3; entity.GPD6 = model.GPD6; entity.GPD12 = model.GPD12; entity.LastDate = model.LastDate; entity.CreateDate = model.CreateDate; entity.Creator = model.Creator; entity.Modifier = model.Modifier; entity.ModiDate = model.ModiDate; entity.Status = model.Status; entity.P01 = model.P01; entity.P02 = model.P02; entity.P03 = model.P03; entity.P04 = model.P04; entity.P05 = model.P05; entity.P06 = model.P06; entity.P07 = model.P07; entity.P08 = model.P08; entity.P09 = model.P09; entity.P10 = model.P10; entity.IsCommend = model.IsCommend; entity.IsHot = model.IsHot; entity.ExteriorPart = model.ExteriorPart; entity.ExteriorPartPrice = model.ExteriorPartPrice; entity.ViewTimes = model.ViewTimes; entity.SmallPic = model.SmallPic; entity.BigPic = model.BigPic; entity.LocationStocks1 = model.LocationStocks1; entity.LocationStocks2 = model.LocationStocks2; entity.LocationStocks3 = model.LocationStocks3; entity.LocationStocks4 = model.LocationStocks4; entity.LocationStocks5 = model.LocationStocks5; entity.LocationStocks6 = model.LocationStocks6; entity.LocationStocks7 = model.LocationStocks7; entity.LocationStocks8 = model.LocationStocks8; entity.LocationStocks9 = model.LocationStocks9; entity.LocationStocks10 = model.LocationStocks10; entity.LocationStocks11 = model.LocationStocks11; entity.LocationStocks12 = model.LocationStocks12; entity.LocationStocks13 = model.LocationStocks13; entity.LocationStocks14 = model.LocationStocks14; entity.LocationStocks15 = model.LocationStocks15; entity.LocationAllocate1 = model.LocationAllocate1; entity.LocationAllocate2 = model.LocationAllocate2; entity.LocationAllocate3 = model.LocationAllocate3; entity.LocationAllocate4 = model.LocationAllocate4; entity.LocationAllocate5 = model.LocationAllocate5; entity.LocationAllocate6 = model.LocationAllocate6; entity.LocationAllocate7 = model.LocationAllocate7; entity.LocationAllocate8 = model.LocationAllocate8; entity.LocationAllocate9 = model.LocationAllocate9; entity.LocationAllocate10 = model.LocationAllocate10; entity.LocationAllocate11 = model.LocationAllocate11; entity.LocationAllocate12 = model.LocationAllocate12; entity.LocationAllocate13 = model.LocationAllocate13; entity.LocationAllocate14 = model.LocationAllocate14; entity.LocationAllocate15 = model.LocationAllocate15; entity.Introduction = model.Introduction; entity.Brand = model.Brand; entity.Item01 = model.Item01; entity.Item02 = model.Item02; entity.Item03 = model.Item03; entity.Item04 = model.Item04; entity.Item05 = model.Item05; PROD_MASTERRepository.Update(entity); return(new OperationResult(OperationResultType.Success, "update completed")); }