public ActionResult Create(Models.Math math)
{
math.Date = DateTime.Now;
math.Sol = math.a * math.a + " ";
_db.Maths.Add(math);
_db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Add(HttpPostedFileBase file)
{
try
{
if (file.ContentLength > 0)
{
Stream fs = file.InputStream;
ExcelPackage package = new ExcelPackage(fs);
foreach (ExcelWorksheet worksheet in package.Workbook.Worksheets)
{
Class @class = new Models.Class();
for (int i = worksheet.Dimension.Start.Row + 1; i <= worksheet.Dimension.End.Row; i++)
{
@class.CRN = Int32.Parse(worksheet.Cells[i, 1].Value.ToString());
@class.DeptPrefix = worksheet.Cells[i, 2].Value.ToString();
@class.ClassNum = Int32.Parse(worksheet.Cells[i, 3].Value.ToString());
@class.Time = worksheet.Cells[i, 4].Value.ToString();
@class.Days = worksheet.Cells[i, 5].Value.ToString();
@class.Instructor = worksheet.Cells[i, 6].Value.ToString();
db.Classes.Add(@class);
db.SaveChanges();
}
}
return(RedirectToAction("Class"));
}
else
{
ViewBag.Error = "The file you uploaded has no data in it, please upload another one."; //return error message
return(View());
}
}
catch (Exception)
{
ViewBag.Error = "The data you inputted was not added to the database, please try again."; //return error message
return(View());
}
}
public ActionResult Name(PersonWeek pWeek)
{
//Create empty student to be used later.
Student student = null;
//Check if Student is already in DB.
if (db.Students.Find(pWeek.VNum) != null)
{
student = db.Students.Find(pWeek.VNum);
student.FirstName = pWeek.FirstName;
student.LastName = pWeek.LastName;
}
//Create a student.
else
{
//Add the student to the database.
student = new Student {
VNum = pWeek.VNum, FirstName = pWeek.FirstName, LastName = pWeek.LastName
};
db.Students.Add(student);
}
try
{
//Save the changes to the database.
db.SaveChanges();
}
catch (Exception)
{
ViewBag.Error = "There was an error adding you to the database. Please ask a tutor for help.";
return(View(pWeek));
}
//Redirect to the select department method and slowly select the class.
return(RedirectToAction("SelectClass", new { pWeek.Week, pWeek.VNum }));
}
public JsonResult GetTimes(string id, int num, string instructor)
{
if (instructor == "Community College")
{
Class PCC = db.Classes
.Where(c => c.DeptPrefix == id)
.Where(d => d.ClassNum == num)
.Where(n => n.Instructor == "Portland")
.Select(p => p).FirstOrDefault();
Class ChCC = db.Classes
.Where(c => c.DeptPrefix == id)
.Where(d => d.ClassNum == num)
.Where(n => n.Instructor == "Chemeketa")
.Select(p => p).FirstOrDefault();
Class ClCC = db.Classes
.Where(c => c.DeptPrefix == id)
.Where(d => d.ClassNum == num)
.Where(n => n.Instructor == "Clackamas")
.Select(p => p).FirstOrDefault();
Class MHCC = db.Classes
.Where(c => c.DeptPrefix == id)
.Where(d => d.ClassNum == num)
.Where(n => n.Instructor == "Mt. Hood")
.Select(p => p).FirstOrDefault();
Class LBCC = db.Classes
.Where(c => c.DeptPrefix == id)
.Where(d => d.ClassNum == num)
.Where(n => n.Instructor == "Linn-Benton")
.Select(p => p).FirstOrDefault();
if (PCC == null || ChCC == null || ClCC == null || MHCC == null || LBCC == null)
{
if (PCC == null)
{
PCC = new Class {
DeptPrefix = id, ClassNum = num, Instructor = "Portland"
};
db.Classes.Add(PCC);
}
if (ChCC == null)
{
ChCC = new Class {
DeptPrefix = id, ClassNum = num, Instructor = "Chemeketa"
};
db.Classes.Add(ChCC);
}
if (ClCC == null)
{
ClCC = new Class {
DeptPrefix = id, ClassNum = num, Instructor = "Clackamas"
};
db.Classes.Add(ClCC);
}
if (MHCC == null)
{
MHCC = new Class {
DeptPrefix = id, ClassNum = num, Instructor = "Mt. Hood"
};
db.Classes.Add(MHCC);
}
if (LBCC == null)
{
LBCC = new Class {
DeptPrefix = id, ClassNum = num, Instructor = "Linn-Benton"
};
db.Classes.Add(LBCC);
}
try
{
db.SaveChanges();
}
catch (Exception)
{
//There was an error.
}
}
List <Class> CCList = new List <Class>
{
ChCC,
ClCC,
LBCC,
MHCC,
PCC
};
//Convert the list into a Json Object
string resultCC = JsonConvert.SerializeObject(CCList, Formatting.None,
new JsonSerializerSettings()
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
//Return the Json Object
return(Json(resultCC, JsonRequestBehavior.AllowGet));
}
//Find all possible start times
var startTimes = db.Classes
.Where(c => c.DeptPrefix == id)
.Where(d => d.ClassNum == num)
.Where(n => n.Instructor == instructor)
.Select(p => p)
.ToList();
//Remove the classes with "Other" not being null
var remClasses = startTimes
.Where(c => c.Other != null)
.Select(c => c).ToList();
foreach (var remClass in remClasses)
{
startTimes.Remove(remClass);
}
//Convert the list into a Json Object
string result = JsonConvert.SerializeObject(startTimes, Formatting.None,
new JsonSerializerSettings()
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
//Return the Json Object
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult Delete(int id, string h)
{
if (h == "text")
{
int? num = db.Texts.Find(id).TopicId;
Text temp = db.Texts.Find(id);
if (temp != null)
{
db.Texts.Remove(temp);
db.SaveChanges();
}
return(Redirect("/Home/Topic/" + num));
}
if (h == "theor")
{
int? num = db.Theorems.Find(id).TopicId;
Theorem ther = db.Theorems.Find(id);
if (ther != null)
{
db.Theorems.Remove(ther);
db.SaveChanges();
}
return(Redirect("/Home/Topic/" + num));
}
if (h == "axiom")
{
int? num = db.Axioms.Find(id).TopicId;
Axiom ax = db.Axioms.Find(id);
if (ax != null)
{
db.Axioms.Remove(ax);
db.SaveChanges();
}
return(Redirect("/Home/Topic/" + num));
}
if (h == "lemma")
{
int? num = db.Lemmes.Find(id).TopicId;
Lemma lemm = db.Lemmes.Find(id);
if (lemm != null)
{
db.Lemmes.Remove(lemm);
db.SaveChanges();
}
return(Redirect("/Home/Topic/" + num));
}
if (h == "sinc")
{
int? num = db.Professors.Find(id).TopicId;
Professor prof = db.Professors.Find(id);
if (prof != null)
{
db.Professors.Remove(prof);
db.SaveChanges();
}
return(Redirect("/Home/Topic/" + num));
}
if (h == "form")
{
int? num = db.Formuls.Find(id).TopicId;
Formula form = db.Formuls.Find(id);
if (form != null)
{
db.Formuls.Remove(form);
db.SaveChanges();
}
return(Redirect("/Home/Topic/" + num));
}
if (h == "task")
{
int? num = db.Tasks.Find(id).TopicId;
Task task = db.Tasks.Find(id);
if (task != null)
{
db.Tasks.Remove(task);
db.SaveChanges();
}
return(Redirect("/Home/Topic/" + num));
}
return(RedirectToAction("Index"));
}
