public async Task <IActionResult> PutSubCounty(int id, SubCounty subCounty)
{
if (id != subCounty.SubCountyID)
{
return(BadRequest());
}
_context.Entry(subCounty).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SubCountyExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ActionResult <SubCounty> > PostSubCounty(SubCounty subCounty)
{
_context.SubCounty.Add(subCounty);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetSubCounty", new { id = subCounty.SubCountyID }, subCounty));
}
public static void InsertConstituency()
{
using (NHAMISContext dbcontext = new NHAMISContext())
{
string path = HttpContext.Current.Server.MapPath(@"~/Models/Initialisation/Constituencies.txt");
string[] Constituencies = File.ReadAllLines(path);
foreach (string ConstituencyLine in Constituencies)
{
string constituencyName = ConstituencyLine.Split('=')[0];
string countyName = ConstituencyLine.Split('=')[1];
var CountyId = dbcontext.Counties.Where(n => n.CountyName == countyName).Select(f => f.Id).FirstOrDefault();
County County = dbcontext.Counties.Find(CountyId);
SubCounty Constituency = new SubCounty()
{
SubCountyName = constituencyName, County = County
};
dbcontext.SubCounties.Add(Constituency);
}
dbcontext.SaveChanges();
}
}
public static void InsertWard()
{
using (NHAMISContext dbcontext = new NHAMISContext())
{
string path = HttpContext.Current.Server.MapPath(@"~/Models/Initialisation/Wards.txt");
string[] Wards = File.ReadAllLines(path);
foreach (string WardLine in Wards)
{
string wardName = WardLine.Split('=')[0];
string constituencyName = WardLine.Split('=')[1];
var ConstituencyId = dbcontext.SubCounties.Where(n => n.SubCountyName == constituencyName).Select(c => c.Id).FirstOrDefault();
SubCounty Constituency = dbcontext.SubCounties.Find(ConstituencyId);
Ward Ward = new Ward()
{
WardName = wardName, Subcounty = Constituency
};
dbcontext.Wards.Add(Ward);
}
dbcontext.SaveChanges();
}
}
public async Task <IActionResult> Edit(long id, [Bind("SubCountyId,SubCountyCode,SubCountyName,CountyId,CreatedAt")] SubCounty subCounty)
{
if (id != subCounty.SubCountyId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(subCounty);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SubCountyExists(subCounty.SubCountyId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["CountyId"] = new SelectList(_context.Counties, "CountyId", "CountyName", subCounty.CountyId);
return(View(subCounty));
}
public ActionResult DeleteConfirmed(int id)
{
SubCounty subCounty = db.SubCounties.Find(id);
db.SubCounties.Remove(subCounty);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,SubCountyName,SubCountyCode,CountyId,CreateBy,CreateDate,ModifyBy,ModifyDate")] SubCounty subCounty)
{
if (ModelState.IsValid)
{
db.Entry(subCounty).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CountyId = new SelectList(db.Counties, "Id", "CountyName", subCounty.CountyId);
return(View(subCounty));
}
public async Task <IActionResult> Create([Bind("SubCountyId,SubCountyCode,SubCountyName,CountyId,CreatedAt")] SubCounty subCounty)
{
if (ModelState.IsValid)
{
_context.Add(subCounty);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["CountyId"] = new SelectList(_context.Counties, "CountyId", "CountyName", subCounty.CountyId);
return(View(subCounty));
}
// GET: SubCounties/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SubCounty subCounty = db.SubCounties.Find(id);
if (subCounty == null)
{
return(HttpNotFound());
}
return(View(subCounty));
}
// GET: SubCounties/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SubCounty subCounty = db.SubCounties.Find(id);
if (subCounty == null)
{
return(HttpNotFound());
}
ViewBag.CountyId = new SelectList(db.Counties, "Id", "CountyName", subCounty.CountyId);
return(View(subCounty));
}
public APIResponse AddSubCounty([FromBody] SubCounty Request)
{
APIResponse Response = new APIResponse();
if (Request == null)
{
Response.StatusCode = "100";
Response.StatusDescription = "BAD REQUEST";
}
else if (string.IsNullOrEmpty(Request.Name) || string.IsNullOrEmpty(Request.Code) || string.IsNullOrEmpty(Request.DistrictID))
{
Response.StatusCode = "101";
Response.StatusDescription = "Missing Request Value";
}
else
{
Response = bll.AddSubCounty(Request);
}
return(Response);
}
