public ActionResult EditCourse(Course obj, int id)
{
using (DB49Entities db = new DB49Entities())
{
List <Department> departments = db.Departments.ToList();
ViewBag.DepartmentList = new SelectList(departments, "DepartmentID", "DepartmentName");
List <Session> sessions = db.Sessions.ToList();
ViewBag.SessionList = new SelectList(sessions, "SessionID", "Session1");
Course user = db.Courses.Where(a => a.CourseID == id).FirstOrDefault();
user.CourseName = obj.CourseName;
user.DepartmentID = obj.DepartmentID;
user.SessionID = obj.SessionID;
user.CreditHours = obj.CreditHours;
// k.Complain.StatusID = obj.StatusID;
//db.Comments.Add(k);
db.SaveChanges();
}
return(View(obj));
}
public ActionResult AddFee(Fee obj)
{
try
{
string message;
DB49Entities db = new DB49Entities();
// Student l = new Student();
Fee c = new Fee();
c.Fees = obj.Fees;
c.Semester = obj.Semester;
c.Date = obj.Date;
db.Fees.Add(c);
db.SaveChanges();
// Session[" CourseID"] = c.CourseID.ToString();
message = " Fee Added Successfully.\\nFee Id:" + c.FeeId.ToString();
ViewBag.Message = message;
}
catch (DbEntityValidationException e)
{
Console.WriteLine(e.ToString());
}
return(View(obj));
}
public ActionResult AddScholarship(Scholar obj)
{
try
{
string message;
DB49Entities k = new DB49Entities();
List <Student> students = k.Students.ToList();
ViewBag.StudentList = new SelectList(students, "StudentID", "Name");
List <Scholarshipss> scholarships = k.Scholarshipsses.ToList();
ViewBag.ScholarshipList = new SelectList(scholarships, "ScholarshipID", "Scholarship");
Student s = new Student();
Scholarshipss t = new Scholarshipss();
Scholar d = new Scholar();
d.StudentID = obj.StudentID;
d.ScholarshipID = obj.ScholarshipID;
d.ScholarID = obj.ScholarID;
k.Scholars.Add(d);
k.SaveChanges();
}
catch (DbEntityValidationException e)
{
Console.WriteLine(e.ToString());
}
return(View(obj));
}
public ActionResult CourseRegister(RegisteredCours obj)
{
//
try
{
// string message;
DB49Entities db = new DB49Entities();
List <Course> co = db.Courses.ToList();
ViewBag.courseList = new SelectList(co, "CourseID", "CourseName");
List <Student> students = db.Students.ToList();
ViewBag.StudentList = new SelectList(students, "StudentID", "Name");
List <Sectionss> sections = db.Sectionsses.ToList();
ViewBag.SectionList = new SelectList(sections, "SectionID", "SectionName");
Student s = new Student();
Course t = new Course();
Sectionss d = new Sectionss();
RegisteredCours r = new RegisteredCours();
r.StudentID = obj.StudentID;
r.CourseID = obj.CourseID;
r.SectionID = obj.SectionID;
r.Semester = obj.Semester;
db.RegisteredCourses.Add(r);
db.SaveChanges();
// Student s = new Student();
// var p = db.Employees.Where(d => d.Type == "emp" && d.EmailID == l.Email).ToList();
var p = db.RegisteredCourses.Where(n => n.StudentID == obj.StudentID).ToList();
foreach (var item in p)
{
// var k = db.Students.Select(new Student { EmailId = l.Email }).ToList();
if (item != null)
{
Session["RegisteredCourseID"] = r.RegisteredCourseID.ToString();
Session["Semester"] = r.Semester.ToString();
Session["SectionID"] = r.SectionID.ToString();
Session["CourseID"] = r.CourseID.ToString();
Session["StudentID"] = r.CourseID.ToString();
return(RedirectToAction("ShowRegisteredCourses", "ShowRegisteredCourses"));
// message = " Course Registered Successfully.\\nRegisteredCourse Id:" + r.RegisteredCourseID.ToString();
//ViewBag.Message = message;
}
}
}
catch (DbEntityValidationException e)
{
Console.WriteLine(e.ToString());
}
return(View(obj));
}
public ActionResult Ex()
{
DB49Entities db = new DB49Entities();
var ex = db.Exams.ToList();
return(View(ex));
}
public ActionResult Re()
{
DB49Entities db = new DB49Entities();
var ResultList = db.Results.ToList();
return(View(ResultList));
}
public ActionResult ShowResult()
{
DB49Entities db = new DB49Entities();
List <Result> p = new List <Result>();
Result o = new Result();
p = db.Results.ToList();
return(View(p));
}
public ActionResult ShowFee()
{
DB49Entities db = new DB49Entities();
// List<Fee> p = new List<Fee>();
//Fee o = new Fee();
//p = db.Fees.ToList();
return(View(db.Fees.ToList()));
}
public ActionResult ShowExam()
{
DB49Entities db = new DB49Entities();
List <Exam> p = new List <Exam>();
Exam o = new Exam();
p = db.Exams.ToList();
return(View(p));
}
public ActionResult ShowScholarship()
{
DB49Entities db = new DB49Entities();
List <Scholar> p = new List <Scholar>();
Scholar o = new Scholar();
p = db.Scholars.ToList();
return(View(p));
}
public ActionResult Result(Result obj)
{
try
{
DB49Entities db = new DB49Entities();
Course f = new Course();
int y = f.CourseID;
List <RegisteredCours> q = db.RegisteredCourses.ToList();
ViewBag.r = new SelectList(q, "RegisteredCourseID", "CourseID");
List <Student> b = db.Students.ToList();
ViewBag.u = new SelectList(b, "StudentId", "Name");
Result r = new Result();
r.Grade = obj.Grade;
r.CreditHours = obj.CreditHours;
r.Date = obj.Date;
r.RegisteredCourseID = obj.RegisteredCourseID;
r.StudentID = obj.StudentID;
db.Results.Add(r);
db.SaveChanges();
var m = db.Results.Where(n => n.StudentID == obj.StudentID).ToList();
foreach (var item in m)
{
// var k = db.Students.Select(new Student { EmailId = l.Email }).ToList();
if (item != null)
{
Session["ResultID"] = r.ResultID.ToString();
Session["Grade"] = r.Grade.ToString();
Session["CreditHours"] = r.CreditHours.ToString();
Session["Date"] = r.Date.ToString();
Session["RegisteredCourseID"] = r.RegisteredCourseID.ToString();
Session["StudentID"] = r.StudentID.ToString();
return(RedirectToAction("ShowStuResult", "Student"));
// message = " Course Registered Successfully.\\nRegisteredCourse Id:" + r.RegisteredCourseID.ToString();
//ViewBag.Message = message;
}
}
}
catch (DbEntityValidationException e)
{
Console.WriteLine(e.ToString());
}
return(View(obj));
}
public ActionResult ShowCourses()
{
DB49Entities db = new DB49Entities();
// List<Course> p = new List<Course>();
//Course o = new Course();
//p = db.Courses.ToList();
// return View(p);
return(View(db.Courses.ToList()));
}
public ActionResult Courses()
{
DB49Entities db = new DB49Entities();
List <Department> departments = db.Departments.ToList();
ViewBag.DepartmentList = new SelectList(departments, "DepartmentID", "DepartmentName");
List <Session> sessions = db.Sessions.ToList();
ViewBag.SessionList = new SelectList(sessions, "SessionID", "Session1");
return(View());
}
public ActionResult AddScholarship()
{
DB49Entities k = new DB49Entities();
List <Student> students = k.Students.ToList();
ViewBag.StudentList = new SelectList(students, "StudentID", "Name");
List <Scholarshipss> scholarships = k.Scholarshipsses.ToList();
ViewBag.ScholarshipList = new SelectList(scholarships, "ScholarshipID", "Scholarship");
return(View());
}
public ActionResult Result()
{
DB49Entities db = new DB49Entities();
List <RegisteredCours> q = db.RegisteredCourses.ToList();
ViewBag.r = new SelectList(q, "RegisteredCourseID", "CourseID");
List <Student> b = db.Students.ToList();
ViewBag.u = new SelectList(b, "StudentId", "Name");
return(View());
}
public ActionResult Editemp(int id)
{
using (DB49Entities db = new DB49Entities())
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Login user = db.Logins.Find(id);
if (user == null)
{
return(HttpNotFound());
}
return(View(user));
}
}
public ActionResult CourseRegister()
{
DB49Entities db = new DB49Entities();
List <Course> co = db.Courses.ToList();
ViewBag.courseList = new SelectList(co, "CourseID", "CourseName");
List <Student> students = db.Students.ToList();
ViewBag.StudentList = new SelectList(students, "StudentID", "Name");
List <Sectionss> sections = db.Sectionsses.ToList();
ViewBag.SectionList = new SelectList(sections, "SectionID", "SectionName");
return(View());
}
public ActionResult UpdateFee()
{
DB49Entities k = new DB49Entities();
List <Student> students = k.Students.ToList();
ViewBag.StudentList = new SelectList(students, "StudentID", "Name");
List <Scholarshipss> scholarships = k.Scholarshipsses.ToList();
ViewBag.ScholarshipList = new SelectList(scholarships, "ScholarshipID", "Scholarship");
List <Lookup> lookups = k.Lookups.ToList();
ViewBag.LookupList = new SelectList(lookups, "LookupID", "Name");
return(View());
}
public ActionResult Editemp(Login obj, int id)
{
using (DB49Entities db = new DB49Entities())
{
Login user = db.Logins.Where(a => a.LoginID == id).FirstOrDefault();
user.LoginID = obj.LoginID;
// k.Complain.StatusID = obj.StatusID;
//db.Comments.Add(k);
db.SaveChanges();
}
return(View(obj));
}
public ActionResult Exam(Exam obj)
{
try
{
string message;
DB49Entities r = new DB49Entities();
List <Course> co = r.Courses.ToList();
ViewBag.courseList = new SelectList(co, "CourseID", "CourseName");
List <Session> sessions = r.Sessions.ToList();
ViewBag.SessionList = new SelectList(sessions, "SessionID", "Session1");
List <Department> departments = r.Departments.ToList();
ViewBag.DepartmentList = new SelectList(departments, "DepartmentId", "DepartmentName");
Exam ex = new Exam();
Course c = new Course();
Session n = new Session();
ex.ExamDate = obj.ExamDate;
ex.CourseID = obj.CourseID;
ex.SessionID = obj.SessionID;
ex.DepartmentId = obj.DepartmentId;
r.Exams.Add(ex);
r.SaveChanges();
Session[" ExamID"] = ex.ExamID.ToString();
message = " Course Added Successfully.\\nExam Id:" + ex.ExamID.ToString();
ViewBag.Message = message;
}
catch (DbEntityValidationException e)
{
Console.WriteLine(e.ToString());
}
return(View(obj));
}
public ActionResult ReportFee()
{
DB49Entities db = new DB49Entities();
ReportDocument rd = new ReportDocument();
rd.Load(Path.Combine(Server.MapPath("~/Report"), "CrystalReportFee.rpt"));
rd.SetDataSource(db.Fees.ToList());
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
try
{
Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
return(File(stream, "application/pdf", "Fee_list.pdf"));
}
catch
{
throw;
}
}
public ActionResult EditCourse(int id)
{
using (DB49Entities db = new DB49Entities())
{
List <Department> departments = db.Departments.ToList();
ViewBag.DepartmentList = new SelectList(departments, "DepartmentID", "DepartmentName");
List <Session> sessions = db.Sessions.ToList();
ViewBag.SessionList = new SelectList(sessions, "SessionID", "Session1");
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Course user = db.Courses.Find(id);
if (user == null)
{
return(HttpNotFound());
}
return(View(user));
}
}
public ActionResult Courses(Course obj)
{
try
{
string message;
DB49Entities db = new DB49Entities();
List <Department> departments = db.Departments.ToList();
ViewBag.DepartmentList = new SelectList(departments, "DepartmentID", "DepartmentName");
List <Session> sessions = db.Sessions.ToList();
ViewBag.SessionList = new SelectList(sessions, "SessionID", "Session1");
// Student l = new Student();
Course c = new Course();
Department s = new Department();
Session n = new Session();
//c.StatusID = 1;
// s.Date = DateTime.Now;
db.Sessions.Add(n);
db.Departments.Add(s);
db.SaveChanges();
c.CourseName = obj.CourseName;
c.DepartmentID = obj.DepartmentID;
c.SessionID = obj.SessionID;
c.CreditHours = obj.CreditHours;
c.Semester = obj.Semester;
db.Courses.Add(c);
db.SaveChanges();
Session[" CourseID"] = c.CourseID.ToString();
message = " Course Added Successfully.\\nCourse Id:" + c.CourseID.ToString();
ViewBag.Message = message;
}
catch (DbEntityValidationException e)
{
Console.WriteLine(e.ToString());
}
return(View(obj));
}
public ActionResult markatt(ClassAttendance c)
{
DB49Entities db = new DB49Entities();
List <Department> departments = db.Departments.ToList();
ViewBag.DepartmentList = new SelectList(departments, "DepartmentID", "DepartmentName");
List <Sectionss> sections = db.Sectionsses.ToList();
ViewBag.sectionlist = new SelectList(sections, "SectionID", "SectionName");
List <status> statuses = db.status.ToList();
ViewBag.statuslist = new SelectList(statuses, "ID", "Status1");
List <Student> student = db.Students.ToList();
ViewBag.studnetlist = new SelectList(student, "StudentId", "RegistrationNumber");
List <Course> courses = db.Courses.ToList();
ViewBag.course = new SelectList(courses, "CourseID", "CourseName");
List <Session> sessions = db.Sessions.ToList();
ViewBag.SessionList = new SelectList(sessions, "SessionID", "Session1");
ClassAttendance k = new ClassAttendance();
k.StudentID = c.StudentID;
k.statusid = c.statusid;
k.Department = c.Department;
k.CourseId = c.CourseId;
k.Session = c.Session;
k.SectionID = c.SectionID;
k.Semester = c.Semester;
k.Date = DateTime.Now;
db.ClassAttendances.Add(k);
db.SaveChanges();
return(View());
}
public ActionResult markatt()
{
DB49Entities db = new DB49Entities();
List <Department> departments = db.Departments.ToList();
ViewBag.DepartmentList = new SelectList(departments, "DepartmentID", "DepartmentName");
List <Sectionss> sections = db.Sectionsses.ToList();
ViewBag.sectionlist = new SelectList(sections, "SectionID", "SectionName");
List <status> statuses = db.status.ToList();
ViewBag.statuslist = new SelectList(statuses, "ID", "Status1");
List <Student> student = db.Students.ToList();
ViewBag.studnetlist = new SelectList(student, "StudentId", "RegistrationNumber");
List <Course> courses = db.Courses.ToList();
ViewBag.course = new SelectList(courses, "CourseID", "CourseName");
List <Session> sessions = db.Sessions.ToList();
ViewBag.SessionList = new SelectList(sessions, "SessionID", "Session1");
return(View());
}
public ActionResult ExamReport()
{
DB49Entities db = new DB49Entities();
List <Exam> exam = new List <Exam>();
exam = db.Exams.ToList();
ReportDocument rd = new ReportDocument();
rd.Load(Path.Combine(Server.MapPath("~/Report"), "CrystalReportExam.rpt"));
rd.SetDataSource(exam);
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
return(File(stream, "application/pdf", "ExamList.pdf"));
}
public ActionResult Login(Login l)
{
if (l.Email == "Admin@gmail" && l.Password == "A123")
{
return(RedirectToAction("Result", "Admin"));
}
else
{
using (DB49Entities db = new DB49Entities())
{
var v = db.Logins.Any(x => x.Email == l.Email && x.Password == l.Password); //.ToList();// (from Login in db.Logins where Login.Email == l.Email && Login.Password == l.Password select Login.Type);
// var v = j.FirstOrDefault();
//var v = db.Logins.Where(x => x.Email == l.Email && x.Password == l.Password).FirstOrDefault();
//var v = db.Logins.Any(x => x.Email == l.Email && x.Password == l.Password && x.Type == l.Type);
var k = db.Students.Where(d => d.Type == "stu" && d.EmailId == l.Email).ToList();
if (k != null)
{
foreach (var item in k)
{ // var k = db.Students.Select(new Student { EmailId = l.Email }).ToList();
if (item != null)
{
Session["LoginID"] = item.LoginID.ToString();
Session["Name"] = item.Name.ToString();
Session["StudentID"] = item.StudentId.ToString();
Session["RegistrationNumber"] = item.RegistrationNumber.ToString();
Session["PhoneNumber"] = item.PhoneNumber.ToString();
Session["Session"] = item.SessionId.ToString();
Session["Address"] = item.Address.ToString();
Session["DOB"] = item.DOB.ToString();
Session["Department"] = item.Department.DepartmentID.ToString();
return(RedirectToAction("StudentDetails", "Student"));
}
//else if (item == null)
//{
// return RedirectToAction("Result", "Admin");
//}
}
}
//else
{
var p = db.Employees.Where(d => d.Type == "emp" && d.EmailID == l.Email).ToList();
foreach (var item in p)
{ // var k = db.Students.Select(new Student { EmailId = l.Email }).ToList();
if (item != null)
{
Session["LoginID"] = item.LoginID.ToString();
Session["EmailID"] = item.EmailID.ToString();
Session["EmployeeID"] = item.EmployeeID.ToString();
Session["Designation"] = item.Designation.ToString();
//Session["PhoneNumber"] = k.PhoneNumber.ToString();
//Session["Session"] = k.Session.ToString();
//Session["Address"] = k.Address.ToString();
//Session["DOB"] = k.DOB.ToString();
//Session["Department"] = k.Department.DepartmentID.ToString();
return(RedirectToAction("EmployeDetails", "Employee"));
}
}
// return RedirectToAction("Result", "Admin");
//}
//else
//{
// string message;
// message = ("Invalid Login Attempt");
// ViewBag.Message = message;
//}
}
}
return(View(l));
}
}
public ActionResult AddFee()
{
DB49Entities db = new DB49Entities();
return(View());
}
public ActionResult AdminShowUpFeeChallan()
{
DB49Entities db = new DB49Entities();
return(View(db.Fes.ToList()));
}
public ActionResult UpdateFee(Fe obj)
{
try
{
DB49Entities k = new DB49Entities();
List <Student> students = k.Students.ToList();
ViewBag.StudentList = new SelectList(students, "StudentID", "Name");
List <Scholarshipss> scholarships = k.Scholarshipsses.ToList();
ViewBag.ScholarshipList = new SelectList(scholarships, "ScholarshipID", "Scholarship");
List <Lookup> lookups = k.Lookups.ToList();
ViewBag.LookupList = new SelectList(lookups, "LookupID", "Name");
Student s = new Student();
Scholarshipss t = new Scholarshipss();
Lookup p = new Lookup();
Fe d = new Fe();
d.StudentID = obj.StudentID;
d.ScholarshipID = obj.ScholarshipID;
d.LookupID = obj.LookupID;
d.LookupID = obj.LookupID;
d.NewFee = obj.NewFee;
k.Fes.Add(d);
k.SaveChanges();
var m = k.Fes.Where(n => n.StudentID == obj.StudentID).ToList();
foreach (var item in m)
{
// var k = db.Students.Select(new Student { EmailId = l.Email }).ToList();
if (item != null)
{
Session["FeeID"] = d.FeeID.ToString();
Session["ScholarshipID"] = d.ScholarshipID.ToString();
Session["LookupID"] = d.LookupID.ToString();
Session["NewFee"] = d.NewFee.ToString();
Session["StudentID"] = d.StudentID.ToString();
return(RedirectToAction("UpFeeChallan", "Student"));
// message = " Course Registered Successfully.\\nRegisteredCourse Id:" + r.RegisteredCourseID.ToString();
//ViewBag.Message = message;
}
}
}
catch (DbEntityValidationException e)
{
Console.WriteLine(e.ToString());
}
return(View(obj));
}
