Esempio n. 1
0
        public static bool DeleteAlbum(Album albumToDelete)
        {
            bool success = false;

            using (CDCatalogEntities db = new CDCatalogEntities())
            {
                try
                {
                    Album alb = db.Albums.Where(a => a.AlbumID.Equals(albumToDelete.AlbumID)).First();

                    db.Albums.Remove(alb);
                    db.SaveChanges();
                    success = true;
                }
                catch (Exception SQLe)
                {
                    LogError("CDCatalogManager.DeleteAlbum", SQLe.ToString());
                    //using (StreamWriter sw = File.AppendText("errorlog.txt"))
                    //{
                    //    sw.WriteLine("--------------");
                    //    sw.WriteLine(DateTime.Now);
                    //    sw.WriteLine("Source: CDCatalogManager.DeleteAlbums");
                    //    sw.WriteLine(SQLe.ToString());
                    //}
                }
                return(success);
            }
        }
Esempio n. 2
0
    /*
     * Gets user type
     */
    protected String GetUserType()
    {
        String user = "";

        try
        {
            SqlConnection sc    = new SqlConnection(ConfigurationManager.ConnectionStrings["conString"].ConnectionString); // connection string is in web config
            SqlCommand    query = new SqlCommand();

            sc.Open();

            query.Connection  = sc;
            query.CommandText = "Select UserType From GeneralUser where EmailAddress=  '" + (String)Session["UserID"] + "'";// Gathers all notifications for specific user
            SqlDataReader read = query.ExecuteReader();

            while (read.Read())
            {
                user = read.GetString(0);
            }
            sc.Close();
        }
        catch (SqlException SQLe)
        {
            System.Diagnostics.Debug.Write(SQLe.ToString());
        }

        return(user);
    }
Esempio n. 3
0
        public static bool DeletePlaylistSong(PlaylistSong playlistSongToDelete)
        {
            bool success = false;

            using (CDCatalogEntities db = new CDCatalogEntities())
            {
                try
                {
                    db.PlaylistSongs.Remove(playlistSongToDelete);
                    db.SaveChanges();
                    success = true;
                }
                catch (Exception SQLe)
                {
                    LogError("CDCatalogManager.DeletePlaylistSong", SQLe.ToString());
                    //using (StreamWriter sw = File.AppendText("errorlog.txt"))
                    //{
                    //    sw.WriteLine("--------------");
                    //    sw.WriteLine(DateTime.Now);
                    //    sw.WriteLine("Source: CDCatalogManager.DeletePlaylistSong");
                    //    sw.WriteLine(SQLe.ToString());
                    //}
                }
                return(success);
            }
        }
Esempio n. 4
0
        public static bool UpdatePlaylistSong(PlaylistSong editedPlaylistSong)
        {
            bool success = false;

            using (CDCatalogEntities db = new CDCatalogEntities())
            {
                try
                {
                    PlaylistSong playlistSong = db.PlaylistSongs.Where(p => p.PlaylistID.Equals(editedPlaylistSong.PlaylistID) &&
                                                                       p.SongID.Equals(editedPlaylistSong.SongID)).First();
                    playlistSong.SongOrder = editedPlaylistSong.SongOrder;
                    db.SaveChanges();
                    success = true;
                }
                catch (Exception SQLe)
                {
                    LogError("CDCatalogManager.UpdatePlaylistSong", SQLe.ToString());
                    //using (StreamWriter sw = File.AppendText("errorlog.txt"))
                    //{
                    //    sw.WriteLine("--------------");
                    //    sw.WriteLine(DateTime.Now);
                    //    sw.WriteLine("Source: CDCatalogManager.UpdatePlaylistSong");
                    //    sw.WriteLine(SQLe.ToString());
                    //}
                }
                return(success);
            }
        }
Esempio n. 5
0
        public static bool AddAlbum(Album newAlbum)
        {
            bool success = false;

            using (CDCatalogEntities db = new CDCatalogEntities())
            {
                try
                {
                    db.Albums.Add(newAlbum);
                    db.SaveChanges();
                    success = true;
                }
                catch (Exception SQLe)
                {
                    LogError("CDCatalogManager.AddAlbum", SQLe.ToString());
                    //using (StreamWriter sw = File.AppendText("errorlog.txt"))
                    //{
                    //    sw.WriteLine("--------------");
                    //    sw.WriteLine(DateTime.Now);
                    //    sw.WriteLine("Source: CDCatalogManager.AddAlbum");
                    //    sw.WriteLine(SQLe.ToString());
                    //}
                }
                return(success);
            }
        }
Esempio n. 6
0
        public static List <Song> GetSongsFromPlaylist(Playlist playlist)
        {
            //Take a Playlist, find all the PlaylistSongs with the matchingPlaylistID,
            //and populate a List with all the Songs that match the PlaylistSongs' SongIDs.
            List <Song>         workingList = GetSongs();
            List <Song>         songList    = new List <Song>();
            List <PlaylistSong> pLSList     = new List <PlaylistSong>();

            using (CDCatalogEntities db = new CDCatalogEntities())
            {
                try
                {
                    pLSList = db.PlaylistSongs.Where(pls => pls.PlaylistID.Equals(playlist.PlaylistID)).ToList();
                    foreach (PlaylistSong pls in pLSList)
                    {
                        songList.Add(workingList.Where(s => s.SongID.Equals(pls.SongID)).First());
                    }
                }
                catch (Exception SQLe)
                {
                    LogError("CDCatalogManager.GetSongsFromPlaylist", SQLe.ToString());
                    //using (StreamWriter sw = File.AppendText("errorlog.txt"))
                    //{
                    //    sw.WriteLine("--------------");
                    //    sw.WriteLine(DateTime.Now);
                    //    sw.WriteLine("Source: CDCatalogManager.GetSongsFromPlaylist");
                    //    sw.WriteLine(SQLe.ToString());
                    //}
                }
            }
            return(songList);
        }
Esempio n. 7
0
 public static List <Song> GetSongs()
 {
     using (CDCatalogEntities db = new CDCatalogEntities())
     {
         List <Song> songList = new List <Song>();
         try
         {
             songList = db.Songs.OrderByDescending(s => s.Rating).ToList();
             //A Song is a complex object. It has associated Artist, Album, and Genre objects,
             //and the associated Album object has its own associated Artist object, which may be
             //different than the Artist associated with the Song.
             //This loop populates the Song object with its necessary associated data.
             foreach (Song song in songList)
             {
                 song.Artist       = db.Artists.Where(art => art.ArtistID.Equals(song.ArtistID)).First();
                 song.Genre        = db.Genres.Where(g => g.GenreID.Equals(song.GenreID)).First();
                 song.Album        = db.Albums.Where(alb => (alb.AlbumID == song.AlbumID)).First();
                 song.Album.Artist = db.Artists.Where(art => (art.ArtistID == song.Album.ArtistID)).First();
             }
         }
         catch (Exception SQLe)
         {
             LogError("CDCatalogManager.GetSongs", SQLe.ToString());
             //using (StreamWriter sw = File.AppendText("errorlog.txt"))
             //{
             //    sw.WriteLine("--------------");
             //    sw.WriteLine(DateTime.Now);
             //    sw.WriteLine("Source: CDCatalogManager.GetSongs");
             //    sw.WriteLine(SQLe.ToString());
             //}
         }
         return(songList);
     }
 }
Esempio n. 8
0
        public static bool UpdateSong(Song editedSong)
        {
            bool success = false;

            using (CDCatalogEntities db = new CDCatalogEntities())
            {
                try
                {
                    Song son = db.Songs.Where(s => s.SongID.Equals(editedSong.SongID)).First();
                    son.SongTitle     = editedSong.SongTitle;
                    son.AlbumID       = editedSong.AlbumID;
                    son.ArtistID      = editedSong.ArtistID;
                    son.GenreID       = editedSong.GenreID;
                    son.PlaylistSongs = editedSong.PlaylistSongs;
                    son.Rating        = editedSong.Rating;
                    son.TrackLength   = editedSong.TrackLength;
                    son.TrackNumber   = editedSong.TrackNumber;
                    db.SaveChanges();
                    success = true;
                }
                catch (Exception SQLe)
                {
                    LogError("CDCatalogManager.UpdateSong", SQLe.ToString());
                    //using (StreamWriter sw = File.AppendText("errorlog.txt"))
                    //{
                    //    sw.WriteLine("--------------");
                    //    sw.WriteLine(DateTime.Now);
                    //    sw.WriteLine("Source: CDCatalogManager.UpdateSong");
                    //    sw.WriteLine(SQLe.ToString());
                    //}
                }
                return(success);
            }
        }
Esempio n. 9
0
        public static bool UpdatePlaylist(Playlist editedPlaylist)
        {
            bool success = false;

            using (CDCatalogEntities db = new CDCatalogEntities())
            {
                try
                {
                    Playlist play = db.Playlists.Where(p => p.PlaylistID.Equals(editedPlaylist.PlaylistID)).First();
                    play.PlaylistName = editedPlaylist.PlaylistName;
                    //TODO: Need to think about this process some more.
                    //play.PlaylistSongs = editedPlaylist.PlaylistSongs;
                    db.SaveChanges();
                    success = true;
                }
                catch (Exception SQLe)
                {
                    LogError("CDCatalogManager.UpdatePlaylist", SQLe.ToString());
                    //using (StreamWriter sw = File.AppendText("errorlog.txt"))
                    //{
                    //    sw.WriteLine("--------------");
                    //    sw.WriteLine(DateTime.Now);
                    //    sw.WriteLine("Source: CDCatalogManager.UpdatePlaylist");
                    //    sw.WriteLine(SQLe.ToString());
                    //}
                }
                return(success);
            }
        }
Esempio n. 10
0
        public static bool UpdateGenre(Genre editedGenre)
        {
            bool success = false;

            using (CDCatalogEntities db = new CDCatalogEntities())
            {
                try
                {
                    Genre gen = db.Genres.Where(g => g.GenreID.Equals(editedGenre.GenreID)).First();
                    gen.GenreName = editedGenre.GenreName;
                    //gen.Songs = editedGenre.Songs; //This seems unnecessary?
                    db.SaveChanges();
                    success = true;
                }
                catch (Exception SQLe)
                {
                    LogError("CDCatalogManager.UpdateGenre", SQLe.ToString());
                    //using (StreamWriter sw = File.AppendText("errorlog.txt"))
                    //{
                    //    sw.WriteLine("--------------");
                    //    sw.WriteLine(DateTime.Now);
                    //    sw.WriteLine("Source: CDCatalogManager.UpdateGenre");
                    //    sw.WriteLine(SQLe.ToString());
                    //}
                }
                return(success);
            }
        }
Esempio n. 11
0
        public static List <Album> GetAlbums()
        {
            List <Album> albumList = new List <Album>();

            using (CDCatalogEntities db = new CDCatalogEntities())
            {
                try
                {
                    albumList = db.Albums.OrderByDescending(a => a.Rating).ToList();
                    //An Album object has an associated Artist object; this loop attaches Artists to Albums.
                    foreach (Album alb in albumList)
                    {
                        alb.Artist = db.Artists.Where(art => art.ArtistID.Equals(alb.ArtistID)).First();
                    }
                }
                catch (Exception SQLe)
                {
                    LogError("CDCatalogManager.GetAlbums", SQLe.ToString());
                    //using (StreamWriter sw = File.AppendText("errorlog.txt"))
                    //{
                    //    sw.WriteLine("--------------");
                    //    sw.WriteLine(DateTime.Now);
                    //    sw.WriteLine("Source: CDCatalogManager.GetAlbums");
                    //    sw.WriteLine(SQLe.ToString());
                    //}
                }
                return(albumList);
            }
        }
Esempio n. 12
0
    protected void InsertParentApplicant(String email)
    {
        try
        {
            SqlConnection sc    = new SqlConnection(ConfigurationManager.ConnectionStrings["conString"].ConnectionString); // connection string is in web config
            SqlCommand    query = new SqlCommand();

            sc.ConnectionString = "Server=@LOCALHOST; Database = WBLDB; Trusted_Connection = Yes;";
            sc.Open();

            query.Connection  = sc;
            query.CommandText = "Insert INTO Applicant(EmailAddress, RequestedAccountType, Approved, DateRequested, DateApproved, StudentInfo)" +
                                "Values(@EmailAddress, @RequestedAccountType, @Approved, @DateRequested, @DateApproved, @StudentInfo)";

            String studentInfo;

            studentInfo  = "";
            studentInfo += txtChildEmail.Text + "," + txtChildFName.Text + "," + txtChildLName.Text + "," + txtChildDOB.Text;
            query.Parameters.AddWithValue("@EmailAddress", txtEmail.Text);
            query.Parameters.AddWithValue("@RequestedAccountType", Session["userType"].ToString());
            query.Parameters.AddWithValue("@Approved", "false");
            query.Parameters.AddWithValue("@DateRequested", DateTime.Now);
            query.Parameters.AddWithValue("@DateApproved", System.DBNull.Value);
            query.Parameters.AddWithValue("@StudentInfo", studentInfo);

            query.ExecuteNonQuery();

            sc.Close();
        }
        catch (SqlException SQLe)
        {
            System.Diagnostics.Debug.Write(SQLe.ToString());
        }
    }
    protected ArrayList GetStudents()
    {
        ArrayList result   = new ArrayList();
        String    courseID = ddlClasses.SelectedValue.ToString();

        try
        {
            SqlCommand    query = new SqlCommand();
            SqlConnection sc    = new SqlConnection(ConfigurationManager.ConnectionStrings["conString"].ConnectionString);

            sc.Open();

            query.Connection  = sc;
            query.CommandText = "SELECT GeneralUser.FirstName, GeneralUser.LastName, GeneralUser.EmailAddress  FROM Section " +
                                "Left JOIN Enrollment Inner JOIN GeneralUser ON Enrollment.EmailAddress = GeneralUser.EmailAddress " +
                                "ON Enrollment.SectionID = Section.SectionID Where Section.CourseID = " + courseID;

            SqlDataReader read = query.ExecuteReader();

            while (read.Read())
            {
                result.Add(read.GetString(0));
                result.Add(read.GetString(1));
                result.Add(read.GetString(2));
            }
            sc.Close();
        }
        catch (SqlException SQLe)
        {
            System.Diagnostics.Debug.Write(SQLe.ToString());
        }

        return(result);
    }
Esempio n. 14
0
        public static bool UpdateAlbum(Album editedAlbum)
        {
            bool success = false;

            using (CDCatalogEntities db = new CDCatalogEntities())
            {
                try
                {
                    Album alb = db.Albums.Where(a => a.AlbumID.Equals(editedAlbum.AlbumID)).First();
                    alb.AlbumTitle = editedAlbum.AlbumTitle;
                    alb.Rating     = editedAlbum.Rating;
                    alb.Year       = editedAlbum.Year;
                    alb.ArtistID   = editedAlbum.ArtistID;
                    db.SaveChanges();
                    success = true;
                }
                catch (Exception SQLe)
                {
                    LogError("CDCatalogManager.UpdateAlbum", SQLe.ToString());
                    //using (StreamWriter sw = File.AppendText("errorlog.txt"))
                    //{
                    //    sw.WriteLine("--------------");
                    //    sw.WriteLine(DateTime.Now);
                    //    sw.WriteLine("Source: CDCatalogManager.UpdateAlbum");
                    //    sw.WriteLine(SQLe.ToString());
                    //}
                }
                return(success);
            }
        }
    protected ArrayList GatherQuestions()
    {
        ArrayList result = new ArrayList();

        //int count = 0;
        try
        {
            SqlCommand    query = new SqlCommand();
            SqlConnection sc    = new SqlConnection(ConfigurationManager.ConnectionStrings["conString"].ConnectionString);
            sc.Open();

            query.Connection  = sc;
            query.CommandText = "Select QuestionID From QuestionOrder Where EvalID = " + (String)Session["EvalID"];// session variable eval
            SqlDataReader read = query.ExecuteReader();
            while (read.Read())
            {
                result.Add(read[0]);
                System.Diagnostics.Debug.WriteLine(read[0]);
                //count++;
            }
            sc.Close();
        }
        catch (SqlException SQLe)
        {
            System.Diagnostics.Debug.Write(SQLe.ToString());
        }

        return(result);
    }
Esempio n. 16
0
    private void insertCipher()
    {
        try
        {
            SqlConnection sc    = new SqlConnection(ConfigurationManager.ConnectionStrings["conString"].ConnectionString); // connection string is in web config
            SqlCommand    query = new SqlCommand();

            sc.Open();

            query.Connection  = sc;
            query.CommandText = "Insert Into Cipher(EmailAddress, BoolPaid) Values(@EmailAddress, @BoolPaid)";

            query.Parameters.AddWithValue("@EmailAddress", txtEmail.Text);
            query.Parameters.AddWithValue("@BoolPaid", 1);
            Debug.WriteLine(query.CommandText);
            Debug.WriteLine("Where @EmailAddress = " + txtEmail.Text);
            query.ExecuteNonQuery();

            query.CommandText = "update dbo.GeneralUser set ActivatedBool = 1 where EmailAddress = @EmailAddress";
            query.Parameters.AddWithValue("@EmailAddress", txtEmail.Text);
            query.ExecuteNonQuery();

            query.CommandText = "update dbo.GeneralUser set UserPermission = 1 where EmailAddress = @EmailAddress";
            query.Parameters.AddWithValue("@EmailAddress", txtEmail.Text);
            query.ExecuteNonQuery();


            sc.Close();
        }
        catch (SqlException SQLe)
        {
            System.Diagnostics.Debug.Write(SQLe.ToString());
        }
    }
    protected String[] GetStudentInfo(String applicantID)
    {
        String info = "";

        try
        {
            SqlConnection sc    = new SqlConnection(ConfigurationManager.ConnectionStrings["conString"].ConnectionString); // connection string is in web config
            SqlCommand    query = new SqlCommand();

            sc.Open();

            query.Connection  = sc;
            query.CommandText = "Select StudentInfo From Applicant Where EmailAddress = @EmailAddress";

            query.Parameters.AddWithValue("@EmailAddress", applicantID);
            Debug.WriteLine(query.CommandText);
            Debug.WriteLine("Where @EmailAddress = " + applicantID);
            SqlDataReader read = query.ExecuteReader();

            read.Read();
            info = read.GetString(0);



            sc.Close();
        }
        catch (SqlException SQLe)
        {
            System.Diagnostics.Debug.Write(SQLe.ToString());
        }
        char[]   delimiterChars = { ',' };
        String[] result         = info.Split(delimiterChars);

        return(result);
    }
    protected void AddCipher(String applicantID)
    {
        try
        {
            SqlConnection sc    = new SqlConnection(ConfigurationManager.ConnectionStrings["conString"].ConnectionString); // connection string is in web config
            SqlCommand    query = new SqlCommand();

            sc.Open();

            query.Connection  = sc;
            query.CommandText = "Insert Into Cipher(EmailAddress, BoolPaid) Values(@EmailAddress, @BoolPaid)";

            query.Parameters.AddWithValue("@EmailAddress", applicantID);
            query.Parameters.AddWithValue("@BoolPaid", 1);
            Debug.WriteLine(query.CommandText);
            Debug.WriteLine("Where @EmailAddress = " + applicantID);
            query.ExecuteNonQuery();

            sc.Close();
        }
        catch (SqlException SQLe)
        {
            System.Diagnostics.Debug.Write(SQLe.ToString());
        }
    }
Esempio n. 19
0
        public static bool UpdateArtist(Artist editedArtist)
        {
            bool success = false;

            using (CDCatalogEntities db = new CDCatalogEntities())
            {
                try
                {
                    Artist art = db.Artists.Where(a => a.ArtistID.Equals(editedArtist.ArtistID)).First();

                    art.ArtistName = editedArtist.ArtistName;
                    //art.Albums = editedArtist.Albums; //This seems unnecessary
                    //art.Songs = editedArtist.Songs; //This, too.
                    db.SaveChanges();
                    success = true;
                }
                catch (Exception SQLe)
                {
                    LogError("CDCatalogManager.UpdateArtist", SQLe.ToString());
                    //using (StreamWriter sw = File.AppendText("errorlog.txt"))
                    //{
                    //    sw.WriteLine("--------------");
                    //    sw.WriteLine(DateTime.Now);
                    //    sw.WriteLine("Source: CDCatalogManager.UpdateArtist");
                    //    sw.WriteLine(SQLe.ToString());
                    //}
                }
                return(success);
            }
        }
    protected void AddParent(String applicantID)
    {
        try
        {
            SqlConnection sc    = new SqlConnection(ConfigurationManager.ConnectionStrings["conString"].ConnectionString); // connection string is in web config
            SqlCommand    query = new SqlCommand();

            sc.Open();
            String[] student;
            student = GetStudentInfo(applicantID);


            //Add Parent Record

            query.Connection  = sc;
            query.CommandText = "Insert Into Parent(EmailAddress, LetterCount, Relationship) Values(@EmailAddress, @LetterCount, @Relationship)";

            query.Parameters.AddWithValue("@EmailAddress", applicantID);
            query.Parameters.AddWithValue("@LetterCount", 0);
            query.Parameters.AddWithValue("@Relationship", student[4]);
            Debug.WriteLine(query.CommandText);
            Debug.WriteLine("Where @EmailAddress = " + applicantID);
            query.ExecuteNonQuery();
            // compare student

            if (VerifyStudent(student))
            {
                // add parent student
                query.Connection  = sc;
                query.CommandText = "Insert Into ParentStudent(StudentEmailAddress, ParentEmailAddress, LetterTitel, LetterText, LetterDate) " +
                                    "Values(@StudentEmailAddress, @ParentEmailAddress, @LetterTitel, @LetterText, @LetterDate)";

                query.Parameters.AddWithValue("@StudentEmailAddress", student[0]);
                query.Parameters.AddWithValue("@ParentEmailAddress", applicantID);
                query.Parameters.AddWithValue("@LetterTitel", System.DBNull.Value);
                query.Parameters.AddWithValue("@LetterText", System.DBNull.Value);
                query.Parameters.AddWithValue("@LetterDate", System.DBNull.Value);

                Debug.WriteLine(query.CommandText);
                Debug.WriteLine("Where @EmailAddress = " + applicantID);
                query.ExecuteNonQuery();
            }



            sc.Close();
        }
        catch (SqlException SQLe)
        {
            System.Diagnostics.Debug.Write(SQLe.ToString());
        }
    }
    public void sendActivationEmail(string email)
    {
        String accountType = "";
        string applicantID = Session["applicantID"].ToString();

        try
        {
            SqlConnection sc    = new SqlConnection(ConfigurationManager.ConnectionStrings["conString"].ConnectionString); // connection string is in web config
            SqlCommand    query = new SqlCommand();

            sc.Open();

            query.Connection  = sc;
            query.CommandText = "Select RequestedAccountType From Applicant Where EmailAddress = @EmailAddress";

            query.Parameters.AddWithValue("@EmailAddress", applicantID);
            Debug.WriteLine(query.CommandText);
            Debug.WriteLine("Where @EmailAddress = " + applicantID);
            SqlDataReader read = query.ExecuteReader();

            while (read.Read())
            {
                accountType = read.GetString(0);
            }
            sc.Close();
        }
        catch (SqlException SQLe)
        {
            System.Diagnostics.Debug.Write(SQLe.ToString());
        }
        // Setting up an e-mail message, establishing the credentials for the email address it is coming from and the email address it is going to
        MailMessage message = new MailMessage();
        SmtpClient  client  = new SmtpClient();

        client.Host = "smtp.gmail.com";
        client.Port = 587;
        // LOCALHOST NUMBER SHOULD MATCH YOUR BROWSERS
        // run any webpage and copy the number over 55866 to debug
        string userActivation = "http://*****:*****@gmail.com");                                                                   // where activation email is being sent FROM
        message.To.Add(email);                                                                                                                      // where activation email is sent to user-supplied email address.
        // TODO: ^^ validate this textbox is in E-mail format
        message.Subject              = "Account Activation";                                                                                        // Subject of activation email
        message.Body                 = "Hello! </br></br>Your Words Beats and Life profile has now been approved. Your account activation link is here: </br></br> <a href = '" + userActivation + "'> Activate your account now to join the community!";
        message.IsBodyHtml           = true;                                                                                                        // message contained in html body
        client.EnableSsl             = true;                                                                                                        // secure connection
        client.UseDefaultCredentials = true;                                                                                                        // have to set up credentials as true
        client.Credentials           = new System.Net.NetworkCredential("*****@*****.**", "wordsbeatslife");                // user and PW for some client, replace this with user-supplied email/pw
        client.Send(message);
    }
Esempio n. 22
0
    private void insertStaff()
    {
        try
        {
            SqlConnection sc    = new SqlConnection(ConfigurationManager.ConnectionStrings["conString"].ConnectionString); // connection string is in web config
            SqlCommand    query = new SqlCommand();

            sc.Open();

            query.Connection  = sc;
            query.CommandText = "Insert Into Staff(EmailAddress, AdminEmailAddress, HireDate, StaffType, Specialty) Values (@EmailAddress, @AdminEmailAddress, @HireDate, @StaffType, @Specialty)";

            query.Parameters.AddWithValue("@EmailAddress", txtEmail.Text);
            query.Parameters.AddWithValue("@AdminEmailAddress", "*****@*****.**");
            query.Parameters.AddWithValue("@StaffType", ddlStaffType.Text);
            query.Parameters.AddWithValue("@HireDate", txtHireDate.Text);
            query.Parameters.AddWithValue("@Specialty", txtSpecialty.Text);

            Debug.WriteLine(query.CommandText);
            Debug.WriteLine("Where @EmailAddress = " + txtEmail.Text);
            query.ExecuteNonQuery();

            query.CommandText = "update dbo.GeneralUser set ActivatedBool = 1 where EmailAddress = @EmailAddress";
            query.Parameters.AddWithValue("@EmailAddress", txtEmail.Text);
            query.ExecuteNonQuery();

            query.CommandText = "update dbo.GeneralUser set UserPermission = 4 where EmailAddress = @EmailAddress";
            query.Parameters.AddWithValue("@EmailAddress", txtEmail.Text);
            query.ExecuteNonQuery();

            query.CommandText = "insert into Evaluatee (EvaluateeEmail, StaffEmailAddress) values (@EmailAddress, @StaffEmailAddress)";
            query.Parameters.AddWithValue("@EvaluateeEmail", txtEmail.Text);
            query.Parameters.AddWithValue("@StaffEmailAddress", txtEmail.Text);
            query.ExecuteNonQuery();

            query.CommandText = "insert into Respondent (RespondentEmail, StaffEmailAddress) values (@RespondentEmail, @StaffEmailAddress)";
            query.Parameters.AddWithValue("@RespondentEmail", txtEmail.Text);
            query.Parameters.AddWithValue("@StaffEmailAddress", txtEmail.Text);
            query.ExecuteNonQuery();

            sc.Close();
        }
        catch (SqlException SQLe)
        {
            System.Diagnostics.Debug.Write(SQLe.ToString());
        }
    }
    protected void PopDropDown()
    {
        ArrayList courses = new ArrayList();
        ArrayList users   = new ArrayList();
        DateTime  date    = DateTime.Now;

        try
        {
            SqlConnection sc    = new SqlConnection(ConfigurationManager.ConnectionStrings["conString"].ConnectionString); // connection string is in web config
            SqlCommand    query = new SqlCommand();



            sc.Open();

            query.Connection  = sc;
            query.CommandText = "Select Course.CourseName, Enrollment.CourseID from SectionStaff " +
                                "Inner Join Section  on SectionStaff.SectionID = Section.SectionID " +
                                "Inner Join Enrollment on Section.SectionID = Enrollment.SectionID " +
                                "Inner Join Course on Enrollment.CourseID = Course.CourseID " +
                                "Where SectionStaff.EmailAddress = '" + Session["UserID"].ToString() + "'";// Gathers all users of specific type
            SqlDataReader read = query.ExecuteReader();

            while (read.Read())
            {
                courses.Add(read.GetString(0));
                courses.Add(read.GetInt32(1));
            }


            sc.Close();

            ddlCourses.Items.Insert(0, "Please Select");
            for (int i = 0; i < courses.Count; i += 2)
            {
                ddlCourses.Items.Add(new ListItem(courses[i].ToString(), courses[i + 1].ToString()));
            }
        }
        catch (SqlException SQLe)
        {
            System.Diagnostics.Debug.Write(SQLe.ToString());
        }
    }
    protected void btnSendAnnounce_Click(object sender, EventArgs e)
    {
        ArrayList users = new ArrayList();
        DateTime  date  = DateTime.Now;

        try
        {
            SqlConnection sc    = new SqlConnection(ConfigurationManager.ConnectionStrings["conString"].ConnectionString); // connection string is in web config
            SqlCommand    query = new SqlCommand();



            sc.Open();

            query.Connection  = sc;
            query.CommandText = "Select EmailAddress From Enrollment Where CourseID = " + ddlCourses.SelectedValue.ToString();// Gathers all users of specific type
            SqlDataReader read = query.ExecuteReader();

            while (read.Read())
            {
                users.Add(read.GetString(0));
            }

            for (int i = 0; i < users.Count; i++)
            {
                query.CommandText = "Insert into Notifications(EmailAddress, NotificationType, NotificationDate, NotificationText, BriefDescription)" +
                                    " Values(@Email, Announcement, @Date, @Text, @Brief)";
                query.Parameters.AddWithValue("@Email", users[i]);
                query.Parameters.AddWithValue("@Date", date);
                query.Parameters.AddWithValue("@Text", txtText.Text);
                query.Parameters.AddWithValue("@Brief", txtHeader.Text);

                query.ExecuteNonQuery();
            }

            sc.Close();
        }
        catch (SqlException SQLe)
        {
            System.Diagnostics.Debug.Write(SQLe.ToString());
        }
    }
    protected void PopDropDown()
    {
        ArrayList result  = new ArrayList();
        ArrayList courses = new ArrayList();

        try
        {
            SqlCommand    query = new SqlCommand();
            SqlConnection sc    = new SqlConnection(ConfigurationManager.ConnectionStrings["conString"].ConnectionString);

            sc.Open();

            query.Connection  = sc;
            query.CommandText = "SELECT Section.CourseID, Course.CourseName FROM SectionStaff " +
                                "LEFT JOIN Section INNER JOIN Course ON Section.CourseID = Course.CourseID " +
                                "ON Section.SectionID = SectionStaff.SectionID Where SectionStaff.EmailAddress = '" +
                                Session["UserID"].ToString() + "'";
            SqlDataReader read = query.ExecuteReader();

            while (read.Read())
            {
                result.Add(read.GetInt32(0));
                result.Add(read.GetString(1));
            }

            sc.Close();

            ddlClasses.Items.Insert(0, "Please select");
            int count = 1;
            for (int i = 0; i < result.Count; i += 2)
            {
                //Debug.WriteLine(i);
                ddlClasses.Items.Insert(count, new ListItem(result[i + 1].ToString(), result[i].ToString()));
                count++;
            }
        }
        catch (SqlException SQLe)
        {
            System.Diagnostics.Debug.Write(SQLe.ToString() + "line 84");
        }
    }
Esempio n. 26
0
    protected void btnSendEmail_Click(object sender, EventArgs e)
    {
        ArrayList users     = new ArrayList();
        DateTime  startDate = DateTime.Now;
        DateTime  endDate   = DateTime.Now.AddDays(14);
        ArrayList events    = new ArrayList();

        Debug.WriteLine(DateTime.Now);
        Debug.WriteLine(DateTime.Now.AddDays(14));
        try
        {
            SqlConnection sc    = new SqlConnection(ConfigurationManager.ConnectionStrings["conString"].ConnectionString); // connection string is in web config
            SqlCommand    query = new SqlCommand();



            sc.Open();

            query.Connection  = sc;
            query.CommandText = "Select EmailAddress From " + ddlUser.SelectedValue.ToString();// Gathers all users of specific type
            SqlDataReader read = query.ExecuteReader();

            while (read.Read())
            {
                users.Add(read.GetString(0));
            }

            query.CommandText = "select * from WBLEvent where  EventDateTime between '" +
                                startDate + "' and '" + endDate + "' Order by EventType;";

            read = query.ExecuteReader();


            sc.Close();
        }
        catch (SqlException SQLe)
        {
            System.Diagnostics.Debug.Write(SQLe.ToString());
        }
    }
Esempio n. 27
0
    protected void GetNotificationData()
    {
        if (Request.QueryString.Count > 0)
        {
            if (Request.QueryString.Keys[0] == "NotificationID")
            {
                try
                {

                    SqlConnection sc = new SqlConnection(ConfigurationManager.ConnectionStrings["conString"].ConnectionString); // connection string is in web config
                    SqlCommand query = new SqlCommand();

                    sc.Open();

                    Debug.WriteLine(Request.QueryString["NotificationID"]);
                    query.Connection = sc;
                    query.CommandText = "Select NotificationText, BriefDescription, NotificationDate, NotificationType From Notifications where NotificationID=  " + Request.QueryString[0].ToString();// Gathers all notifications for specific user
                    SqlDataReader read = query.ExecuteReader();

                    while (read.Read())
                    {
                        Debug.WriteLine(read.GetString(0));

                        description = read.GetString(0);
                        quick = read.GetString(1);
                        date = read.GetDateTime(2);
                        type = read.GetString(3);
                    }
                    sc.Close();
                }
                catch (SqlException SQLe)
                {
                    System.Diagnostics.Debug.Write(SQLe.ToString());

                }

            }
        }
    }
Esempio n. 28
0
    private void insertAdmin()
    {
        try
        {
            SqlConnection sc    = new SqlConnection(ConfigurationManager.ConnectionStrings["conString"].ConnectionString); // connection string is in web config
            SqlCommand    query = new SqlCommand();

            sc.Open();

            query.Connection  = sc;
            query.CommandText = "Insert Into Administrator(EmailAddress, ManagerEmail, AdminTitle, HireDate) Values (@EmailAddress, @ManagerEmail, @AdminTitle, @HireDate)";

            query.Parameters.AddWithValue("@EmailAddress", txtEmail.Text);
            query.Parameters.AddWithValue("@ManagerEmail", "*****@*****.**");
            query.Parameters.AddWithValue("@AdminTitle", txtAdminTitle.Text);
            query.Parameters.AddWithValue("@HireDate", txtHireDate.Text);


            Debug.WriteLine(query.CommandText);
            Debug.WriteLine("Where @EmailAddress = " + txtEmail.Text);
            query.ExecuteNonQuery();

            query.CommandText = "update dbo.GeneralUser set ActivatedBool = 1 where EmailAddress = @EmailAddress";
            query.Parameters.AddWithValue("@EmailAddress", txtEmail.Text);
            query.ExecuteNonQuery();

            query.CommandText = "update dbo.GeneralUser set UserPermission = 4 where EmailAddress = @EmailAddress";
            query.Parameters.AddWithValue("@EmailAddress", txtEmail.Text);
            query.ExecuteNonQuery();


            sc.Close();
        }
        catch (SqlException SQLe)
        {
            System.Diagnostics.Debug.Write(SQLe.ToString());
        }
    }
Esempio n. 29
0
    public static ArrayList GetProfessors(String studentID)
    {
        ArrayList studs = new ArrayList();

        try
        {
            SqlConnection sc    = new SqlConnection();
            SqlCommand    query = new SqlCommand();

            sc.ConnectionString = @"Server = DESKTOP-QEKTMG0\LOCALHOST; Database = WBLDB; Trusted_Connection = Yes;";
            sc.Open();

            query.Connection  = sc;
            query.CommandText = "Select EmailAddress, FirstName, LastName From GeneralUser Where" +
                                " EmailAddress = (Select EmailAddress From CourseStaff Where CourseID = (Select CourseID " +
                                "From Course Where CourseID = (Select CourseID From Attendance Where " +
                                "EmailAddress = @EmailAddress )))";

            query.Parameters.AddWithValue("@EmailAddress", studentID);
            Debug.WriteLine(query.CommandText);
            Debug.WriteLine("Where @EmailAddress = " + studentID);
            SqlDataReader read = query.ExecuteReader();

            while (read.Read())
            {
                studs.Add(read.GetString(2));
                studs.Add(read.GetString(0));
                studs.Add(read.GetString(1));
            }
            sc.Close();
        }
        catch (SqlException SQLe)
        {
            System.Diagnostics.Debug.Write(SQLe.ToString());
        }

        return(studs);
    }
Esempio n. 30
0
    public static ArrayList GetStudents(String parentID)
    {
        ArrayList studs = new ArrayList();

        try
        {
            SqlConnection sc    = new SqlConnection();
            SqlCommand    query = new SqlCommand();

            sc.ConnectionString = @"Server = DESKTOP-QEKTMG0\LOCALHOST; Database = WBLDB; Trusted_Connection = Yes;";
            sc.Open();

            query.Connection  = sc;
            query.CommandText = "Select FirstName, LastName, EmailAddress " +
                                "FROM GeneralUser " +
                                "Where EmailAddress = (" +
                                "Select StudentEmailAddress from ParentStudent Where ParentEmailAddress = @ParentEmailAddress)";

            query.Parameters.AddWithValue("@ParentEmailAddress", parentID);
            Debug.WriteLine(query.CommandText);
            Debug.WriteLine("Where @EmailAddress = " + parentID);
            SqlDataReader read = query.ExecuteReader();

            while (read.Read())
            {
                studs.Add(read.GetString(2));
                studs.Add(read.GetString(0));
                studs.Add(read.GetString(1));
            }
            sc.Close();
        }
        catch (SqlException SQLe)
        {
            System.Diagnostics.Debug.Write(SQLe.ToString());
        }

        return(studs);
    }