Beispiel #1
0
        protected void GetStudent()
        {
            try {
                Int32 StudentID = Convert.ToInt32(Request.QueryString["StudentID"]);
                using (DefaultConnection db = new DefaultConnection())
                {

                    Student stu = (from objS in db.Students
                                   where objS.StudentID == StudentID
                                   select objS).FirstOrDefault();

                    if (stu != null)
                    {
                        txtName.Text = stu.LastName;
                        txtFirstName.Text = stu.FirstMidName;
                        txtEnrollmentDate.Text = stu.EnrollmentDate.ToString("yyyy-MM-dd");
                    }

                    var Courses = from c in db.Enrollments
                                  where c.StudentID == StudentID
                                  select c;
                    grdCoursesEnrolled.DataSource = Courses.ToList();
                    grdCoursesEnrolled.DataBind();
            }

            }

             catch
            {
                Response.Redirect("~/error.aspx");
            }
        }
        protected void GetCourse()
        {
            //connect
            using (DefaultConnection db = new DefaultConnection())
            {
                //Get the selected courseID from the url
                Int32 CourseID = Convert.ToInt32(Request.QueryString["CourseID"]);

                //query the db
                Course objC = (from c in db.Courses
                               where c.CourseID == CourseID
                               select c).FirstOrDefault();

                //populate the form
                txtTitle.Text = objC.Title;
                txtCredits.Text = objC.Credits.ToString();
                ddlDepartment.SelectedValue = objC.DepartmentID.ToString();

                //populate student enrollments grid
                var Enrollments = from en in db.Enrollments
                                  where en.CourseID == CourseID
                                  orderby en.Student.LastName, en.Student.FirstMidName
                                  select en;

                //bind to the grid
                grdEnrollments.DataSource = Enrollments.ToList();
                grdEnrollments.DataBind();

            }
        }
        protected void GetDepartment()
        {
            try
            {
             // look up the selected department and fill the form
            using (DefaultConnection db = new DefaultConnection())
            {
                // store the id from url in variable
                Int32 DepartmentID = Convert.ToInt32(Request.QueryString["DepartmentID"]);

                // look up the department
                Department dep = (from d in db.Departments
                                  where d.DepartmentID == DepartmentID
                                  select d).FirstOrDefault();

                // prepoulate form fields
                txtName.Text = dep.Name;
                txtBudget.Text = Convert.ToString(dep.Budget);
            }
            }
            catch
            {
                Response.Redirect("~/error.aspx");
            }
        }
Beispiel #4
0
        protected void GetDepartments()
        {
            try {
                // use entity framework to connect and get the list of departments
                using (DefaultConnection db = new DefaultConnection())
                {
                    ////oold query that shows all departments
                    //var deps = from d in db.Departments
                    //           select d;
                    // new query filer for logged in user
                    Int32 DepartmentID = Convert.ToInt32(Session["DepartmentID"]);
                    var deps = from d in db.Departments
                               where d.DepartmentID == DepartmentID
                               select d;

                    // bind the deps query result to our grid
                    grdDepartments.DataSource = deps.ToList();
                    grdDepartments.DataBind();
                }
            }

            catch {
                Response.Redirect("error.aspx");
            }
        }
Beispiel #5
0
        protected void GetCourse()
        {
            try
            {
                using (DefaultConnection db = new DefaultConnection())
                {
                    Int32 CourseID = Convert.ToInt32(Request.QueryString["CourseID"]);
                    Course objc = (from c in db.Courses
                                   where c.CourseID == CourseID
                                   select c).FirstOrDefault();
                    txtTitle.Text = objc.Title;
                    txtCredits.Text = objc.Credits.ToString();
                    ddlDepartments.SelectedValue = objc.DepartmentID.ToString();

                    //populate student enrollments grid
                    var Enrollments = from en in db.Enrollments
                                      where en.CourseID == CourseID
                                      orderby en.Student.LastName
                                      select en;
                    grdEnrollments.DataSource = Enrollments.ToList();
                    grdEnrollments.DataBind();

                }
            }
            catch
            {
                Response.Redirect("~/error.aspx");
            }
        }
Beispiel #6
0
        protected void grdStudents_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            // identify the department id to be deleted from the row the user selected
            Int32 StudentID = Convert.ToInt32(grdStudents.DataKeys[e.RowIndex].Values["StudentID"]);
            try
            {
             //connect
            using (DefaultConnection db = new DefaultConnection())
            {
                Student stud = (from s in db.Students
                                where s.StudentID == StudentID
                                select s).FirstOrDefault();

                // delete
                db.Students.Remove(stud);
                db.SaveChanges();

                //refresh the grid
                GetStudents();
            }
            }
            catch
            {
                Response.Redirect("~/error.aspx");
            }
        }
Beispiel #7
0
        protected void GetCourses()
        {
            using (DefaultConnection db = new DefaultConnection())
            {
                var Courses = from c in db.Courses
                              select c;

                grdCourses.DataSource = Courses.ToList();
                grdCourses.DataBind();
            }
        }
Beispiel #8
0
        protected void btnLogin_Click(object sender, EventArgs e)
        {
            using (DefaultConnection db = new DefaultConnection())
            {
                Instructor objc = new Instructor();

                String username = txtUserName.Text;

                objc = (from i in db.Instructors
                        where i.Username == username
                        select i).FirstOrDefault();

                if (objc != null)
                {
                    String salt = objc.Salt;

                    //salt and hash password
                    String password = txtPassword.Text;

                    String pass_and_salt = password + salt;

                    // Create a new instance of the hash crypto service provider.
                    HashAlgorithm hashAlg = new SHA256CryptoServiceProvider();
                    // Convert the data to hash to an array of Bytes.
                    byte[] bytValue = System.Text.Encoding.UTF8.GetBytes(pass_and_salt);
                    // Compute the Hash. This returns an array of Bytes.
                    byte[] bytHash = hashAlg.ComputeHash(bytValue);
                    // Optionally, represent the hash value as a base64-encoded string,
                    // For example, if you need to display the value or transmit it over a network.
                    string base64 = Convert.ToBase64String(bytHash);

                    // cehck if matches password in db
                    if (objc.Password == base64)
                    {
                        lblError.Text = "Valid login";

                        // store session variable
                        Session["InstructorID"] = objc.InstructorID;
                        Session["InstructorName"] = objc.FirstName + " " + objc.LastName;
                        Session["DepartmentID"] = objc.DepartmentID;

                        Response.Redirect("departments.aspx");
                    }
                }
                else
                {
                    lblError.Text = "invalid login";
                }
            }
        }
Beispiel #9
0
        protected void GetEnrolledCourses()
        {
            using (DefaultConnection db = new DefaultConnection())
            {
                Int32 StudentID = Convert.ToInt32(Request.QueryString["StudentID"]);
                //Courses objc = (from s in db.Students
                //                where s.StudentID == StudentID
                //                select s).FirstOrDefault();
                //txtTitle.Text = objc.Title;
                //txtCredits.Text = objc.Credits.ToString();
                //ddlDepartments.SelectedValue = objc.DepartmentID.ToString();

            }
        }
Beispiel #10
0
        protected void GetStudents()
        {
            //try
            //{
            //connect to EF
            using (DefaultConnection db = new DefaultConnection())
            {

                //query the students table using EF and LINQ
                var Students = from s in db.Students
                               select s;

                //bind the result to the gridview
                grdStudents.DataSource = Students.ToList();
                grdStudents.DataBind();
            }
        }
        protected void GetDepartment()
        {
            //look up the selected department and fill the form
            using (DefaultConnection db = new DefaultConnection())
            {
                //store the id from the url in a variable
                Int32 DepartmentID = Convert.ToInt32(Request.QueryString["DepartmentID"]);

                //look up the department
                Department dep = (from d in db.Departments
                                  where d.DepartmentID == DepartmentID
                                  select d).FirstOrDefault();

                //pre-populate the form fields
                txtName.Text = dep.Name;
                txtBudget.Text = dep.Budget.ToString();
            }
        }
        protected void GetDepartments()
        {
            //connect
            using (DefaultConnection db = new DefaultConnection())
            {
                //get the department list
                var Departments = from d in db.Departments
                                  orderby d.Name
                                  select d;

                //bind to the dropdown list
                ddlDepartment.DataSource = Departments.ToList();
                ddlDepartment.DataBind();

                //add a default option to the dropdown after we fill it
                ListItem DefaultItem = new ListItem("-Select-", "0");
                ddlDepartment.Items.Insert(0, DefaultItem);
            }
        }
        protected void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
             // connect
            using (DefaultConnection db = new DefaultConnection())
            {
                // create a new department in memory
                Department dep = new Department();

                //check for url
                if (!String.IsNullOrEmpty(Request.QueryString["DepartmentID"]))
                {
                    // get ud from url
                    Int32 DepartmentID = Convert.ToInt32(Request.QueryString["DepartmentID"]);
                    dep = (from d in db.Departments
                           where d.DepartmentID == DepartmentID
                           select d).FirstOrDefault();
                }

                // fill the properties of the new department
                dep.Name = txtName.Text;
                dep.Budget = Convert.ToDecimal(txtBudget.Text);

                // add the new department if no url
                if (String.IsNullOrEmpty(Request.QueryString["DepartmentID"]))
                {
                    db.Departments.Add(dep);
                    db.SaveChanges();
                }

                // save new department
                db.SaveChanges();

                //redirect
                Response.Redirect("departments.aspx");
            }
            }
            catch
            {
                Response.Redirect("~/error.aspx");
            }
        }
Beispiel #14
0
        protected void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                using (DefaultConnection db = new DefaultConnection())
                {

                    Student stud = new Student();

                    if (!String.IsNullOrEmpty(Request.QueryString["StudentID"]))
                    {

                        Int32 StudentID = Convert.ToInt32(Request.QueryString["StudentID"]);
                        stud = (from s in db.Students
                                where s.StudentID == StudentID
                                select s).FirstOrDefault();
                    }

                    stud.LastName = txtName.Text;
                    stud.FirstMidName = txtFirstName.Text;
                    stud.EnrollmentDate = Convert.ToDateTime(txtEnrollmentDate.Text);

                    // add the new department if no url
                    if (String.IsNullOrEmpty(Request.QueryString["StudentID"]))
                    {
                        db.Students.Add(stud);
                        db.SaveChanges();
                    }

                    // save new department
                    db.SaveChanges();

                    //redirect
                    Response.Redirect("students.aspx");
            }

            }
            catch
            {
                Response.Redirect("~/error.aspx");
            }
        }
Beispiel #15
0
        protected void GetCourses()
        {
            try
            {
            // use entity framework to connect and get the list of departments
            using (DefaultConnection db = new DefaultConnection())
            {
                var cours = from c in db.Courses
                            select c;

                // bind the deps query result to our grid
                grdCourses.DataSource = cours.ToList();
                grdCourses.DataBind();
            }
            }
            catch
            {
                Response.Redirect("~/error.aspx");
            }
        }
        protected void btnRegister_Click(object sender, EventArgs e)
        {
            try
            {
                using (DefaultConnection db = new DefaultConnection())
                {
                    Instructor objc = new Instructor();

                    objc.FirstName = txtFirstName.Text;
                    objc.LastName = txtLastName.Text;
                    objc.Username = txtUserName.Text;
                    objc.DepartmentID = Convert.ToInt32(ddlDepartments.SelectedValue);

                    //salt and hash password
                    String password = txtPassword.Text;
                    String salt = CreateSalt(8);
                    String pass_and_salt = password + salt;

                    // Create a new instance of the hash crypto service provider.
                    HashAlgorithm hashAlg = new SHA256CryptoServiceProvider();
                    // Convert the data to hash to an array of Bytes.
                    byte[] bytValue = System.Text.Encoding.UTF8.GetBytes(pass_and_salt);
                    // Compute the Hash. This returns an array of Bytes.
                    byte[] bytHash = hashAlg.ComputeHash(bytValue);
                    // Optionally, represent the hash value as a base64-encoded string,
                    // For example, if you need to display the value or transmit it over a network.
                    string base64 = Convert.ToBase64String(bytHash);

                    objc.Password = base64;
                    objc.Salt = salt;

                    db.Instructors.Add(objc);
                    db.SaveChanges();
            }

            }
            catch
            {
                Response.Redirect("~/error.aspx");
            }
        }
        protected void GetDepartments()
        {
            //use Entity Framework to connect and get the list of Departments
            using (DefaultConnection db = new DefaultConnection())
            {
                //old query that shows all departments
                //var deps = from d in db.Departments
                //           select d;

                //new query filtered for logged in user only
                Int32 DepartmentID = Convert.ToInt32(Session["DepartmentID"]);

                var deps = from d in db.Departments
                           where d.DepartmentID == DepartmentID
                           select d;

                //bind the deps query result to our grid
                grdDepartments.DataSource = deps.ToList();
                grdDepartments.DataBind();
            }
        }
        protected void btnSave_Click(object sender, EventArgs e)
        {
            //connect
            using (DefaultConnection db = new DefaultConnection())
            {
                //create a new course and fill the properties
                Course objC = new Course();

                objC.Title = txtTitle.Text;
                objC.Credits = Convert.ToInt32(txtCredits.Text);
                objC.DepartmentID = Convert.ToInt32(ddlDepartment.SelectedValue);

                //save
                db.Courses.Add(objC);
                db.SaveChanges();

                //redirect
                Response.Redirect("courses.aspx");

            }
        }
        protected void grdDepartments_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            //identify the DepartmentID to be deleted from the row the user selected
            Int32 DepartmentID = Convert.ToInt32(grdDepartments.DataKeys[e.RowIndex].Values["DepartmentID"]);

            //connect
            using (DefaultConnection db = new DefaultConnection())
            {
                Department dep = (from d in db.Departments
                                  where d.DepartmentID == DepartmentID
                                  select d).FirstOrDefault();

                //delete
                db.Departments.Remove(dep);
                db.SaveChanges();

                //refresh grid
                GetDepartments();

            }
        }
Beispiel #20
0
        protected void GetDepartments()
        {
            try {
                using (DefaultConnection db = new DefaultConnection())
                {
                    var deps = from d in db.Departments
                               orderby d.Name
                               select d;

                    ddlDepartments.DataSource = deps.ToList();
                    ddlDepartments.DataBind();

                    ListItem DefaultItem = new ListItem("-Select-", "0");
                    ddlDepartments.Items.Insert(0, DefaultItem);
                }
            }

             catch
            {
                Response.Redirect("~/error.aspx");
            }
        }
Beispiel #21
0
        protected void btnSave_Click(object sender, EventArgs e)
        {
            //use EF to connect to SQL Server
            using (DefaultConnection db = new DefaultConnection())
            {

                //use the Student model to save the new record
                Student s = new Student();
                Int32 StudentID = 0;

                //check the querystring for an id so we can determine add / update
                if (Request.QueryString["StudentID"] != null)
                {
                    //get the id from the url
                    StudentID = Convert.ToInt32(Request.QueryString["StudentID"]);

                    //get the current student from EF
                    s = (from objS in db.Students
                         where objS.StudentID == StudentID
                         select objS).FirstOrDefault();
                }

                s.LastName = txtLastName.Text;
                s.FirstMidName = txtFirstMidName.Text;
                s.EnrollmentDate = Convert.ToDateTime(txtEnrollmentDate.Text);

                //call add only if we have no student ID
                if (StudentID == 0)
                {
                    db.Students.Add(s);
                }

                //run the update or insert
                db.SaveChanges();

                //redirect to the updated students page
                Response.Redirect("students.aspx");
            }
        }
Beispiel #22
0
        protected void GetStudent()
        {
            //populate form with existing student record
            Int32 StudentID = Convert.ToInt32(Request.QueryString["StudentID"]);

            //connect to db via EF
            using (DefaultConnection db = new DefaultConnection())
            {
                //populate a student instance with the StudentID from the URL parameter
                Student s = (from objS in db.Students
                             where objS.StudentID == StudentID
                             select objS).FirstOrDefault();

                //map the student properties to the form controls if we found a match
                if (s != null)
                {
                    txtLastName.Text = s.LastName;
                    txtFirstMidName.Text = s.FirstMidName;
                    txtEnrollmentDate.Text = s.EnrollmentDate.ToString("yyyy-MM-dd");
                }
            }
        }
        protected void btnSave_Click(object sender, EventArgs e)
        {
            //connect
            using (DefaultConnection db = new DefaultConnection())
            {
                //create a new department in memory
                Department dep = new Department();

                Int32 DepartmentID = 0;

                //check for a url
                if (!String.IsNullOrEmpty(Request.QueryString["DepartmentID"]))
                {
                    //get the id from the url
                    DepartmentID = Convert.ToInt32(Request.QueryString["DepartmentID"]);

                    //look up the department
                    dep = (from d in db.Departments
                           where d.DepartmentID == DepartmentID
                           select d).FirstOrDefault();
                }

                //fill the properties of the new department
                dep.Name = txtName.Text;
                dep.Budget = Convert.ToDecimal(txtBudget.Text);

                //add if we have no id in the url
                if (DepartmentID == 0)
                {
                    db.Departments.Add(dep);
                }

                //save the new department
                db.SaveChanges();

                //redirect to the departments list page
                Response.Redirect("departments.aspx");
            }
        }
Beispiel #24
0
        protected void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                using (DefaultConnection db = new DefaultConnection())
                {
                    Course objc = new Course();
                    objc.Title = txtTitle.Text;
                    objc.Credits = Convert.ToInt32(txtCredits.Text);
                    objc.DepartmentID = Convert.ToInt32(ddlDepartments.SelectedValue);

                    db.Courses.Add(objc);
                    db.SaveChanges();

                    Response.Redirect("courses.aspx");

                }
            }
            catch
            {
                Response.Redirect("~/error.aspx");
            }
        }
Beispiel #25
0
        protected void GetStudents()
        {
            // use entity framework to connect and get the list of departments
            try
            {
                using (DefaultConnection db = new DefaultConnection())
                {
                    var stud = from s in db.Students
                               select s;

                    //append the current direction to the Sort Column
                    String Sort = Session["SortColumn"].ToString() + " " + Session["SortDirection"].ToString();

                    grdStudents.DataSource = stud.AsQueryable().OrderBy(Sort).ToList();

                    grdStudents.DataBind();

                }
            }
            catch
            {
                Response.Redirect("~/error.aspx");
            }
        }
Beispiel #26
0
        //        catch(Exception e)
        //{
        //    Response.Redirect("/error.aspx");
        //}
        //}
        //}
        protected void grdStudents_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            //store which row was clicked
            Int32 selectedRow = e.RowIndex;

            //get the selected StudentID using the grid's Data Key collection
            Int32 StudentID = Convert.ToInt32(grdStudents.DataKeys[selectedRow].Values["StudentID"]);

            //use EF to remove the selected student from the db
            using (DefaultConnection db = new DefaultConnection())
            {

                Student s = (from objS in db.Students
                             where objS.StudentID == StudentID
                             select objS).FirstOrDefault();

                //do the delete
                db.Students.Remove(s);
                db.SaveChanges();
            }

            //refresh the grid
            GetStudents();
        }