public ActionResult Edit(SEdefaulters sEdefaulters)
{
try
{
if (ModelState.IsValid)
{
db.Entry(sEdefaulters).State = EntityState.Modified;
db.SaveChanges();
var extra = new List <extratotal>();
int semt = Convert.ToInt32(Session["sem"]);
int stdrollnot = Convert.ToInt32(sEdefaulters.stdrollno);
using (var adv = new AttendanceContext())
{
var sem = new SqlParameter("@sem", SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Input,
Value = semt
};
var stdrollno = new SqlParameter("@stdrollno", SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Input,
Value = stdrollnot
};
extra = adv.Database.SqlQuery <extratotal>("exec extraattendance @stdrollno, @sem ", stdrollno, sem).ToList();
}
return(RedirectToAction("Index"));
}
return(View(sEdefaulters));
}
catch
{
return(View());
}
}
public ActionResult DeleteConfirmed(int id)
{
SEdefaulters sEdefaulters = db.SEdefaulters.Find(id);
db.SEdefaulters.Remove(sEdefaulters);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "id,stdrollno,stdname,total_theory,theory_percentage,total_practical,practical_percentage,extra_attendance,total_attendance,attendance_percentage")] SEdefaulters sEdefaulters)
{
if (ModelState.IsValid)
{
db.SEdefaulters.Add(sEdefaulters);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sEdefaulters));
}
// GET: SEdefaulters/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SEdefaulters sEdefaulters = db.SEdefaulters.Find(id);
if (sEdefaulters == null)
{
return(HttpNotFound());
}
return(View(sEdefaulters));
}
