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