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();
}
}