public ActionResult StudentTotalMarks()
{
string studentreg = ReportsController.studentreg;
int studentid = 1;
DB37Entities db = new DB37Entities();
if (db.Studentstbls.Any(t => t.RegistrationNumber == studentreg))
{
studentid = db.Studentstbls.Where(t => t.RegistrationNumber == studentreg).FirstOrDefault().Id;
}
else
{
ViewBag.warn = "Invalid Student Registration Number";
return(View("AdminReportsOnly"));
}
//CrMVCApp.Models.Customer c;
var c = db.TotalMarksOfEachStudent(studentid).ToList();
StudentTotalMarks rpt = new StudentTotalMarks();
rpt.Load();
rpt.SetDataSource(c);
Stream s = rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
return(File(s, "application/pdf"));
}
public ActionResult AdminReportsOnly()
{
DB37Entities db = new DB37Entities();
List <string> classlist = new List <string>();
List <string> termList = new List <string>();
foreach (Termstbl ttbl in db.Termstbls)
{
termList.Add(ttbl.Name);
}
ViewBag.Options1 = termList;
string temp;
classlist.Add("All");
foreach (Classtbl c in db.Classtbls)
{
temp = c.Section;
classlist.Add(temp);
}
ViewBag.Options = classlist;
return(View());
}
public ActionResult DisapproveLeaveRequests(int id)
{
try
{
DB37Entities db = new DB37Entities();
foreach (Leavestbl ltbl in db.Leavestbls)
{
if (ltbl.ParentId == id)
{
db.Leavestbls.Remove(ltbl);
break;
}
}
db.SaveChanges();
}
catch (Exception ex)
{
throw (ex);
}
//int pid = db.Leavestbls.Find(id).ParentId;
//SendDisapprovalMail(db.Parentstbls.Find(id).MailAddress);
//db.Leavestbls.Find(id).ApprovalStatusId = db.ApprovalStatustbls.Where(t1 => t1.Name.Equals("approved")).FirstOrDefault().Id;
//int pid = db.Leavestbls.Find(id).ParentId;
//SendApprovalMail(db.Parentstbls.Find(pid).MailAddress);
//db.SaveChanges();
return(RedirectToAction("ViewLeaveRequests", "LeaveRequests"));
}
public ActionResult ClassAttendance()
{
string classname = ReportsController.classname;
int classid = 1;
DB37Entities db = new DB37Entities();
if (classname == "All")
{
ViewBag.warn = "Invalid Student Registration Number";
return(RedirectToAction("AdminReportsOnly"));
}
classid = db.Classtbls.Where(t => t.Section == classname).FirstOrDefault().Id;
//CrMVCApp.Models.Customer c;
var c = db.AttendanceofWholeClass(classid).ToList();
ClassAttendanceReport rpt = new ClassAttendanceReport();
rpt.Load();
rpt.SetDataSource(c);
Stream s = rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
return(File(s, "application/pdf"));
}
public ActionResult AddAttendance()
{
if (HelperClass.account != "Admin")
{
return(RedirectToAction("Index", "Home"));
}
DB37Entities db = new DB37Entities();
List <string> myclasslist = new List <string>();
foreach (Classtbl c in db.Classtbls)
{
myclasslist.Add(c.Section);
}
ViewBag.Options = myclasslist;
List <string> mystatus = new List <string>();
ViewBag.status = mystatus;
List <Attendance> mylist = new List <Attendance>();
mylist.Clear();
ViewBag.myModel = mylist;
return(View(mylist));
}
public ActionResult StudentAllTermMarks()
{
string classname = ReportsController.classname;
if (classname == "All")
{
return(RedirectToAction("AdminReportsOnly", "Reports"));
}
int studentid = 1;
DB37Entities db = new DB37Entities();
studentid = db.Studentstbls.Where(t => t.RegistrationNumber == ReportsController.studentreg).FirstOrDefault().Id;
//CrMVCApp.Models.Customer c;
var c = db.AllTermMarksOfEachStudent(studentid).ToList();
TermWiseMarks rpt = new TermWiseMarks();
rpt.Load();
rpt.SetDataSource(c);
Stream s = rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
return(File(s, "application/pdf"));
}
public ActionResult DetailedClassMarking()
{
string classname = ReportsController.classname;
if (classname == "All")
{
return(RedirectToAction("AdminReportsOnly", "Reports"));
}
int classid = 1;
DB37Entities db = new DB37Entities();
classid = db.Classtbls.Where(t => t.Section == ReportsController.classname).FirstOrDefault().Id;
//CrMVCApp.Models.Customer c;
var c = db.SubjectWiseMarksForClass(classid).ToList();
DetailedClassAssessment rpt = new DetailedClassAssessment();
rpt.Load();
rpt.SetDataSource(c);
Stream s = rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
return(File(s, "application/pdf"));
}
public ActionResult Edit(int id, EventViewModel eventObj)
{
try
{
if (HelperClass.account != "Admin")
{
return(RedirectToAction("Index", "Home"));
}
DB37Entities db = new DB37Entities();
db.SchoolEventstbls.Find(id).Title = eventObj.name;
db.SchoolEventstbls.Find(id).EventDescription = eventObj.description;
db.SchoolEventstbls.Find(id).Contact = eventObj.contact;
db.SchoolEventstbls.Find(id).EventDate = eventObj.date;
db.SchoolEventstbls.Find(id).StartTime = eventObj.startTime;
db.SchoolEventstbls.Find(id).EndTime = eventObj.endTime;
db.SchoolEventstbls.Find(id).Charges = eventObj.charges;
db.SaveChanges();
return(RedirectToAction("Index", "Events"));
}
catch
{
return(View());
}
}
public ActionResult Create(EventViewModel obj)
{
try
{
if (HelperClass.account != "Admin")
{
return(RedirectToAction("Index", "Home"));
}
// TODO: Add insert logic here
DB37Entities db = new DB37Entities();
SchoolEventstbl e1 = new SchoolEventstbl();
e1.Title = obj.name;
e1.EventDescription = obj.description;
e1.EventDate = obj.date;
e1.StartTime = obj.startTime;
e1.EndTime = obj.endTime;
e1.Contact = obj.contact;
e1.Charges = obj.charges;
db.SchoolEventstbls.Add(e1);
db.SaveChanges();
return(RedirectToAction("Index", "Events"));
}
catch (Exception ex)
{
throw (ex);
//return View();
}
}
public ActionResult Create(ClassesViewModels collection)
{
try
{
if (HelperClass.account != "Admin")
{
return(RedirectToAction("Index", "Home"));
}
DB37Entities db = new DB37Entities();
if (db.Classtbls.Any(t => t.Section.Equals(collection.Name)))
{
ViewBag.warn = "Class Already Exist";
return(View());
}
Classtbl c = new Classtbl();
c.Section = collection.Name;
db.Classtbls.Add(c);
db.SaveChanges();
return(RedirectToAction("Index", "Class"));
}
catch
{
return(View());
}
}
public ActionResult Index2()
{
if (HelperClass.account != "Admin")
{
return(RedirectToAction("Index", "Home"));
}
SubjectViewModel.subjectList.Clear();
DB37Entities db = new DB37Entities();
List <string> mylist = new List <string>();
foreach (Classtbl c in db.Classtbls)
{
mylist.Add(c.Section);
}
ViewBag.Options = mylist;
ViewBag.Classname = "";
SubjectViewModel.subjectList.Clear();
foreach (Subjectstbl s in db.Subjectstbls)
{
SubjectViewModel mysubject = new SubjectViewModel();
mysubject.id = s.Id;
mysubject.name = s.Name;
SubjectViewModel.subjectList.Add(mysubject);
}
return(View(SubjectViewModel.subjectList));
}
public ActionResult Index()
{
EventViewModel.EventList.Clear();
DB37Entities db = new DB37Entities();
//List<EventViewModel> eventLst = new List<EventViewModel>();
foreach (SchoolEventstbl e in db.SchoolEventstbls)
{
EventViewModel eventObj = new EventViewModel();
eventObj.name = e.Title;
eventObj.description = e.EventDescription;
eventObj.contact = e.Contact;
eventObj.date = e.EventDate;
eventObj.startTime = e.StartTime;
eventObj.endTime = e.EndTime;
eventObj.charges = e.Charges;
eventObj.id = e.Id;
EventViewModel.EventList.Add(eventObj);
}
return(View(EventViewModel.EventList));
}
public JsonResult UpdateStudents(string classname)
{
DB37Entities db = new DB37Entities();
int classId = db.Classtbls.Where(t => t.Section == classname).FirstOrDefault().Id;
if (!db.StudentClasstbls.Any(t => t.ClassId == classId))
{
List <string> studentListEmpty = new List <string>();
return(Json(studentListEmpty, JsonRequestBehavior.AllowGet));
}
db.Configuration.ProxyCreationEnabled = false;
//List<ClassTbl> ClassList = db.ClassTbls.Where(x => x.School_Id == schoolId).ToList();
List <string> studentList = new List <string>();
foreach (StudentClasstbl c in db.StudentClasstbls)
{
if (c.ClassId == classId)
{
studentList.Add(db.Studentstbls.Where(t => t.Id == c.StudentId).FirstOrDefault().RegistrationNumber);
}
}
return(Json(studentList, JsonRequestBehavior.AllowGet));
}
public ActionResult ClassWiseStudentTotalMarks()
{
string classanme = ReportsController.classname;
DB37Entities db = new DB37Entities();
if (classname == "All")
{
var c2 = db.TotalMarksOfAllClasses().ToList();
TotalMarksOfClass rpt2 = new TotalMarksOfClass();
rpt2.Load();
rpt2.SetDataSource(c2);
Stream s2 = rpt2.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
return(File(s2, "application/pdf"));
}
int classid = 1;
classid = db.Classtbls.Where(t => t.Section == classname).FirstOrDefault().Id;
//CrMVCApp.Models.Customer c;
var c = db.TotalMarksOfEachClass(classid).ToList();
TotalMarksOfClass rpt = new TotalMarksOfClass();
rpt.Load();
rpt.SetDataSource(c);
Stream s = rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
return(File(s, "application/pdf"));
}
public ActionResult ApproveRegistrationRequests(int id, int sid)
{
if (HelperClass.account != "Admin")
{
return(RedirectToAction("Index", "Home"));
}
DB37Entities db = new DB37Entities();
//int sid = db.ParentStudenttbls.Where(t => t.ParentId.Equals(id)).FirstOrDefault().StudentId;
int i = 1;
foreach (Studentstbl stbl in db.Studentstbls)
{
if (stbl.RegistrationNumber == "SSS-" + i.ToString())
{
i++;
}
}
string userName = db.Studentstbls.Find(sid).Username;
db.Parentstbls.Find(id).ApprovalStatusId = 2;
db.Studentstbls.Find(sid).ApprovalStatusId = 2;
db.Studentstbls.Find(sid).RegistrationNumber = "SSS-" + i.ToString();
int check = SendApprovalMail(db.Parentstbls.Find(id).MailAddress, "SSS-" + i.ToString(), userName);
if (check == 0)
{
foreach (ParentStudenttbl pstbl in db.ParentStudenttbls)
{
if (pstbl.ParentId == id)
{
db.ParentStudenttbls.Remove(pstbl);
}
}
foreach (Studentstbl stbl in db.Studentstbls)
{
if (stbl.Id == sid)
{
db.Studentstbls.Remove(stbl);
}
}
foreach (Parentstbl ptbl in db.Parentstbls)
{
if (ptbl.Id == id)
{
db.Parentstbls.Remove(ptbl);
}
}
}
db.SaveChanges();
return(RedirectToAction("ViewRegistrationRequests", "RegistrationRequests"));
}
// GET: Class/Edit/5
public ActionResult Edit(int id)
{
if (HelperClass.account != "Admin")
{
return(RedirectToAction("Index", "Home"));
}
DB37Entities db = new DB37Entities();
return(View(ClassesViewModels.ClassesList.Find(t => t.Id.Equals(id))));
}
// GET: Subject/Delete/5
public ActionResult Delete(int id)
{
if (HelperClass.account != "Admin")
{
return(RedirectToAction("Index", "Home"));
}
DB37Entities db = new DB37Entities();
db.Subjectstbls.Remove(db.Subjectstbls.Where(t => t.Id == id).FirstOrDefault());
db.SaveChanges();
return(RedirectToAction("Index", "Subject"));
}
// GET: Class/Delete/5
public ActionResult Delete(int id)
{
if (HelperClass.account != "Admin")
{
return(RedirectToAction("Index", "Home"));
}
DB37Entities db = new DB37Entities();
db.Classtbls.Remove(db.Classtbls.Find(id));
db.SaveChanges();
return(RedirectToAction("Index", "Class"));
}
// GET: TimeTable/Delete/5
public ActionResult Delete(string classname, string subjectname, string dayname, string time)
{
CultureInfo culture = new CultureInfo("en-US");
DateTime tempDate = Convert.ToDateTime("01/01/0001 " + time, culture);
DB37Entities db = new DB37Entities();
int classid = db.Classtbls.Where(t => t.Section == classname).FirstOrDefault().Id;
int subjectid = db.Subjectstbls.Where(t => t.Name == subjectname).FirstOrDefault().Id;
db.TimeTabletbls.Remove(db.TimeTabletbls.Where(t => t.ClassId == classid && t.SubjectId == subjectid && t.WeeksDay == dayname && t.LectureTime == tempDate.TimeOfDay).FirstOrDefault());
db.SaveChanges();
return(RedirectToAction("Index", "TimeTable"));
}
public ActionResult ApproveLeaveRequests(int id)
{
DB37Entities db = new DB37Entities();
int p = db.ApprovalStatustbls.Where(t1 => t1.Name.Equals("approved")).FirstOrDefault().Id;
db.Leavestbls.Where(t2 => t2.ParentId.Equals(id)).FirstOrDefault().ApprovalStatusId = db.ApprovalStatustbls.Where(t1 => t1.Name.Equals("approved")).FirstOrDefault().Id;
//int pid = db.Leavestbls.Find(id).ParentId;
SendApprovalMail(db.Parentstbls.Find(id).MailAddress);
db.SaveChanges();
return(RedirectToAction("ViewLeaveRequests", "LeaveRequests"));
}
public ActionResult LogIn(LogInViewModels login)
{
DB37Entities db = new DB37Entities();
if (HelperClass.account == "Admin")
{
if (db.Adminstratortbls.Any(t1 => t1.Username.Equals(login.UserName) && db.Adminstratortbls.Any(t2 => t2.AdminPassword.Equals(login.Password))))
{
return(RedirectToAction("Index", "Home"));
}
else
{
HelperClass.account = "";
ViewBag.warn = "Admin with these credentials does not exist";
}
}
else if (HelperClass.account == "Parent")
{
if (db.Parentstbls.Any(t1 => t1.MailAddress.Equals(login.UserName) &&
db.Parentstbls.Where(t4 => t4.MailAddress.Equals(login.UserName)).FirstOrDefault().PrntPassword.Equals(login.Password)) &&
db.Parentstbls.Where(t2 => t2.MailAddress.Equals(login.UserName)).FirstOrDefault().ApprovalStatusId.Equals(db.ApprovalStatustbls.Where(t3 => t3.Name.Equals("approved")).FirstOrDefault().Id))
{
HelperClass.parentid = db.Parentstbls.Where(t => t.MailAddress == login.UserName).First().Id;
HelperClass.accountid = HelperClass.parentid;
return(RedirectToAction("Index", "Home"));
}
else
{
HelperClass.account = "";
ViewBag.warn = "Parent with these credentials does not exist";
}
}
else if (HelperClass.account == "Student")
{
if (db.Studentstbls.Any(t1 => t1.Username.Equals(login.UserName) &&
db.Studentstbls.Where(t4 => t4.Username.Equals(login.UserName)).FirstOrDefault().StdPassword.Equals(login.Password)) &&
db.Studentstbls.Where(t2 => t2.Username.Equals(login.UserName)).FirstOrDefault().ApprovalStatusId.Equals(db.ApprovalStatustbls.Where(t3 => t3.Name.Equals("approved")).FirstOrDefault().Id))
{
HelperClass.accountid = db.Studentstbls.Where(t => t.Username == login.UserName).First().Id;
HelperClass.studentregno = db.Studentstbls.Where(t => t.Id == HelperClass.accountid).FirstOrDefault().RegistrationNumber;
return(RedirectToAction("Index", "Home"));
}
else
{
HelperClass.account = "";
ViewBag.warn = "Student with these credentials does not exist";
}
}
return(View());
}
public ActionResult AllStudents()
{
DB37Entities db = new DB37Entities();
//CrMVCApp.Models.Customer c;
var c = db.School_Students.ToList();
SchoolStudentsReport rpt = new SchoolStudentsReport();
rpt.Load();
rpt.SetDataSource(c);
Stream s = rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
return(File(s, "application/pdf"));
}
public ActionResult StudentRegistration()
{
if (HelperClass.account != "Parent" && ParentRegistrationViewModels.p.Email == null)
{
return(RedirectToAction("Index", "Home"));
}
DB37Entities db = new DB37Entities();
List <string> classes = new List <string>();
foreach (Classtbl c in db.Classtbls)
{
classes.Add(c.Section);
}
ViewBag.Options = classes;
return(View());
}
public ActionResult StudentReports()
{
DB37Entities db = new DB37Entities();
List <string> termList = new List <string>();
foreach (Termstbl ttbl in db.Termstbls)
{
termList.Add(ttbl.Name);
}
ViewBag.Options1 = termList;
return(View());
}
public ActionResult Create(SubjectViewModel sub, FormCollection form)
{
try
{
if (HelperClass.account != "Admin")
{
return(RedirectToAction("Index", "Home"));
}
DB37Entities db = new DB37Entities();
List <string> mylist = new List <string>();
foreach (Classtbl c in db.Classtbls)
{
mylist.Add(c.Section);
}
ViewBag.Options = mylist;
string classname = form["Classlist"].ToString();
int classid = db.Classtbls.Where(t => t.Section.Equals(classname)).FirstOrDefault().Id;
if (db.Subjectstbls.Any(t => t.Name == sub.name) == false)
{
Subjectstbl s = new Subjectstbl();
s.Name = sub.name;
db.Subjectstbls.Add(s);
db.SaveChanges();
}
DB37Entities db2 = new DB37Entities();
int subjectid = db2.Subjectstbls.Where(t => t.Name == sub.name).FirstOrDefault().Id;
if (db2.ClassSubjecttbls.Any(t => t.ClassId == classid && t.SubjectId == subjectid))
{
ViewBag.warn = "Class Already has this Subject";
return(View());
}
ClassSubjecttbl cs = new ClassSubjecttbl();
cs.SubjectId = subjectid;
cs.ClassId = classid;
db2.ClassSubjecttbls.Add(cs);
db2.SaveChanges();
return(RedirectToAction("Index", "Subject"));
}
catch
{
return(View());
}
}
// GET: TimeTable
public ActionResult Index()
{
TimeTableIndexViewModels.indextimetable.Clear();
DB37Entities db = new DB37Entities();
List <string> classlist = new List <string>();
string temp;
foreach (Classtbl c in db.Classtbls)
{
temp = c.Section;
classlist.Add(temp);
}
ViewBag.Options = classlist;
ViewBag.classname = "";
return(View(TimeTableIndexViewModels.indextimetable));
}
// GET: Subject/Create
public ActionResult Create()
{
if (HelperClass.account != "Admin")
{
return(RedirectToAction("Index", "Home"));
}
DB37Entities db = new DB37Entities();
List <string> mylist = new List <string>();
foreach (Classtbl c in db.Classtbls)
{
mylist.Add(c.Section);
}
ViewBag.Options = mylist;
return(View());
}
public ActionResult InactiveStudents(int id)
{
if (HelperClass.account != "Admin")
{
return(RedirectToAction("Index", "Home"));
}
DB37Entities db = new DB37Entities();
int inactivestatusid = db.ActiveStatustbls.Where(t1 => t1.Name == "Inactive").FirstOrDefault().Id;
db.Studentstbls.Where(t => t.Id == id).FirstOrDefault().ActiveStatusId = inactivestatusid;
StudentLefttbl st = new StudentLefttbl();
st.StudentId = id;
st.DateLeft = DateTime.Now.Date;
db.StudentLefttbls.Add(st);
db.SaveChanges();
return(RedirectToAction("ViewActiveStudents", "StudentsLeft"));
}
// GET: Class
public ActionResult Index()
{
if (HelperClass.account != "Admin")
{
return(RedirectToAction("Index", "Home"));
}
ClassesViewModels.ClassesList.Clear();
DB37Entities db = new DB37Entities();
foreach (Classtbl c in db.Classtbls)
{
ClassesViewModels a = new ClassesViewModels();
a.Id = c.Id;
a.Name = c.Section;
ClassesViewModels.ClassesList.Add(a);
}
return(View(ClassesViewModels.ClassesList));
}
public ActionResult ParentRegistration(ParentRegistrationViewModels p)
{
DB37Entities db = new DB37Entities();
if (db.Parentstbls.Any(t1 => t1.MailAddress.Equals(p.Email) || db.Parentstbls.Any(t2 => t2.CNIC.Equals(p.CNIC)) || db.Parentstbls.Any(t3 => t3.PhoneNumber.Equals(p.PhoneNumber))))
{
ViewBag.Warnning = "Parent with these credentials already exist";
return(View());
}
ParentRegistrationViewModels.p.FirstName = p.FirstName;
ParentRegistrationViewModels.p.LastName = p.LastName;
ParentRegistrationViewModels.p.Email = p.Email;
ParentRegistrationViewModels.p.PhoneNumber = p.PhoneNumber;
ParentRegistrationViewModels.p.CNIC = p.CNIC;
ParentRegistrationViewModels.p.PrntPassword = p.PrntPassword;
return(RedirectToAction("StudentRegistration", "Student"));
}
