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