private int Assist(List <Teacher> TeacherNotInSamedept, List <Teacher> TeacherAssignedInTheSameDate, List <Exam> ExaminRoom, Session session, Room room) { foreach (var Teacher in TeacherNotInSamedept.OrderByDescending(t => t.Duties)) { if (Teacher.TeacherRooms.Where(t => t.Session.Id == session.Id).Count() == 0 && Teacher.TeacherRooms.Where(t => t.Room.Id == room.Id).Count() == 0 && Teacher.TeacherPriority == 1) { // if (!(TeacherAssignedInTheSameDate.Contains(Teacher))) // { int Count = Teacher.TeacherRooms.Count(); if (Count < Teacher.Duties) { TeacherRoom Tr1 = new TeacherRoom(); foreach (var exam in ExaminRoom) { Teacher.Exams.Add(exam); } Tr1.Session_Id = session.Id; Tr1.Room_Id = room.Id; Tr1.Teacher_Id = Teacher.Id; Teacher.TeacherRooms.Add(Tr1); db.SaveChanges(); TeacherAssignedInTheSameDate.Add(Teacher); return(0); } // } } } foreach (var Teacher in TeacherNotInSamedept.OrderByDescending(t => t.Duties)) { if (Teacher.TeacherRooms.Where(t => t.Session.Id == session.Id).Count() == 0 && Teacher.TeacherPriority == 1) { // if (!(TeacherAssignedInTheSameDate.Contains(Teacher))) // { int Count = Teacher.TeacherRooms.Count(); if (Count < Teacher.Duties) { TeacherRoom Tr1 = new TeacherRoom(); foreach (var exam in ExaminRoom) { Teacher.Exams.Add(exam); } Tr1.Session_Id = session.Id; Tr1.Room_Id = room.Id; Tr1.Teacher_Id = Teacher.Id; Teacher.TeacherRooms.Add(Tr1); db.SaveChanges(); TeacherAssignedInTheSameDate.Add(Teacher); return(0); } // } } } return(1); }
public ActionResult Create([Bind(Include = "Id,Name,Sem,DepartmentId")] Student student) { if (ModelState.IsValid) { db.Students.Add(student); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.DepartmentId = new SelectList(db.Departments, "Id", "Name", student.DepartmentId); return(View(student)); }
public ActionResult Create([Bind(Include = "Id,Name,Experience,Designation_Id,TeacherPriority,Department_Id")] Teacher teacher) { if (ModelState.IsValid) { db.Teachers.Add(teacher); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Department_Id = new SelectList(db.Departments, "Id", "Name", teacher.Department_Id); ViewBag.Designation_Id = new SelectList(db.Designations, "Id", "Name", teacher.Designation_Id); return(View(teacher)); }
private void UpdateRoomStudents(Session session, Room room, Exam exam1, List <Student> stud1, int capacity) { for (int i = 0; i < capacity; i++) { RoomStudent temp = new RoomStudent { Exam = exam1, Session = session, Student = stud1.First(), Room = room }; room.RoomStudents.Add(temp); if (room.Exams.Contains(exam1) == false) { room.Exams.Add(exam1); } db.SaveChanges(); stud1.Remove(stud1.First()); } }
public ActionResult Create([Bind(Include = "Id,Name")] Stream stream) { try { int id = db.Streams.Max(x => x.Id); stream.Id = id + 1; } catch (InvalidOperationException) { stream.Id = 1; } if (ModelState.IsValid) { db.Streams.Add(stream); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(stream)); }
public ActionResult Create([Bind(Include = "No,Block,Capacity,Department_Id,RoomStatus")] Room room) { try { int id = db.Rooms.Max(x => x.Id); room.Id = id + 1; } catch (InvalidOperationException) { room.Id = 1; } if (ModelState.IsValid) { room.RoomStatus = 1; db.Rooms.Add(room); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Department_Id = new SelectList(db.Departments, "Id", "Name", room.Department_Id); return(View(room)); }
public ActionResult Create([Bind(Include = "Id,Name,StreamId")] Department department) { try { int id = db.Departments.Max(x => x.Id); department.Id = id + 1; } catch (InvalidOperationException) { department.Id = 1; } if (ModelState.IsValid) { db.Departments.Add(department); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.StreamId = new SelectList(db.Streams, "Id", "Name", department.StreamId); return(View(department)); }
public ActionResult Create(string Name) { Session session = new Session(); try { int id = db.Sessions.Max(x => x.Id); session.Id = id + 1; } catch (InvalidOperationException) { session.Id = 0; } session.Name = Name; if (ModelState.IsValid) { db.Sessions.Add(session); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(session)); }
public ActionResult Create([Bind(Include = "Code,ExamTime,Name,Date,Id")] Exam exam) { if (ModelState.IsValid) { string sessionNew = SessionHelper.CreateSession(exam); var session = db.Sessions.Where(s => s.Name == sessionNew).FirstOrDefault <Session>(); if (session == null) { var createSession = new SessionHelper(); createSession.AddSession(sessionNew); var newSession = db.Sessions.Where(s => s.Name == sessionNew).FirstOrDefault <Session>(); exam.SessionId = newSession.Id; } else { exam.SessionId = session.Id; } db.Exams.Add(exam); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Id = new SelectList(db.Departments, "Id", "Name", exam.Id); return(View(exam)); }
public Session AddSession(string Name) { Session session = new Session(); try { int id = db.Sessions.Max(x => x.Id); session.Id = id + 1; } catch (InvalidOperationException) { session.Id = 0; } session.Name = Name; db.Sessions.Add(session); db.SaveChanges(); return(session); }
public JsonResult UploadExcel(Student students, HttpPostedFileBase FileUpload) { List <string> data = new List <string>(); if (FileUpload != null) { // tdata.ExecuteCommand("truncate table OtherCompanyAssets"); if (FileUpload.ContentType == "application/vnd.ms-excel" || FileUpload.ContentType == "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet") { string filename = FileUpload.FileName; string targetpath = Server.MapPath("~/Doc/"); FileUpload.SaveAs(targetpath + filename); string pathToExcelFile = targetpath + filename; var connectionString = ""; if (filename.EndsWith(".xls")) { connectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0; data source={0}; Extended Properties=Excel 8.0;", pathToExcelFile); } else if (filename.EndsWith(".xlsx")) { connectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1\";", pathToExcelFile); } var adapter = new OleDbDataAdapter("SELECT * FROM [Student$]", connectionString); var adapter1 = new OleDbDataAdapter("SELECT * FROM [Room$]", connectionString); var adapter2 = new OleDbDataAdapter("SELECT * FROM [Teacher$]", connectionString); var ds = new DataSet(); var ds1 = new DataSet(); var ds2 = new DataSet(); adapter.Fill(ds, "ExcelTable"); adapter1.Fill(ds1, "ExcelTable"); adapter2.Fill(ds2, "ExcelTable"); DataTable dtable = ds.Tables["ExcelTable"]; DataTable dtable1 = ds1.Tables["ExcelTable"]; DataTable dtable2 = ds2.Tables["ExcelTable"]; string sheetName = "Student"; string sheetName1 = "Room"; string sheetName2 = "Teacher"; var excelFile = new ExcelQueryFactory(pathToExcelFile); var stud = from a in excelFile.Worksheet <Student>(sheetName) select a; foreach (var a in stud) { try { if (a.Name != "" && a.Id != "" && a.Sem != null && a.DepartmentId != null) { Student TU = new Student(); TU.Name = a.Name; TU.Id = a.Id; TU.Sem = a.Sem; TU.DepartmentId = a.DepartmentId; db.Students.Add(TU); db.SaveChanges(); } else { data.Add("<ul>"); if (a.Name == "" || a.Name == null) { data.Add("<li> name is required</li>"); } if (a.Id == "" || a.Id == null) { data.Add("<li> Id is required</li>"); } if (a.Sem == null) { data.Add("<li>Sem is required</li>"); } data.Add("</ul>"); data.ToArray(); return(Json(data, JsonRequestBehavior.AllowGet)); } } catch (DbEntityValidationException ex) { foreach (var entityValidationErrors in ex.EntityValidationErrors) { foreach (var validationError in entityValidationErrors.ValidationErrors) { Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage); } } } } var rooms = from b in excelFile.Worksheet <Room>(sheetName1) select b; foreach (var b in rooms) { try { if (b.No != null && b.Block != "" && b.Department_Id != null && b.Capacity != null) { Room TU = new Room(); TU.Id = b.Id; TU.No = b.No; TU.Department_Id = b.Department_Id; TU.Capacity = b.Capacity; TU.Block = b.Block; TU.RoomStatus = b.RoomStatus; db.Rooms.Add(TU); db.SaveChanges(); } else { data.Add("<ul>"); if (b.No == null) { data.Add("<li> Number is required</li>"); } if (b.Department_Id == null) { data.Add("<li> deptId is required</li>"); } if (b.Capacity == null) { data.Add("<li>capacity is required</li>"); } if (b.Block == "" || b.Block == null) { data.Add("<li>Block is required</li>"); } data.Add("</ul>"); data.ToArray(); return(Json(data, JsonRequestBehavior.AllowGet)); } } catch (DbEntityValidationException ex) { foreach (var entityValidationErrors in ex.EntityValidationErrors) { foreach (var validationError in entityValidationErrors.ValidationErrors) { Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage); } } } } var teachers = from c in excelFile.Worksheet <Teacher>(sheetName2) select c; foreach (var c in teachers) { try { if (c.Id != null && c.Name != "" && c.Duties != null && c.Designation_Id != null) { Teacher TU = new Teacher(); TU.Id = c.Id; TU.Name = c.Name; TU.Department_Id = c.Department_Id; TU.Designation_Id = c.Designation_Id; TU.Duties = c.Duties; TU.TeacherPriority = c.TeacherPriority; db.Teachers.Add(TU); db.SaveChanges(); } else { data.Add("<ul>"); if (c.Id == null) { data.Add("<li> ID is required</li>"); } if (c.Name == null || c.Name == "") { data.Add("<li> name is required</li>"); } if (c.Designation_Id == null) { data.Add("<li>designationid is required</li>"); } if (c.Duties == null) { data.Add("<li>Experience is required</li>"); } data.Add("</ul>"); data.ToArray(); return(Json(data, JsonRequestBehavior.AllowGet)); } } catch (DbEntityValidationException ex) { foreach (var entityValidationErrors in ex.EntityValidationErrors) { foreach (var validationError in entityValidationErrors.ValidationErrors) { Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage); } } } } //deleting excel file from folder if ((System.IO.File.Exists(pathToExcelFile))) { System.IO.File.Delete(pathToExcelFile); } return(Json("success", JsonRequestBehavior.AllowGet)); } else { //alert message for invalid file format data.Add("<ul>"); data.Add("<li>Only Excel file format is allowed</li>"); data.Add("</ul>"); data.ToArray(); return(Json(data, JsonRequestBehavior.AllowGet)); } } else { data.Add("<ul>"); if (FileUpload == null) { data.Add("<li>Please choose Excel file</li>"); } data.Add("</ul>"); data.ToArray(); return(Json(data, JsonRequestBehavior.AllowGet)); } }