public async Task <IActionResult> DeleteStock([FromRoute] int id, [FromRoute] string nmrid) { if (nmrid == null) { return(BadRequest(ModelState)); } if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var nmr = await _context.Nmr.SingleOrDefaultAsync(m => m.Nmrid == nmrid); if (!authorizeAction(nmr)) { return(BadRequest()); } TblStockOtp item = await _context.TblStockOtp.SingleOrDefaultAsync(m => m.SstockotpId == id && m.Nmrid == nmrid); if (item == null) { return(NotFound()); } if (nmr.UserName != User.Identity.Name) { return(Unauthorized()); } nmr.UpdateDate = DateTime.Now; nmr.StatusId = 2; _context.TblStockOtp.Remove(item); await _context.SaveChangesAsync(); return(Ok(item)); }
public IActionResult Create(string nmrid) { if (nmrid == null) { return(NotFound()); } var nmr = _context.Nmr.SingleOrDefault(m => m.Nmrid == nmrid); if (nmr == null) { return(NotFound()); } var user = User.Identity.Name; if (nmr.UserName != user) { return(Unauthorized()); } int[] query = _context.TblOtp.Where(m => m.Nmrid == nmrid).Select(m => m.Otpid).ToArray(); // int[] model = _context.TlkpOtptfu.Where(m => m.Active.Equals(true) && !m.AgeGroup.ToLower().Trim().Replace(" ","").Contains("6month") && !m.AgeGroup.ToLower().Contains("total") && !query.Contains(m.Otptfuid)).Select(m=>m.Otptfuid).ToArray(); int[] model = _context.TlkpOtptfu.Where(m => m.Active.Equals(true) && !m.AgeGroup.ToLower().Contains("total") && !query.Contains(m.Otptfuid)).Select(m => m.Otptfuid).ToArray(); foreach (int id in model) { TblOtp Item = new TblOtp(); Item.Nmrid = nmrid; Item.UserName = user; Item.Otpid = id; _context.TblOtp.Add(Item); } int[] selectedItems = _context.TblStockOtp.Where(m => m.Nmrid == nmrid).Select(m => m.SstockotpId).ToArray(); int[] validItems = _context.TlkpSstock.Where(m => m.Active.Equals(true) && m.OPDSAMZarib > 0 && !selectedItems.Contains(m.SstockId)).Select(m => m.SstockId).ToArray(); foreach (int id in validItems) { TblStockOtp Item = new TblStockOtp(); Item.Nmrid = nmrid; Item.UserName = user; Item.SstockotpId = id; _context.TblStockOtp.Add(Item); } _context.SaveChanges(); return(Ok()); }
public async Task <IActionResult> putStock([FromRoute] int id, [FromRoute] string nmrid, [FromBody] TblStockOtp item) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != item.SstockotpId) { return(BadRequest()); } var nmr = await _context.Nmr.SingleOrDefaultAsync(m => m.Nmrid == nmrid); if (authorizeAction(nmr)) { var stock = await _context.TblStockOtp.Where(m => m.Nmrid == nmrid && m.SstockotpId == id).AsNoTracking().SingleOrDefaultAsync(); if (stock.UserName != item.UserName) { return(BadRequest()); } nmr.UpdateDate = DateTime.Now; nmr.StatusId = 2; item.UserName = nmr.UserName; _context.TblStockOtp.Update(item); try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!StockExists(id, nmrid)) { return(NotFound()); } else { throw; } } return(NoContent()); } return(BadRequest()); }