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();
        }
 private void checkUser()
 {
     _user = (UserDetails)Session["User"];
     if (Request.QueryString["blogOwner"] != null)
     {
         string blogOwner = Request.QueryString["blogOwner"];
         if (_user != null)
         {
             if (_user.UserType == 1)
             {
                 if (!blogOwner.Equals(_user.UserID))
                 {
                     Response.Redirect("student_area.aspx", true);
                 }
             }
             else
             {
                 Label author = new Label();
                 UserDetails blogAuthor = model.selectUserDetailsById(Request.QueryString["blogOwner"]);
                 author.Text = "Blog Author: " + blogAuthor.FirstName + " " + blogAuthor.Surname;
                 author.CssClass = "standardLabel";
                 authorPanel.Controls.Add(author);
                 newPostLinkPanel.Visible = false;
                 newPostFormPanel.Visible = false;
             }
         }
     }
     else
     {
         if (_user.UserType == 1)
         {
             Response.Redirect("blog.aspx?blogOwner=" + _user.UserID, true);
         }
         else
         {
             if (!Page.IsPostBack)
             {
                 general_functions.Instance.loadTuteeDropDown("blog");
             }
             selectTuteePanel.Visible = true;
             blogHistoryLinkPanel.Visible = false;
             blogHistoryPanel.Visible = false;
             newPostLinkPanel.Visible = false;
             newPostFormPanel.Visible = false;
         }
     }
 }
        protected void Page_Load(object sender, EventArgs e)
        {
            controller.MeetingView = this;
            populateTable();
            general_functions.Instance.MeetingView = this;
            Meeting_Controller.ControllerInstance.MeetingView = this;
            general_functions.Instance.setWelcomeMessage("meeting");

            populateDropDownList();
             UserDetails studentCheck = new UserDetails();
            List<MeetingDetails> meetingDetailsLists = new List<MeetingDetails>();
            studentCheck = (UserDetails)Session["User"];

            if ((Session["StudentMeetingDetailsLists"] != null)
                && (HttpContext.Current.Request.QueryString["ButtonID"] != null)
                && (HttpContext.Current.Request.QueryString["type"] != null))
            {
                meetingDetailsLists = (List<MeetingDetails>)Session["StudentMeetingDetailsLists"];

                foreach (MeetingDetails meetingItem in meetingDetailsLists)
                {
                    if (meetingItem.MeetingID == int.Parse(HttpContext.Current.Request.QueryString["ButtonID"])
                        && studentCheck.UserID == meetingItem.StudentID)
                    {
                        if (HttpContext.Current.Request.QueryString["type"] == "Accept")
                        {
                            string MeetingID = meetingItem.MeetingID.ToString();
                            string updateType = "Accepted";
                            updateMeeting(MeetingID, updateType);
                            break;
                        }
                        if (HttpContext.Current.Request.QueryString["type"] == "Decline")
                        {
                            string MeetingID = meetingItem.MeetingID.ToString();
                            string updateType = "Declined";
                            updateMeeting(MeetingID, updateType);
                            break;
                        }
                         if (HttpContext.Current.Request.QueryString["type"] == "AcceptDecline")
                        {
                            string MeetingID = meetingItem.MeetingID.ToString();
                            string updateType = "Accepted";
                            updateMeeting(MeetingID, updateType);
                            break;
                         }
                         if (HttpContext.Current.Request.QueryString["type"] == "DeclineAccept")
                        {
                            string MeetingID = meetingItem.MeetingID.ToString();
                            string updateType = "Declined";
                            updateMeeting(MeetingID, updateType);
                            break;
                         }

                        else
                        {
                            break;
                        }
                    }
                }
            }

            if (!IsPostBack)
            {
                appointmentPanel.Visible = true;
                Session["StudentMeetingDetailsLists"] = null;
                populateDropDownList();
                populateTable();
            }
        }
        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();
        }
Exemple #5
0
 private UserDetails constructUserDetailsFromReader(SqlDataReader rdr)
 {
     UserDetails ud = null;
         string _userid = rdr["UserID"].ToString();
         string _fname = rdr["Firstname"].ToString();
         string _sname = rdr["Surname"].ToString();
         string _email = rdr["EmailAddress"].ToString();
         string _pass = rdr["Password"].ToString();
         int _type = int.Parse(rdr["UserType"].ToString());
         string _supervisor = rdr["SupervisorID"].ToString();
         string _programme = rdr["ProgrammeID"].ToString();
         int _programmeID = 0, result;
         if (int.TryParse(_programme, out result))
         {
             _programmeID = result;
         }
         ud = new UserDetails(_userid, _fname, _sname, _email, _pass, _type, _supervisor, _programmeID);
         return ud;
 }
        public static UserDetails getUserById(string id)
        {
            UserDetails user = null;
            try
            {
                string command = "SELECT * FROM UserDetails WHERE UserID = '" + id + "'";
                SqlCommand sqlCommand = new SqlCommand(command, DBConnection.getInstance().Conn);

                DBConnection.getInstance().Conn.Open();
                using (SqlDataReader reader = sqlCommand.ExecuteReader())
                {
                    if (reader.Read())
                    {
                        string userID = reader.GetString(reader.GetOrdinal("UserID"));
                        string firstName= reader.GetString(reader.GetOrdinal("FirstName"));
                        string surname = reader.GetString(reader.GetOrdinal("Surname"));
                        string emailAddress = reader.GetString(reader.GetOrdinal("EmailAddress"));
                        string password = reader.GetString(reader.GetOrdinal("Password"));
                        int userType = reader.GetInt32(reader.GetOrdinal("UserType"));
                        string supervisorID = reader.IsDBNull(reader.GetOrdinal("SupervisorID")) ? " " : reader.GetString(reader.GetOrdinal("SupervisorID")).ToString();
                        int programmeID = reader.IsDBNull(reader.GetOrdinal("ProgrammeID")) ? 0 : reader.GetInt32(reader.GetOrdinal("ProgrammeID"));
                        user = new UserDetails(userID, firstName, surname, emailAddress, password, userType, supervisorID, programmeID);
                    }
                }
            }
            catch (ArgumentOutOfRangeException aoorex)
            {
                return null;
            }
            catch (Exception ex)
            {
                return null;
            }
            finally
            {
                DBConnection.getInstance().Conn.Close();
            }
            return user;
        }
 // Set User Session Variables method
 private void setUserSessionVariables(UserDetails User)
 {
     HttpContext.Current.Session["User"] = User;
 }