public ActionResult DeleteConfirmed(int id)
{
EnglishOneSeven englishOneSeven = db.EnglishOneSevens.Find(id);
db.EnglishOneSevens.Remove(englishOneSeven);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ID,Roll,SBA,Final,Total,GPA,Grade")] EnglishOneSeven englishOneSeven)
{
if (ModelState.IsValid)
{
db.Entry(englishOneSeven).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(englishOneSeven));
}
// GET: EnglishOneSeven/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EnglishOneSeven englishOneSeven = db.EnglishOneSevens.Find(id);
if (englishOneSeven == null)
{
return(HttpNotFound());
}
return(View(englishOneSeven));
}
public ActionResult Create([Bind(Include = "ID,Roll,SBA,Final,Total,GPA,Grade")] EnglishOneSeven englishOneSeven)
{
if (ModelState.IsValid)
{
englishOneSeven.Total = englishOneSeven.SBA + englishOneSeven.Final;
if (englishOneSeven.Total >= 80)
{
englishOneSeven.GPA = 4.00;
}
else if (englishOneSeven.Total >= 75 && englishOneSeven.Total < 80)
{
englishOneSeven.GPA = 3.75;
}
else if (englishOneSeven.Total >= 70 && englishOneSeven.Total < 75)
{
englishOneSeven.GPA = 3.50;
}
else if (englishOneSeven.Total >= 65 && englishOneSeven.Total < 70)
{
englishOneSeven.GPA = 3.25;
}
else if (englishOneSeven.Total >= 60 && englishOneSeven.Total < 65)
{
englishOneSeven.GPA = 3.00;
}
else if (englishOneSeven.Total >= 55 && englishOneSeven.Total < 60)
{
englishOneSeven.GPA = 2.75;
}
else if (englishOneSeven.Total >= 50 && englishOneSeven.Total < 55)
{
englishOneSeven.GPA = 2.50;
}
else if (englishOneSeven.Total >= 45 && englishOneSeven.Total < 50)
{
englishOneSeven.GPA = 2.25;
}
else if (englishOneSeven.Total >= 40 && englishOneSeven.Total < 45)
{
englishOneSeven.GPA = 2.00;
}
else if (englishOneSeven.Total < 40)
{
englishOneSeven.GPA = 0.00;
}
if (englishOneSeven.Total >= 80)
{
englishOneSeven.Grade = "A+";
}
else if (englishOneSeven.Total >= 75 && englishOneSeven.Total < 80)
{
englishOneSeven.Grade = "A";
}
else if (englishOneSeven.Total >= 70 && englishOneSeven.Total < 75)
{
englishOneSeven.Grade = "A-";
}
else if (englishOneSeven.Total >= 65 && englishOneSeven.Total < 70)
{
englishOneSeven.Grade = "B+";
}
else if (englishOneSeven.Total >= 60 && englishOneSeven.Total < 65)
{
englishOneSeven.Grade = "B";
}
else if (englishOneSeven.Total >= 55 && englishOneSeven.Total < 60)
{
englishOneSeven.Grade = "B-";
}
else if (englishOneSeven.Total >= 50 && englishOneSeven.Total < 55)
{
englishOneSeven.Grade = "C+";
}
else if (englishOneSeven.Total >= 45 && englishOneSeven.Total < 50)
{
englishOneSeven.Grade = "C";
}
else if (englishOneSeven.Total >= 40 && englishOneSeven.Total < 45)
{
englishOneSeven.Grade = "D";
}
else if (englishOneSeven.Total < 40)
{
englishOneSeven.Grade = "F";
}
db.EnglishOneSevens.Add(englishOneSeven);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(englishOneSeven));
}