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"));
}
