private UserDetails GetUserDetails(string alias)
{
UserDetails user = new UserDetails();
var con = ConfigurationManager.ConnectionStrings["SqlServerConnectionString"].ToString();
MeetingDetails details = new MeetingDetails();
using (SqlConnection myConnection = new SqlConnection(con))
{
string oString = $"Select * from dbo.UserDetails where UserAlias='{alias}'";
SqlCommand oCmd = new SqlCommand(oString, myConnection);
myConnection.Open();
using (SqlDataReader oReader = oCmd.ExecuteReader())
{
if (oReader.HasRows)
{
while (oReader.Read())
{
user.UserName = oReader["UserName"].ToString();
user.UserAlias = oReader["UserAlias"].ToString();
user.UserId = (int)oReader["ID"];
}
}
myConnection.Close();
}
}
return(user);
}
protected void SendMailBttn_Click(object sender, EventArgs e)
{
string _recieverEmail = "";
string _senderEmail = "";
string _message = "";
string _subject = "";
string calendarValue = DateTime.Now.ToShortDateString();
if (Calendar.SelectedDate.ToShortDateString() == "01/01/0001")
{
calendarValue = DateTime.Now.AddDays(1).ToShortDateString();
}
else
{
calendarValue = Calendar.SelectedDate.ToShortDateString();
}
UserDetails _user = (UserDetails)Session["User"];
UserDetails tutorDetails = new UserDetails();
MeetingDetails meetingInfo = new MeetingDetails();
meetingInfo.selectMeetingDetailsByMeetingID();
tutorDetails = UserDetails.getUserById(_user.SupervisorID);
_recieverEmail = tutorDetails.EmailAddress.ToString().Trim();
_senderEmail = _user.EmailAddress.ToString();
_subject = "Meeting Request";
_message = "Hello " + tutorDetails.FirstName.ToString().Trim() + " " + tutorDetails.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 += LocationTB.Text + Environment.NewLine;
_message += Environment.NewLine + "Date and Time:";
_message += Environment.NewLine + calendarValue + " " + HourDDL.SelectedItem + ":" + MinuteDDL.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((HourDDL.SelectedItem.ToString() + ":" + MinuteDDL.SelectedItem.ToString() + ":" + "00").ToString());
TimeSpan TS = new TimeSpan(dtt.Hour, dtt.Minute, dtt.Second);
MeetingDetails studentMeetingDetails = new MeetingDetails(_user.UserID,
tutorDetails.UserID,
Convert.ToDateTime(calendarValue),
TS,
TypeDDL.SelectedItem.ToString(),
LocationTB.Text,
"Accepted",
"-");
studentMeetingDetails.insertToDatabase();
populateDropDownList();
appointmentPanel.Visible = true;
populateTable();
}
public MeetingDetails GetMeetingDetails(int meetingId, string alias)
{
var con = ConfigurationManager.ConnectionStrings["SqlServerConnectionString"].ToString();
MeetingDetails details = new MeetingDetails();
using (SqlConnection myConnection = new SqlConnection(con))
{
string oString = $"Select * from dbo.MeetingDetails where Id={meetingId} and IsActive = 1";
SqlCommand oCmd = new SqlCommand(oString, myConnection);
myConnection.Open();
var userDetails = this.GetUserDetails(alias);
var userAction = this.GetParticipantStatus(meetingId, alias); // this is fetching all user details for a particular meeting id
using (SqlDataReader oReader = oCmd.ExecuteReader())
{
while (oReader.Read())
{
details.MeetingId = (int)oReader["Id"];
details.MeetingTitle = oReader["Title"].ToString();
details.Organizer = oReader["Organizer"].ToString();
details.IsActive = (bool)oReader["IsActive"];
details.duration = (int)oReader["Duration"];
details.UserId = userDetails.UserId;
details.UserName = userDetails.UserName;
details.UserAlias = userDetails.UserAlias;
details.userActions = userAction;
}
myConnection.Close();
}
}
return(details);
}
private void MeetingUpdate(MeetingDetails md, FusionScheduler.MeetingUpdateStatus status)
{
_logger.InfoFormat(":{0}: Status:{1} Start:{2} End:{3} Organizer:{4} Subject:{5}", LogTag, status,
md.DateTimeStart, md.DateTimeEnd, md.Organizer, md.Subject);
_customMessage.SendMessage(_deviceId, status.ToString(), string.Empty, md);
}
public async Task <IActionResult> Put(int id, string userId, MeetingDetails model)
{
var user = await _accountRepository.GetByIdAsync(userId);
model.User = user;
model.Id = id;
await _genericRepository.UpdateAsync(model);
return(NoContent());
}
public IActionResult CreateMeeting(MeetingDetails details)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_db.MeetingDetails.Add(details);
_db.SaveChanges();
return(Ok());
}
public static MeetingDetails ToMeetingDetails(this MeetupEvents meetupEvent)
{
var details = new MeetingDetails();
details.Address = meetupEvent.Venue.Address1;
details.City = meetupEvent.Venue.City;
details.State = meetupEvent.Venue.State;
details.Zip = meetupEvent.Venue.Zip;
details.MeetingTime = meetupEvent.LocalTime;
details.Building = meetupEvent.HowToFindUs;
return(details);
}
// Display Students dash Info
public void displayStudentDashInfo(int _type)
{
UserDetails _user = null;
if (_type == 0) // 0=loggedin user; 1=student chosen
{
_user = (UserDetails)HttpContext.Current.Session["User"];
}
else
{
_user = model.selectUserDetailsById(StudentView.studentToView);
}
Hashtable _data = new Hashtable();
string[] _titles = { "Messages", "Meetings", "Blogs" };
string[] _subs = { "Received", "Sent", "Requests", "Real", "Virtual", "Cancelled" };
_data.Add(0, _titles);
_data.Add(1, _subs);
int _numMessagesFromStudent = model.countMessages(_user.UserID, _user.SupervisorID);
int _numMessagesFromTutor = model.countMessages(_user.SupervisorID, _user.UserID);
int _numBlogPosts = model.countBlogPosts(_user.UserID);
List <MeetingDetails> meetings = MeetingDetails.getAllMeetingsByStudentID(_user.UserID);
int _numMeetings = meetings.Count;
int _numAccepted = 0;
int _numDeclined = 0;
int _numCancelled = 0;
foreach (MeetingDetails m in meetings)
{
if (m.TutorStatus == "Accepted")
{
_numAccepted++;
}
else if (m.TutorStatus == "Declined")
{
_numDeclined++;
}
else if (m.TutorStatus == "Cancelled")
{
_numCancelled++;
}
}
string[] _tempArray = { _numMessagesFromTutor.ToString(), _numMessagesFromStudent.ToString(), _numMeetings.ToString(), _numAccepted.ToString(), _numDeclined.ToString(), _numCancelled.ToString(), _numBlogPosts.ToString() };
_data.Add(2, _tempArray);
StudentView.setInfoTable(_data);
}
private void updateMeeting(string MeetingID, string updateType)
{
string _recieverEmail = "";
string _senderEmail = "";
string _message = "";
string _subject = "";
UserDetails _user = (UserDetails)Session["User"];
UserDetails studentDetails = new UserDetails();
MeetingDetails meetingInfo = new MeetingDetails();
meetingInfo.MeetingID = long.Parse(MeetingID);
meetingInfo.selectMeetingDetailsByMeetingID();
studentDetails = UserDetails.getUserById(meetingInfo.StudentID.ToString());
_recieverEmail = studentDetails.EmailAddress.ToString().Trim();
_senderEmail = _user.EmailAddress.ToString();
_subject = "Meeting Update";
_message = "Hello " + studentDetails.FirstName + " " + studentDetails.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);
DateTime dtt = Convert.ToDateTime((DropDownList1.SelectedItem.ToString() + ":" + DropDownList3.SelectedItem.ToString() + ":" + "00").ToString());
TimeSpan TS = new TimeSpan(dtt.Hour, dtt.Minute, dtt.Second);
if (updateType == "Accepted")
{
meetingInfo.TutorStatus = "Accepted";
}
else if (updateType == "Declined")
{
meetingInfo.TutorStatus = "Declined";
}
meetingInfo.updateToDatabase();
populateDropDownList();
TuteesSelectionPanel.Visible = false;
appointmentPanel.Visible = true;
populateTable();
}
public async Task <IActionResult> GetMeetingDetails(string questionId, string meetingId)
{
try
{
var questions = meetingId;
if (questions == null)
{
return(NotFound());
}
var latestValue = new EditorValue();
if (_meetingDetails == null)
{
MeetingDetails meetingDetails = CreateNewMeeting(meetingId);
_meetingDetails.Add(meetingDetails);
latestValue.Value = null;
}
else
{
var data = _meetingDetails.Find(e => e.MeetingId == meetingId);
if (data == null)
{
MeetingDetails meetingDetails = CreateNewMeeting(meetingId);
latestValue.Value = null;
_meetingDetails.Add(meetingDetails);
}
else
{
var questionData = data.Questions.FirstOrDefault(item => item.QuestionId == questionId);
latestValue.Value = questionData.Value;
}
}
return(Ok(latestValue));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Gets the meeting details from share point.
/// </summary>
/// <param name="itemId">The meeting identifier.</param>
/// <returns>returns success or failure.</returns>
public static string GetMeetingDetailsFromSharePoint(string itemId)
{
string jsonstring = string.Empty;
ListItem item = null;
MeetingDetails meetings = null;
try
{
item = SharePointRepository.GetMeetingUriDetails(itemId);
if (item != null)
{
meetings = new MeetingDetails()
{
ID = Convert.ToString(item["ID"]),
OnLineMeetingId = Convert.ToString(item["MeetingId"]),
OnlineMeetingUri = Convert.ToString(item["OnlineMeetingURI"]),
OnlineMeetingUrl = Convert.ToString(item["JoinURL"]),
Organizer = Convert.ToString(item["Organizer"]),
Attendees = Convert.ToString(item["Attendees"]),
JoinUrl = Convert.ToString(item["JoinURL"]),
QuestionnaireRequired = Convert.ToString(item["QuestionnaireRequired"]),
PatientName = Convert.ToString(item["PatientName"]),
Status = Convert.ToString(item["Status"]),
AppointmentDate = Convert.ToString(item["AppointmentDate"]),
QuestionCategory = Convert.ToString(item["QuestionCategory"]),
StartTime = Convert.ToDateTime(item["StartTime"]),
EndTime = Convert.ToDateTime(item["EndTime"]),
DoctorsName = Convert.ToString(item["Title"]),
};
}
jsonstring = JsonConvert.SerializeObject(meetings);
}
catch (Exception)
{
throw;
}
return(jsonstring);
}
public void Constructor_Sets_Using_TimeSlot_And_Other_Properties()
{
var timeSlot = new TimeSlot(DateTime.Now, DateTime.Now.AddHours(1));
const string meetingTitle = "QA Meeting";
const string meetingAgenda = "Unit Testing code Coverage";
const string meetingLocation = "Online";
var meetingDetails = new MeetingDetails(timeSlot, meetingTitle, meetingLocation, meetingAgenda, null);
var newId = Guid.NewGuid();
meetingDetails.MeetingId = newId;
Assert.That(meetingDetails.StartTime, Is.EqualTo(timeSlot.StartTime));
Assert.That(meetingDetails.EndTime, Is.EqualTo(timeSlot.EndTime));
Assert.That(meetingDetails.MeetingTitle, Is.EqualTo(meetingTitle));
Assert.That(meetingDetails.MeetingAgenda, Is.EqualTo(meetingAgenda));
Assert.That(meetingDetails.MeetingLocation, Is.EqualTo(meetingLocation));
Assert.That(meetingDetails.Attendees, Is.Null);
Assert.That(meetingDetails.AttachmentFilePaths, Is.Null);
Assert.That(meetingDetails.MeetingId, Is.EqualTo(newId));
}
public IActionResult UpdateMeeting(int meetingId, MeetingDetails details)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
details.MeetingID = meetingId;
//if (meetingId.ToString() != details.MeetingID.ToString())
//{
// return BadRequest();
// }
// int MeetingID;
// if(Int32.TryParse(details.MeetingID.ToString(),out MeetingID))
_db.Entry(details).State = EntityState.Modified;
try
{
_db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!MeetingDetailExists(meetingId))
{
return(NotFound());
}
else
{
throw;
}
}
return(Ok());
}
public void Constructor_Sets_All_Properties()
{
var startTime = DateTime.Now;
var endTime = DateTime.Now.AddHours(1);
const string meetingTitle = "QA Meeting";
const string meetingAgenda = "Unit Testing code Coverage";
var meetingStartTime = DateTime.Now.AddMinutes(15);
var meetingEndTime = DateTime.Now.AddMinutes(45);
const string meetingLocation = "Online";
var meetingDetails = new MeetingDetails(startTime, endTime, meetingTitle, meetingLocation, meetingAgenda,
new List <IAttendee>()
{
new Attendee("Person1", new List <IMeetingInfo>
{
new MeetingInfo(meetingStartTime, meetingEndTime)
}),
new Attendee("Person2", new List <IMeetingInfo>
{
new MeetingInfo(meetingStartTime, meetingEndTime)
}),
});
var newId = Guid.NewGuid();
meetingDetails.MeetingId = newId;
Assert.That(meetingDetails.StartTime, Is.EqualTo(startTime.CalibrateToMinutes()));
Assert.That(meetingDetails.EndTime, Is.EqualTo(endTime.CalibrateToMinutes()));
Assert.That(meetingDetails.MeetingTitle, Is.EqualTo(meetingTitle));
Assert.That(meetingDetails.MeetingAgenda, Is.EqualTo(meetingAgenda));
Assert.That(meetingDetails.MeetingLocation, Is.EqualTo(meetingLocation));
Assert.That(meetingDetails.Attendees.Count, Is.EqualTo(2));
Assert.That(meetingDetails.AttachmentFilePaths, Is.Null);
Assert.That(meetingDetails.MeetingId, Is.EqualTo(newId));
}
// Display Tutees
public void displayTutees(int _type, string firstName, string surname, int programmeID, int orderType)
{
UserDetails _user = null;
if (_type == 0) // 0=loggedin user; 1=student chosen
{
_user = (UserDetails)HttpContext.Current.Session["User"];
}
else
{
_user = model.selectUserDetailsById(TutorView.studentToView);
}
List <UserDetails> _tutees = new List <UserDetails>();
if (firstName != "" || surname != "" || programmeID > 0 || orderType > 0)
{
_tutees = model.selectTuteesBySearchCriteria(_user.UserID, firstName, surname, programmeID, orderType);
}
else
{
_tutees = model.selectTutees(_user.UserID);
}
int _numTutees = _tutees.Count;
if (_numTutees > 0)
{
int _counter = 2;
Hashtable _data = new Hashtable();
string[] _titles = { "Student", "Messages", "Meetings", "Uploads", "Blogs" };
string[] _subs = { " - ", "Firstname", "Surname", "Received", "Sent", "Last", "Requests", "Real", "Virtual", "Cancelled", "Last", "Number", "Comments", "Entries", "Last" };
_data.Add(0, _titles);
_data.Add(1, _subs);
foreach (UserDetails _tutee in _tutees)
{
int _numMessagesFromStudent = model.countMessages(_tutee.UserID, _user.UserID);
int _numMessagesFromTutor = model.countMessages(_user.UserID, _tutee.UserID);
DateTime _lastMessageDate = model.getDateOfLastMessageSent(_user.UserID, _tutee.UserID);
string _lastMessageStr = (_lastMessageDate.ToShortDateString().Equals("01/01/0001")) ? "n/a" : _lastMessageDate.ToShortDateString();
int _numFilesUploadedByStudent = model.countFilesUploadedByStudent(_tutee.UserID);
List <UserDocument> _documentList = model.selectUploadFiles(_tutee.UserID);
int _numberComments = 0;
int _blogPosts = model.countBlogPosts(_tutee.UserID);
DateTime _lastBlogDate = model.getDateOfLastBlogPost(_tutee.UserID);
string _lastBlogStr = (_lastBlogDate.ToShortDateString().Equals("01/01/0001")) ? "n/a" : _lastBlogDate.ToShortDateString();
foreach (UserDocument _doc in _documentList)
{
if (model.commentExists(_doc.DocumentID.ToString()) == true)
{
_numberComments++;
}
}
List <MeetingDetails> meetings = MeetingDetails.getAllMeetingsByStudentID(_tutee.UserID);
int _numMeetings = meetings.Count;
int _numAccepted = 0;
int _numDeclined = 0;
int _numCancelled = 0;
DateTime last = DateTime.Parse("01/01/0001");
string date = "";
foreach (MeetingDetails m in meetings)
{
if (m.StudentStatus == "Accepted")
{
_numAccepted++;
}
else if (m.StudentStatus == "Declined")
{
_numDeclined++;
}
else if (m.StudentStatus == "Cancelled")
{
_numCancelled++;
}
if (m.Date > last)
{
last = m.Date;
}
}
if (last == DateTime.Parse("01/01/0001"))
{
date = "n/a";
}
else
{
date = last.ToString();
}
string[] _tempArray = { _tutee.UserID, _tutee.FirstName, _tutee.Surname, _numMessagesFromStudent.ToString(), _numMessagesFromTutor.ToString(), _lastMessageStr, _numMeetings.ToString(), _numAccepted.ToString(), _numDeclined.ToString(), _numCancelled.ToString(), date, _numFilesUploadedByStudent.ToString(), _numberComments.ToString(), _blogPosts.ToString(), _lastBlogStr };
_data.Add(_counter, _tempArray);
_counter++;
}
TutorView.numTutees = "Number of Tutees: " + _numTutees;
TutorView.setTuteesTable(_data);
}
else
{
TutorView.noTutees = "No tutees found. This may be because your search criteria returned no results, or you have no students allocated to you.";
}
}
public void UpdateMegging(string meetingId, MeetingDetails details)
{
}
public async Task <ActionResult> Post(MeetingDetails model)
{
var entity = await _genericRepository.CreateAsync(model);
return(new CreatedAtRouteResult("GetMeetingsDetail", new { id = entity.Id }, entity));
}
private void populateTable()
{
UserDetails _user = (UserDetails)Session["User"];
meetingHistoryTable.Rows.Clear();
List <MeetingDetails> allMeetingsByTutorID;
allMeetingsByTutorID = MeetingDetails.getAllMeetingsByTutorID(_user.UserID);
int i = 0;
foreach (MeetingDetails md in allMeetingsByTutorID)
{
TableRow row = new TableRow();
TableCell cell = new TableCell();
cell.Text = "" + md.MeetingID.ToString().Trim();
cell.Width = new Unit(50);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = "" + md.StudentName.ToString().Trim();
cell.Width = new Unit(50);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = "" + md.Date.ToString().Substring(0, 10);
cell.Width = new Unit(50);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = "" + md.Time;
cell.Width = new Unit(50);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = "" + md.Type.ToString().Trim();
cell.Width = new Unit(400);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = "" + md.Location.ToString().Trim();
cell.Width = new Unit(50);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = "" + md.StudentStatus.ToString().Trim();
cell.Width = new Unit(50);
row.Cells.Add(cell);
if (md.TutorStatus.ToString().Trim() == "-")
{
cell = new TableCell();
cell.Text = "" + md.TutorStatus.ToString().Trim();
cell.Width = new Unit(50);
row.Cells.Add(cell);
cell = new TableCell();
cell.Controls.Add(createLinkButton(md.MeetingID.ToString(), "AcceptDecline"));
cell.Controls.Add(new Literal()
{
ID = md.MeetingID.ToString() + "br", Text = "<br/>"
});
cell.Controls.Add(createLinkButton(md.MeetingID.ToString(), "DeclineAccept"));
cell.Width = new Unit(50);
row.Cells.Add(cell);
}
else if (md.TutorStatus.ToString().Trim() == "Accepted")
{
cell = new TableCell();
cell.Text = "" + md.TutorStatus.ToString().Trim();
cell.Width = new Unit(50);
row.Cells.Add(cell);
cell = new TableCell();
cell.Controls.Add(createLinkButton(md.MeetingID.ToString(), "Decline"));
cell.Width = new Unit(50);
row.Cells.Add(cell);
}
else if (md.TutorStatus.ToString().Trim() == "Declined")
{
cell = new TableCell();
cell.Text = "" + md.TutorStatus.ToString().Trim();
cell.Width = new Unit(50);
row.Cells.Add(cell);
cell = new TableCell();
cell.Controls.Add(createLinkButton(md.MeetingID.ToString(), "Accept"));
cell.Width = new Unit(50);
row.Cells.Add(cell);
}
// Set Row colours
if (i % 2 == 0)
{
row.BackColor = Color.FromArgb(161, 178, 195);
}
else
{
row.BackColor = Color.WhiteSmoke;
}
i++;
meetingHistoryTable.Rows.Add(row);
}
meetingHistoryTable.GridLines = GridLines.Both;
Session["meetingDetailsLists"] = allMeetingsByTutorID;
}
