public ActionResult Edit(BEdefaulters bEdefaulters)
{
try
{
if (ModelState.IsValid)
{
db.Entry(bEdefaulters).State = EntityState.Modified;
db.SaveChanges();
var extra = new List <extratotal>();
int semt = Convert.ToInt32(Session["sem"]);
int stdrollnot = Convert.ToInt32(bEdefaulters.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(bEdefaulters));
}
catch
{
return(View());
}
}
public ActionResult DeleteConfirmed(int id)
{
BEdefaulters bEdefaulters = db.BEdefaulters.Find(id);
db.BEdefaulters.Remove(bEdefaulters);
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")] BEdefaulters bEdefaulters)
{
if (ModelState.IsValid)
{
db.BEdefaulters.Add(bEdefaulters);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(bEdefaulters));
}
// GET: BEdefaulters/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BEdefaulters bEdefaulters = db.BEdefaulters.Find(id);
if (bEdefaulters == null)
{
return(HttpNotFound());
}
return(View(bEdefaulters));
}
