public async Task <IActionResult> putStock([FromRoute] int id, [FromRoute] string nmrid, [FromBody] TblStockIpt item)
{
if (nmrid == null)
{
BadRequest();
}
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != item.SstockId)
{
return(BadRequest());
}
Nmr nmr = await _context.Nmr.SingleOrDefaultAsync(m => m.Nmrid == item.Nmrid);
if (nmr == null)
{
return(NotFound());
}
if (nmr.StatusId == 3 || nmr.HfactiveStatusId != 1)
{
return(BadRequest());
}
if (User.Identity.Name == nmr.UserName)
{
var stock = await _context.TblStockIpt.Where(m => m.Nmrid == nmrid && m.SstockId == id).AsNoTracking().SingleOrDefaultAsync();
if (stock.UserName != item.UserName)
{
return(BadRequest());
}
nmr.StatusId = 2;
nmr.UpdateDate = DateTime.Now;
_context.Entry(item).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!StockExists(id, nmrid))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
else
{
return(Unauthorized());
}
}
public async Task <IActionResult> Put([FromRoute] int id, [FromRoute] string nmrid, [FromBody] TblOtptfu item)
{
if (!TryValidateModel(item))
{
return(BadRequest());
}
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != item.Otptfuid)
{
return(BadRequest());
}
Nmr nmr = await _context.Nmr.SingleOrDefaultAsync(m => m.Nmrid == item.Nmrid);
if (nmr == null)
{
return(NotFound());
}
if (nmr.StatusId == 3 || nmr.HfactiveStatusId != 1)
{
return(BadRequest());
}
if (User.Identity.Name == nmr.UserName)
{
nmr.UpdateDate = DateTime.Now;
nmr.StatusId = 2;
_context.Entry(item).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!Exists(id, nmrid))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
else
{
return(Unauthorized());
}
}
private bool authorizeAction(Nmr nmr)
{
if (nmr == null)
{
return(false);
}
if (nmr.StatusId == 3 || nmr.HfactiveStatusId != 1)
{
return(false);
}
if (nmr.UserName != User.Identity.Name)
{
return(false);
}
return(true);
}
public async Task <IActionResult> DeleteStock([FromRoute] int id, [FromRoute] string nmrid)
{
if (nmrid == null)
{
return(BadRequest());
}
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
TblStockIpt item = await _context.TblStockIpt.SingleOrDefaultAsync(m => m.SstockId == id && m.Nmrid == nmrid);
if (item == null)
{
return(NotFound());
}
Nmr nmr = await _context.Nmr.SingleOrDefaultAsync(m => m.Nmrid == item.Nmrid);
if (nmr == null)
{
return(NotFound());
}
if (nmr.StatusId == 3 || nmr.HfactiveStatusId != 1)
{
return(BadRequest());
}
if (nmr.UserName == User.Identity.Name)
{
nmr.UpdateDate = DateTime.Now;
nmr.StatusId = 2;
_context.TblStockIpt.Remove(item);
await _context.SaveChangesAsync();
return(Ok(item));
}
else
{
return(Unauthorized());
}
}
public async Task <IActionResult> Edit(string id, [Bind("Nmrid,Commen,Month,Year,FacilityId,HfactiveStatusId,Implementer,PreparedBy,isHumanitarian,mYear,mMonth")] Nmr nmr)
{
if (id != nmr.Nmrid)
{
return(BadRequest());
}
var FacType = (from f in _context.FacilityInfo
where f.FacilityId == nmr.FacilityId
select f).FirstOrDefault();
var fac = _context.FacilityInfo.Where(m => m.FacilityId.Equals(nmr.FacilityId)).SingleOrDefault();
if (ModelState.IsValid)
{
var item = await _context.Nmr.Include(m => m.Facility).SingleOrDefaultAsync(m => m.Nmrid == id);
if (item == null)
{
return(NotFound());
}
if (item.StatusId == 3 || item.HfactiveStatusId != 1)
{
return(BadRequest());
}
if (item.UserName != User.Identity.Name)
{
return(BadRequest());
}
try
{
item.UpdateDate = DateTime.Now;
item.Month = nmr.Month;
item.Year = nmr.Year;
item.Commen = nmr.Commen;
item.PreparedBy = nmr.PreparedBy;
item.FacilityId = nmr.FacilityId;
item.HfactiveStatusId = nmr.HfactiveStatusId;
item.isHumanitarian = nmr.isHumanitarian;
item.Implementer = fac.Implementer;
if (nmr.Month < 10)
{
item.mYear = (nmr.Year + 621);
item.mMonth = (nmr.Month + 3);
}
else if (item.Month > 9)
{
item.mYear = (nmr.Year + 622);
item.mMonth = (nmr.Month - 9);
}
item.FacilityType = FacType.FacilityType;
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!NmrExists(nmr.Nmrid))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction("Index"));
}
List <Provinces> Provinces = new List <Provinces>();
Provinces = (from prov in _context.Provinces select prov).ToList();
Provinces.Insert(0, new Provinces {
ProvCode = "0", ProvName = "select"
});
ViewData["ProvList"] = new SelectList(Provinces, "ProvCode", "ProvName");
ViewData["FacilityId"] = new SelectList(_context.FacilityInfo, "FacilityId", "FacilityName");
var implementers = (from imp in _context.Implementers select imp).ToList();
implementers.Insert(0, new Implementers {
ImpAcronym = " ", ImpName = "select"
});
ViewData["HfactiveStatusId"] = new SelectList(_context.LkpHfstatus, "HfactiveStatusId", "HfstatusDescription");
return(View(nmr));
}
public async Task <IActionResult> Create([Bind("Nmrid,Commen,FacilityId,Flanumber,HfactiveStatusId,Month,OpeningDate,PreparedBy,UpdateDate,UserName,Year,isHumanitarian,mYear,mMonth,FacilityType")] Nmr nmr)
{
var FacType = (from f in _context.FacilityInfo
where f.FacilityId == nmr.FacilityId
select f).FirstOrDefault();
var fac = _context.FacilityInfo.Where(m => m.FacilityId.Equals(nmr.FacilityId)).SingleOrDefault();
List <Provinces> provinces = new List <Provinces>();
if (ModelState.IsValid)
{
var user = await _userManager.FindByNameAsync(User.Identity.Name);
nmr.OpeningDate = DateTime.Now;
nmr.Nmrid = String.Format("{0}-{1}-{2}", nmr.FacilityId, nmr.Year, nmr.Month);
nmr.UserName = User.Identity.Name;
nmr.Implementer = fac.Implementer;
nmr.StatusId = 1;
nmr.Tenant = user.TenantId;
if (nmr.Month < 10)
{
nmr.mYear = (nmr.Year + 621);
nmr.mMonth = (nmr.Month + 3);
}
else if (nmr.Month > 9)
{
nmr.mYear = (nmr.Year + 622);
nmr.mMonth = (nmr.Month - 9);
}
nmr.FacilityType = FacType.FacilityType;
_context.Add(nmr);
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateException)
{
ModelState.AddModelError(String.Empty, "Only one report per month is allowed.");
provinces = (from prov in _context.Provinces select prov).ToList();
provinces.Insert(0, new Provinces {
ProvCode = "0", ProvName = "select"
});
ViewData["ProvList"] = new SelectList(provinces, "ProvCode", "ProvName");
ViewData["FacilityId"] = new SelectList(_context.FacilityInfo, "FacilityId", "FacilityName");
ViewData["HfactiveStatusId"] = new SelectList(_context.LkpHfstatus, "HfactiveStatusId", "HfstatusDescription");
return(View(nmr));
}
return(RedirectToAction("questions", new { id = nmr.Nmrid }));
}
provinces = (from prov in _context.Provinces select prov).ToList();
provinces.Insert(0, new Provinces {
ProvCode = "0", ProvName = "select"
});
ViewData["ProvList"] = new SelectList(provinces, "ProvCode", "ProvName");
ViewData["FacilityId"] = new SelectList(_context.FacilityInfo, "FacilityId", "FacilityId", nmr.FacilityId);
var implementers = (from imp in _context.Implementers select imp).ToList();
implementers.Insert(0, new Implementers {
ImpAcronym = " ", ImpName = "select"
});
ViewData["Implementers"] = new SelectList(implementers, "ImpAcronym", "ImpAcronym");
ViewData["HfactiveStatusId"] = new SelectList(_context.LkpHfstatus, "HfactiveStatusId", "HfactiveStatusId", nmr.HfactiveStatusId);
return(View(nmr));
}
