public async Task <IActionResult> Create(StockReceiveMastVM stockReceiveMastVM) { var stockReceiveMast = new StockReceiveMast(); stockReceiveMast.EntryDate = System.DateTime.Now.Date; stockReceiveMast.EntryUserID = 1; if (ModelState.IsValid) { stockReceiveMast.PortfolioAcId = stockReceiveMastVM.PortfolioAcId; stockReceiveMast.ValueDate = stockReceiveMastVM.ValueDate; stockReceiveMast.Remarks = stockReceiveMastVM.Remarks; stockReceiveMast.StockReceiveDetls = stockReceiveMastVM.StockRecieveDetlVM.Select(a => new StockReceiveDetl { StockId = a.StockId, OwnershipDate = a.OwnershipDate, Qty = a.Qty, Rate = a.Rate }).ToList(); _context.Add(stockReceiveMast); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["PortfolioAcId"] = new SelectList(_context.PortfolioAccount, "Id", "AccountName", stockReceiveMast.PortfolioAcId); return(View(stockReceiveMast)); }
public async Task <IActionResult> Edit(int id, StockReceiveMastVM data) { if (id != data.Id) { return(NotFound()); } if (ModelState.IsValid) { StockReceiveMast stockReceiveMast = new StockReceiveMast { Id = data.Id, EntryDate = DateTime.Now, EntryUserID = 1, Remarks = data.Remarks, ValueDate = data.ValueDate, PortfolioAcId = data.PortfolioAcId, StockReceiveDetls = data.StockRecieveDetlVM.Where(a => a.Flag == Flag.New).Select(a => new StockReceiveDetl { Id = a.Id, MastId = a.MastId, OwnershipDate = a.OwnershipDate, Qty = a.Qty, Rate = a.Rate, StockId = a.StockId }).ToList() }; List <StockReceiveDetl> lstStockDetl = data.StockRecieveDetlVM.Where(a => a.Flag == Flag.Deleted).Select(a => new StockReceiveDetl { Id = a.Id, MastId = a.MastId, OwnershipDate = a.OwnershipDate, Qty = a.Qty, Rate = a.Rate, StockId = a.StockId }).ToList(); _context.RemoveRange(lstStockDetl); await _context.SaveChangesAsync(); _context.Update(stockReceiveMast); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } //ViewBag.PortfolioAcId = new SelectList(_context.PortfolioAccount, "Id", "AccountName", stockReceiveMastVM.PortfolioAcId); return(RedirectToAction(nameof(Index))); }
public IActionResult Edit(int id) { StockReceiveMast stockReceiveMast = _connectDb.StockReceiveMasts.Where(a => a.Id == id).Include(a => a.Detail).FirstOrDefault(); StockReceiveMastViewModel stockReceiveMastViewModel = new StockReceiveMastViewModel { Id = stockReceiveMast.Id, EntryDate = stockReceiveMast.EntryDate, PortfolioAcId = stockReceiveMast.PortfolioAcId, PortfolioAccountName = _connectDb.PortfolioAccounts.Where(a => a.Id == stockReceiveMast.PortfolioAcId).Select(b => b.AccountName).FirstOrDefault(), Remarks = stockReceiveMast.Remarks, UserName = stockReceiveMast.EntryUserId.ToString(), ValueDate = stockReceiveMast.ValueDate, Status = "Approved", details = (from c in stockReceiveMast.Detail select new StockReceiveDetlViewModel { OwnerShipDate = c.OwnershipDate, Quantity = c.Quantity, Rate = c.Rate, StockId = c.StockId, Status = Status.Old }).ToList() }; List <Stock> stockItems = new List <Stock>(); stockItems = (from stock in _connectDb.Stocks select new Stock { Id = stock.Id, StockName = stock.StockName }).ToList(); ViewBag.StockList = stockItems; List <PortfolioAccount> portfolioitems = new List <PortfolioAccount>(); portfolioitems = (from portfolio in _connectDb.PortfolioAccounts.Where(a => a.Id == stockReceiveMast.PortfolioAcId) select new PortfolioAccount { Id = portfolio.Id, AccountNumber = portfolio.AccountNumber }).ToList(); ViewBag.PortfolioAccountList = portfolioitems; return(View(stockReceiveMastViewModel)); }
public IActionResult Create(StockReceiveMastViewModel stockReceiveMastViewModel) { if (ModelState.IsValid) { StockReceiveMast mast = new StockReceiveMast { EntryDate = DateTime.Now, EntryUserId = 2, PortfolioAcId = stockReceiveMastViewModel.PortfolioAcId, Remarks = stockReceiveMastViewModel.Remarks, ValueDate = DateTime.Now, Detail = stockReceiveMastViewModel.details.Select(a => new StockReceiveDetl { OwnershipDate = a.OwnerShipDate, Quantity = a.Quantity, Rate = a.Rate, StockId = a.StockId }).ToList() }; _connectDb.Add(mast); _connectDb.SaveChanges(); } return(RedirectToAction("Index")); }