public void AssignToGTC(long?supervisorId, List <string> assignedThesisName, List <string> unAssignedThesisName) { using (var db = new TESDataContext()) { var theses = (from t in db.Thesis select t).ToList(); var thesesForGTC = (from gr in db.GTC_Reviews join t in db.Thesis on gr.thesis_id equals t.thesis_id where gr.gtc_id == supervisorId select new { t.thesis_id, t.thesis_status, t.student_id, t.supervisor_id, t.thesis_discription, t.thesis_domain, t.thesis_title }).ToList(); // Remove unassigned foreach (var uatn in unAssignedThesisName) { var log = (from gr in db.GTC_Reviews join t in db.Thesis on gr.thesis_id equals t.thesis_id where gr.gtc_id == supervisorId && t.thesis_title == uatn select gr).FirstOrDefault(); if (log != null) { db.GTC_Reviews.DeleteOnSubmit(log); db.SubmitChanges(); } } // Add assigned foreach (var uatn in assignedThesisName) { var log = (from gr in db.GTC_Reviews join t in db.Thesis on gr.thesis_id equals t.thesis_id where gr.gtc_id == supervisorId && t.thesis_title == uatn select gr).FirstOrDefault(); //if don't exsists add if (log == null) { var l = (from t in db.Thesis where t.thesis_title == uatn select t).FirstOrDefault(); if (l != null) { var val = new GTC_Review { thesis_id = l.thesis_id, gtc_id = Convert.ToInt64(supervisorId), gtc_review1 = "", }; db.GTC_Reviews.InsertOnSubmit(val); db.SubmitChanges(); } } } } }
public bool ForgetPassword_Email(string email) { var user = CheckEmailExists(email); var recovery = GenerateKey(); if (user != null) { // Sending Email _Mail mail = new _Mail(); mail.Reciver = email; mail.Subject = "Password Recovery"; mail.Message = "Use the following link to recover <br/>" + "Link: http://localhost:52189/UpdatePassword/" + recovery; mail.Send(); // Database Entry using (var db = new TESDataContext()) { var log = (from u in db.User_Informations where u.user_id == user.UserId select u).FirstOrDefault(); log.password_recovery = recovery; db.SubmitChanges(); } return(true); } return(false); }
public void Edit() { using (var db = new TESDataContext()) { // Update Thesis var log = (from t in db.Thesis where t.thesis_id == this.ThesisID select t).FirstOrDefault(); log.thesis_title = this.Title; log.thesis_domain = this.Domain; log.thesis_discription = this.Discription; log.thesis_status = this.Status; log.student_id = this.Student.StudentId; log.supervisor_id = this.Supervisor.SupervisorId; // Assign thesis //var AssignStu = (from t in db.Student_Thesis_Supervisors // where t.thesis_id == this.ThesisID // select t).FirstOrDefault(); //AssignStu.thesis_id = this.ThesisID; //AssignStu.supervisor_id = this.Supervisor.SupervisorId; //AssignStu.student_id = this.Student.StudentId; db.SubmitChanges(); } }
public void SetData() { using (var db = new TESDataContext()) { var log = (from ed in db.Event_Dates select ed).FirstOrDefault(); if (log != null) { log.event_date0 = txtEventDate0.Text; //DateTime.Now.ToString("yyyy-MM-dd"); log.event_date1 = txtEventDate1.Text; //DateTime.Now.ToString("yyyy-MM-dd"); log.event_date2 = txtEventDate2.Text; //DateTime.Now.ToString("yyyy-MM-dd"); log.event_date3 = txtEventDate3.Text; //DateTime.Now.ToString("yyyy-MM-dd"); log.event_date4 = txtEventDate4.Text; //DateTime.Now.ToString("yyyy-MM-dd"); log.event_date5 = txtEventDate5.Text; //DateTime.Now.ToString("yyyy-MM-dd"); log.event_date6 = txtEventDate6.Text; //DateTime.Now.ToString("yyyy-MM-dd"); log.event_date7 = txtEventDate7.Text; //DateTime.Now.ToString("yyyy-MM-dd"); log.event_date8 = txtEventDate8.Text; //DateTime.Now.ToString("yyyy-MM-dd"); log.spring_date = txtspringDate.Text; log.fall_date = txtFallDate.Text; log.header_date = txtHeader_Date.Text; } db.SubmitChanges(); } Session.Add("success", true); // Send email var users = user.GetAll(); foreach (var u in users) { mail.Subject = "New Event calender"; mail.Reciver = u.Email; mail.Message = "Please check you event calender"; mail.Send(); } }
public void DontSupervise(long?id) { using (var db = new TESDataContext()) { var log = (from s in db.Student_Supervisors where s.student_id == id select s).FirstOrDefault(); log.supervise = false; db.SubmitChanges(); } }
public void Approve(string status) { using (var db = new TESDataContext()) { var log = (from t in db.Thesis where t.thesis_id == this.ThesisID select t).FirstOrDefault(); log.thesis_status = status; db.SubmitChanges(); } }
public void AddGTCReview(string msg, long?id) { using (var db = new TESDataContext()) { var log = (from gr in db.GTC_Reviews where gr.gtc_id == id select gr).FirstOrDefault(); log.gtc_review1 = msg; db.SubmitChanges(); } }
public void AddReview(string msg) { using (var db = new TESDataContext()) { var log = (from f in db.Thesis_Files where f.file_Id == this.FileID select f).FirstOrDefault(); log.review = msg; db.SubmitChanges(); } }
public void Delete() { using (var db = new TESDataContext()) { var log = (from t in db.Thesis where t.thesis_id == this.ThesisID select t).FirstOrDefault(); db.Thesis.DeleteOnSubmit(log); db.SubmitChanges(); } }
public void Delete(long?id) { using (var db = new TESDataContext()) { var log = (from u in db.User_Informations where u.user_id == id select u).FirstOrDefault(); db.User_Informations.DeleteOnSubmit(log); db.SubmitChanges(); } }
public void ChangePassword() { using (var db = new TESDataContext()) { var log = (from u in db.User_Informations where u.user_id == this.UserId select u).FirstOrDefault(); log.user_password = this.Password; db.SubmitChanges(); } }
// Delete public void DeleteProfile(long?id) { using (var db = new TESDataContext()) { var log = (from s in db.Student_Informations where s.student_id == id select s).FirstOrDefault(); db.Student_Informations.DeleteOnSubmit(log); db.SubmitChanges(); User.Delete(log.user_id); } }
public void AddMeetingMin(string meetingMin) { using (var db = new TESDataContext()) { var log = (from m in db.Meetings where m.meeting_id == this.MeetingId select m).FirstOrDefault(); if (log != null) { log.meeting_min = meetingMin; } db.SubmitChanges(); } }
public void Delete() { using (var db = new TESDataContext()) { var log = (from m in db.Meetings where m.meeting_id == this.MeetingId select m).FirstOrDefault(); if (log != null) { db.Meetings.DeleteOnSubmit(log); } db.SubmitChanges(); } }
// request for meeting public void RequestMeeting(long?stuId, long?supId) { using (var db = new TESDataContext()) { var log = new Meeting() { student_id = stuId, supervisor_id = supId, meeting_time = "", }; db.Meetings.InsertOnSubmit(log); db.SubmitChanges(); } }
public void SelectCoSupervisor(long?id) { using (var db = new TESDataContext()) { var log = (from t in db.Thesis where t.student_id == this.StudentId select t).FirstOrDefault(); if (log != null) { log.cosupervisor_id = id; } db.SubmitChanges(); } }
public void ForgetPassword(string password, string GUID) { using (var db = new TESDataContext()) { var log = (from u in db.User_Informations where u.password_recovery == GUID select u).FirstOrDefault(); if (log != null) { log.user_password = password; log.password_recovery = null; db.SubmitChanges(); } } }
public void EditProfile() { using (var db = new TESDataContext()) { var log = (from s in db.Supervisor_Informations where s.supervisor_id == this.SupervisorId select s).FirstOrDefault(); User.Edit(log.user_id); log.supervisor_gtc_member = this.GTC; log.supervisor_job_title = this.Title; db.SubmitChanges(); } }
// Edit public void EditProfile() { using (var db = new TESDataContext()) { var log = (from s in db.Student_Informations where s.student_id == this.StudentId select s).FirstOrDefault(); User.Edit(log.user_id); log.student_reg_no = this.RegistrationNo; log.student_smester = this.Semester; db.SubmitChanges(); } }
public void UploadThesis() { using (var db = new TESDataContext()) { var log = new Thesis_File { thesis_id = Convert.ToInt64(this.ThesisID), file_path = this.FilePath, file_name = this.FileName }; db.Thesis_Files.InsertOnSubmit(log); db.SubmitChanges(); } }
public void Create() { using (var db = new TESDataContext()) { var log = new Meeting { meeting_min = this.MeetingMin, meeting_time = this.MeetingTime, supervisor_id = this.Supervisor.SupervisorId, student_id = this.Student.StudentId, }; db.Meetings.InsertOnSubmit(log); db.SubmitChanges(); } }
public void Create(DateTime date) { using (var db = new TESDataContext()) { if (date.DayOfWeek.ToString() == "Saturday") { date = date.AddDays(2); } else if (date.DayOfWeek.ToString() == "Sunday") { date = date.AddDays(1); } ///Delete all before records var per = (from p in db.Presentation_Schedules select p).ToList(); db.Presentation_Schedules.DeleteAllOnSubmit(per); //Add new records var theses = (from t in db.Thesis select t).ToList(); if (theses != null) { int count = 0; foreach (var thesis in theses) { var log = new Presentation_Schedule() { thesis_id = thesis.thesis_id, date_time = date.DayOfWeek + " " + date.Day + " " + CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(date.Month), }; if (count == 14) { count = 0; if (date.DayOfWeek.ToString() == "Saturday") { date = date.AddDays(2); } else { date = date.AddDays(1); } } count++; db.Presentation_Schedules.InsertOnSubmit(log); db.SubmitChanges(); } } } }
public void Edit(long?id) { using (var db = new TESDataContext()) { var log = (from u in db.User_Informations where u.user_id == id select u).FirstOrDefault(); log.full_name = this.FullName; log.user_email = this.Email; log.user_contact_no = this.Contact; log.user_gender = this.Gender; log.user_cnic_no = this.CNIC; db.SubmitChanges(); } }
public void Edit() { using (var db = new TESDataContext()) { var log = (from m in db.Meetings where m.meeting_id == this.MeetingId select m).FirstOrDefault(); if (log != null) { log.meeting_min = this.MeetingMin; log.meeting_time = this.MeetingTime; log.student_id = this.Student.StudentId; log.supervisor_id = this.Supervisor.SupervisorId; } db.SubmitChanges(); } }
public void Add() { using (var db = new TESDataContext()) { var log = new Thesi { thesis_title = this.Title, thesis_domain = this.Domain, thesis_discription = this.Discription, thesis_status = this.Status, student_id = null, supervisor_id = this.Supervisor.SupervisorId, }; db.Thesis.InsertOnSubmit(log); db.SubmitChanges(); } }
public void Signup() { var id = User.Signup(); if (id != 0) { using (var db = new TESDataContext()) { var supervisor = new Supervisor_Information { supervisor_gtc_member = this.GTC, supervisor_job_title = this.Title, user_id = id, }; db.Supervisor_Informations.InsertOnSubmit(supervisor); db.SubmitChanges(); } } }
public long?Signup() { using (var db = new TESDataContext()) { var user = new User_Information { full_name = this.FullName, user_name = this.Username, user_email = this.Email, user_password = this.Password, user_contact_no = this.Contact, user_gender = this.Gender, user_cnic_no = this.CNIC }; db.User_Informations.InsertOnSubmit(user); db.SubmitChanges(); return((from u in db.User_Informations where u.user_name == this.Username select u.user_id).FirstOrDefault()); } }
public void Supervise(long?id) { using (var db = new TESDataContext()) { var logs = (from s in db.Student_Supervisors where s.student_id == id select s).ToList(); foreach (var log in logs) { if (log.supervisor_id == this.SupervisorId) { // Assign Supervisor log.supervise = true; } else { // Remove request for all other supervisor log.supervise = false; } } db.SubmitChanges(); } }
// Sign Up public void Signup() { long?id = User.Signup(); if (id != 0) { using (var db = new TESDataContext()) { var student = new Student_Information { student_reg_no = this.RegistrationNo, student_smester = this.Semester, user_id = id, }; db.Student_Informations.InsertOnSubmit(student); db.SubmitChanges(); } } // Create folder for thesis uplaod Directory.CreateDirectory(HttpContext.Current.Server.MapPath("~/_Files/" + id)); }
// Request Supervisor public void SelectSupervisor(string email, long?id) { // Sending Email _Mail mail = new _Mail(); mail.Reciver = email; mail.Subject = "Supervisor Request"; mail.Message = "Will you be my supervisor? <br/>" + this.User.FullName; mail.Send(); // Database Entry using (var db = new TESDataContext()) { var log = new Student_Supervisor { student_id = this.StudentId, supervisor_id = id, supervise = null, }; db.Student_Supervisors.InsertOnSubmit(log); db.SubmitChanges(); } }