public void CreatePurchaseOrder4Produt(ProductGoodViewModel propurchase) { var storeProcedureName = "[dbo].[Create_Product_PurchaseOrder]"; var Result = _dbContext.Database.SqlQuery <PurchasingInkViewModel>( $"{storeProcedureName} @PurchasingID,@ProductName,@Count,@Price,@eachPrice,@CreatePersonId,@ProcessPersonId,@Status,@CreateDate,@ProcessDate", new SqlParameter("@PurchasingID", ModelItemIsNow(propurchase.PurchasingID)), new SqlParameter("@ProductName", ModelItemIsNow(propurchase.ProductName)), new SqlParameter("@Count", ModelItemIsNow(propurchase.Count)), new SqlParameter("@Price", ModelItemIsNow(propurchase.Price)), new SqlParameter("@eachPrice", ModelItemIsNow(propurchase.eachPrice)), new SqlParameter("@CreatePersonId", ModelItemIsNow(propurchase.CreatePersonId)), new SqlParameter("@ProcessPersonId", ModelItemIsNow(propurchase.ProcessPersonId)), new SqlParameter("@Status", ModelItemIsNow(propurchase.Status)), new SqlParameter("@CreateDate", ModelItemIsNow(propurchase.CreateDate)), new SqlParameter("@ProcessDate", ModelItemIsNow(propurchase.ProcessDate)) ).SingleOrDefault(); }
public List <ProductGoodViewModel> GetPurchaseByName(string ProductName) { var productlist = from u in _db.ProductGoods where (u.ProductName.Contains(ProductName)) select u; var list = new List <ProductGoodViewModel>(); foreach (var item in productlist) { var pro = new ProductGoodViewModel(); pro.ProductId = item.ProductId; pro.ProductName = item.ProductName; pro.eachPrice = item.eachPrice; pro.CreatePersonId = item.CreatePersonId; pro.ProcessPersonId = item.ProcessPersonId; pro.Count = item.Count; pro.Status = item.Status; list.Add(pro); } return(list); }
public List <ProductGoodViewModel> GetPurchaseById(string purchaseid) { var PurchaseList = new List <ProductGoodViewModel>(); var purchaselist = from u in _db.ProductGoods where u.PurchasingID == purchaseid select u; foreach (var item in purchaselist) { ProductGoodViewModel pro = new ProductGoodViewModel(); pro.ProductId = item.ProductId; pro.ProductName = item.ProductName; pro.eachPrice = item.eachPrice; pro.CreatePersonId = item.CreatePersonId; pro.ProcessPersonId = item.ProcessPersonId; pro.Count = item.Count; pro.Status = item.Status; PurchaseList.Add(pro); } return(PurchaseList); }
public async Task <List <ProductGoodViewModel> > GetAllProductPurchase() { var purchaseList = new List <ProductGoodViewModel>(); var purchaselist = new List <ProductGoods>(); purchaselist = await _db.ProductGoods.ToListAsync(); foreach (var item in purchaselist) { ProductGoodViewModel pro = new ProductGoodViewModel(); pro.PurchasingID = item.PurchasingID; pro.ProductId = item.ProductId; pro.ProductName = item.ProductName; pro.Count = item.Count; pro.Status = item.Status; pro.eachPrice = item.eachPrice; pro.CreateDate = item.CreateDate; pro.ProcessDate = item.ProcessDate; pro.ProcessPersonId = item.ProcessPersonId; purchaseList.Add(pro); } return(purchaseList); }
public void CreatePurchaseOrder4Produt(ProductGoodViewModel propurchase) { _productRespository.CreatePurchaseOrder4Produt(propurchase); }