protected void Button1_Click(object sender, EventArgs e)
{
string _recieverEmail = "";
string _senderEmail = "";
string _message = "";
string _subject = "";
string calendarValue = DateTime.Now.ToShortDateString();
if (Calendar1.SelectedDate.ToShortDateString() == "01/01/0001")
{
calendarValue = DateTime.Now.AddDays(1).ToShortDateString();
}
else
{
calendarValue = Calendar1.SelectedDate.ToShortDateString();
}
UserDetails _user = (UserDetails)Session["User"];
UserDetails studentDetails = new UserDetails();
MeetingDetails meetingInfo = new MeetingDetails();
meetingInfo.selectMeetingDetailsByMeetingID();
studentDetails = UserDetails.getUserById(tuteeDdl.SelectedValue);
_recieverEmail = studentDetails.EmailAddress.ToString().Trim();
_senderEmail = _user.EmailAddress.ToString();
_subject = "Meeting Request";
_message = "Hello " + studentDetails.FirstName.ToString().Trim() + " "+ studentDetails.Surname.ToString().Trim() +", ";
_message += Environment.NewLine;
_message += "You have been requested to attend the following meeting at the following location by " + _user.Fullname + ", please respond, thank you.";
_message += "Location: " + Environment.NewLine;
_message += TextBox1.Text + Environment.NewLine;
_message += Environment.NewLine + "Date and Time:";
_message += Environment.NewLine + calendarValue + " " + DropDownList1.SelectedItem + ":" + DropDownList3.SelectedItem;
_message += Environment.NewLine + Environment.NewLine;
_message += "Kind Regards, " + Environment.NewLine + _user.Fullname.ToString();
general_functions.Instance.email(_recieverEmail, _senderEmail, _message, _subject);
DateTime dtt = Convert.ToDateTime((DropDownList1.SelectedItem.ToString() + ":" + DropDownList3.SelectedItem.ToString() +":" + "00").ToString());
TimeSpan TS = new TimeSpan(dtt.Hour, dtt.Minute, dtt.Second);
string selectedTutee = (String) Session["selectedStudent"];
MeetingDetails tutorMeetingDetails = new MeetingDetails(selectedTutee,
_user.UserID,
Convert.ToDateTime(calendarValue),
TS,
DropDownList2.SelectedItem.ToString(),
TextBox1.Text,
"-",
"Accepted");
tutorMeetingDetails.insertToDatabase();
populateDropDownList();
TuteesSelectionPanel.Visible = false;
appointmentPanel.Visible = true;
populateTable();
}
public static List <MeetingDetails> getAllMeetingsByStudentID(string id)
{
try
{
List <MeetingDetails> allMeetings = new List <MeetingDetails>();
string command =
"SELECT MeetingDetails.MeetingID, MeetingDetails.StudentID, { fn CONCAT({ fn CONCAT(UserDetails.Firstname, ', ') }, dbo.UserDetails.Surname) } AS 'Student', " +
"MeetingDetails.TutorID, { fn CONCAT({ fn CONCAT(UserDetails_1.Firstname, ', ') }, UserDetails_1.Surname) } AS Tutor, dbo.MeetingDetails.Date, " +
"MeetingDetails.Time, MeetingDetails.Type, MeetingDetails.Location, MeetingDetails.StudentStatus, MeetingDetails.TutorStatus " +
"FROM MeetingDetails INNER JOIN " +
"UserDetails ON MeetingDetails.StudentID = UserDetails.UserID INNER JOIN " +
"UserDetails AS UserDetails_1 ON MeetingDetails.TutorID = UserDetails_1.UserID " +
"WHERE MeetingDetails.StudentID='" + id + "' ORDER BY Date DESC, Time DESC";
SqlCommand sqlCommand = new SqlCommand(command, DBConnection.getInstance().Conn);
DBConnection.getInstance().Conn.Open();
using (SqlDataReader reader = sqlCommand.ExecuteReader())
{
while (reader.Read())
{
long _meetingID = reader.GetInt32(reader.GetOrdinal("MeetingID"));
string _studentID = reader.GetString(reader.GetOrdinal("StudentID"));
string _tutorID = reader.GetString(reader.GetOrdinal("TutorID"));
DateTime _date = reader.GetDateTime(reader.GetOrdinal("Date"));
TimeSpan _time = reader.GetTimeSpan(reader.GetOrdinal("Time"));;
string _type = reader.GetString(reader.GetOrdinal("Type"));
string _location = reader.GetString(reader.GetOrdinal("Location"));
string _StudentStatus = reader.GetString(reader.GetOrdinal("StudentStatus"));
string _TutorStatus = reader.GetString(reader.GetOrdinal("TutorStatus"));
string _studentName = reader.GetString(reader.GetOrdinal("Student"));
string _tutorName = reader.GetString(reader.GetOrdinal("Tutor"));
MeetingDetails md = new MeetingDetails(_meetingID, _studentID,
_tutorID, _date, _time, _type, _location, _StudentStatus, _TutorStatus, _studentName, _tutorName);
allMeetings.Add(md);
}
}
return(allMeetings);
}
catch (ArgumentOutOfRangeException aoorex)
{
return(null);
}
catch (Exception ex)
{
return(null);
}
finally
{
DBConnection.getInstance().Conn.Close();
}
}
//public static List<MeetingDetails> getAllMeetingsByStudentID(string id)
//{
// try
// {
// List<MeetingDetails> allMeetings = new List<MeetingDetails>();
// string command = "SELECT * FROM MeetingDetails WHERE StudentID = '" + id + "'";
// SqlCommand sqlCommand = new SqlCommand(command, DBConnection.getInstance().Conn);
// DBConnection.getInstance().Conn.Open();
// using (SqlDataReader reader = sqlCommand.ExecuteReader())
// {
// while (reader.Read())
// {
// long _meetingID = reader.GetInt32(reader.GetOrdinal("MeetingID"));
// string _studentID = reader.GetString(reader.GetOrdinal("StudentID"));
// string _tutorID = reader.GetString(reader.GetOrdinal("TutorID"));
// DateTime _date = reader.GetDateTime(reader.GetOrdinal("Date"));
// TimeSpan _time = reader.GetTimeSpan(reader.GetOrdinal("Time")); ;
// string _type = reader.GetString(reader.GetOrdinal("Type"));
// string _location = reader.GetString(reader.GetOrdinal("Location"));
// string _StudentStatus = reader.GetString(reader.GetOrdinal("StudentStatus"));
// string _TutorStatus = reader.GetString(reader.GetOrdinal("TutorStatus"));
// MeetingDetails md = new MeetingDetails(_meetingID, _studentID,
// _tutorID, _date, _time, _type, _location, _StudentStatus, _TutorStatus);
// allMeetings.Add(md);
// }
// }
// return allMeetings;
// }
// catch (ArgumentOutOfRangeException aoorex)
// {
// return null;
// }
// catch (Exception ex)
// {
// return null;
// }
// finally
// {
// DBConnection.getInstance().Conn.Close();
// }
//}
public static List<MeetingDetails> getAllMeetingsByTutorID(string id)
{
try
{
List<MeetingDetails> allMeetings = new List<MeetingDetails>();
string command =
"SELECT MeetingDetails.MeetingID, MeetingDetails.StudentID, { fn CONCAT({ fn CONCAT(UserDetails.Firstname, ', ') }, dbo.UserDetails.Surname) } AS 'Student', " +
"MeetingDetails.TutorID, { fn CONCAT({ fn CONCAT(UserDetails_1.Firstname, ', ') }, UserDetails_1.Surname) } AS Tutor, dbo.MeetingDetails.Date, " +
"MeetingDetails.Time, MeetingDetails.Type, MeetingDetails.Location, MeetingDetails.StudentStatus, MeetingDetails.TutorStatus " +
"FROM MeetingDetails INNER JOIN " +
"UserDetails ON MeetingDetails.StudentID = UserDetails.UserID INNER JOIN " +
"UserDetails AS UserDetails_1 ON MeetingDetails.TutorID = UserDetails_1.UserID " +
"WHERE MeetingDetails.TutorID='" + id + "' ORDER BY Date DESC, Time DESC";
SqlCommand sqlCommand = new SqlCommand(command, DBConnection.getInstance().Conn);
DBConnection.getInstance().Conn.Open();
using (SqlDataReader reader = sqlCommand.ExecuteReader())
{
while (reader.Read())
{
long _meetingID = reader.GetInt32(reader.GetOrdinal("MeetingID"));
string _studentID = reader.GetString(reader.GetOrdinal("StudentID"));
string _tutorID = reader.GetString(reader.GetOrdinal("TutorID"));
DateTime _date = reader.GetDateTime(reader.GetOrdinal("Date"));
TimeSpan _time = reader.GetTimeSpan(reader.GetOrdinal("Time")); ;
string _type = reader.GetString(reader.GetOrdinal("Type"));
string _location = reader.GetString(reader.GetOrdinal("Location"));
string _StudentStatus = reader.GetString(reader.GetOrdinal("StudentStatus"));
string _TutorStatus = reader.GetString(reader.GetOrdinal("TutorStatus"));
string _studentName = reader.GetString(reader.GetOrdinal("Student"));
string _tutorName = reader.GetString(reader.GetOrdinal("Tutor"));
MeetingDetails md = new MeetingDetails(_meetingID, _studentID,
_tutorID, _date, _time, _type, _location, _StudentStatus, _TutorStatus, _studentName, _tutorName);
allMeetings.Add(md);
}
}
return allMeetings;
}
catch (ArgumentOutOfRangeException aoorex)
{
return null;
}
catch (Exception ex)
{
return null;
}
finally
{
DBConnection.getInstance().Conn.Close();
}
}
private void updateMeeting(string MeetingID, string updateType)
{
string _recieverEmail = "";
string _senderEmail = "";
string _message = "";
string _subject = "";
UserDetails _user = (UserDetails)Session["User"];
UserDetails tutorDetails = new UserDetails();
MeetingDetails meetingInfo = new MeetingDetails();
meetingInfo.MeetingID = long.Parse(MeetingID);
meetingInfo.selectMeetingDetailsByMeetingID();
tutorDetails= UserDetails.getUserById(meetingInfo.TutorID.ToString());
_recieverEmail = tutorDetails.EmailAddress.ToString().Trim();
_senderEmail = _user.EmailAddress.ToString();
_subject = "Meeting Update";
_message = "Hello " + tutorDetails.FirstName + " "+tutorDetails.Surname;
_message += Environment.NewLine;
_message += "There is a meeting update please login to the eTutor System to view the meeting details, thank you.";
_message += Environment.NewLine + Environment.NewLine;
_message += "Kind Regards, " + Environment.NewLine + _user.Fullname.ToString();
general_functions.Instance.email(_recieverEmail, _senderEmail, _message, _subject);
if(updateType == "Accepted")
{
meetingInfo.StudentStatus = "Accepted";
}
else if(updateType == "Declined")
{
meetingInfo.StudentStatus = "Declined";
}
meetingInfo.updateStudentToDatabase();
populateDropDownList();
appointmentPanel.Visible = true;
populateTable();
}