public ActionResult DeleteConfirmed(int id)
{
table_demographic table_demographic = db.table_demographic.Find(id);
db.table_demographic.Remove(table_demographic);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "D_id,Total_person,Male_count,Female_count,caste,religion,senior_id")] table_demographic table_demographic)
{
if (ModelState.IsValid)
{
db.Entry(table_demographic).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.senior_id = new SelectList(db.table_house_senior_details, "senior_id", "Home_no", table_demographic.senior_id);
return(View(table_demographic));
}
// GET: demog/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
table_demographic table_demographic = db.table_demographic.Find(id);
if (table_demographic == null)
{
return(HttpNotFound());
}
return(View(table_demographic));
}
// GET: demog/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
table_demographic table_demographic = db.table_demographic.Find(id);
if (table_demographic == null)
{
return(HttpNotFound());
}
ViewBag.senior_id = new SelectList(db.table_house_senior_details, "senior_id", "Home_no", table_demographic.senior_id);
return(View(table_demographic));
}
public ActionResult Create([Bind(Include = "D_id,Total_person,Male_count,Female_count,caste,religion,senior_id")] table_demographic table_demographic)
{
if (ModelState.IsValid)
{
if (!db.table_demographic.Any(u => u.senior_id == table_demographic.senior_id))
{
db.table_demographic.Add(table_demographic);
db.SaveChanges();
//update status value
var result = db.pdffiles // this explicit query is here
.Where(stats => stats.demo_status == false)
.Take(1);
foreach (var item in result)
{
ViewBag.file = item.File;
pdffile pdff = new pdffile();
using (var con = new woda_testEntities())
{
pdff = con.pdffiles.First(x => x.File == item.File);
pdff.demo_status = true;
con.pdffiles.Attach(pdff);
var entry = con.Entry(pdff);
entry.Property(e => e.demo_status).IsModified = true;
con.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
else
{
ViewBag.error = "This Home Number already added";
}
}
ViewBag.senior_id = new SelectList(db.table_house_senior_details, "senior_id", "Home_no", table_demographic.senior_id);
return(View(table_demographic));
}
