public static List<Degree> GetAllDegress()
        {
            SqlConnection conn = null;
            int rId = 0;

            try
            {
                conn = new SqlConnection(connStr);
                conn.Open();

                String query = "Select DegreeID, DegreeName, MinCrHourRequired, MinCGPARequired from dbo.Degrees";

                SqlCommand command = new SqlCommand(query, conn);

                SqlDataReader reader = command.ExecuteReader();

                List<Degree> listDegree = new List<Degree>();

                while (reader.Read() == true)
                {
                    Degree degObj = new Degree();

                    degObj.DegreeID = reader.GetInt32(0); //DegreeID
                    degObj.DegreeName = reader.GetString(1); //DegreeName;
                    degObj.MinCrHourRequired = reader.GetInt32(2);
                    degObj.MinCGPARequired =(float) reader.GetDouble(3);

                    listDegree.Add(degObj);
                }

                return listDegree;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (conn != null)
                    conn.Close();
            }
        }
        public static Degree GetDegreeByID(int did)
        {
            SqlConnection conn = null;
            int rId = 0;

            try
            {
                conn = new SqlConnection(connStr);
                conn.Open();

                String query = "Select DegreeID, DegreeName, MinCrHourRequired, MinCGPARequired from dbo.Degrees Where DegreeID={0}";
                query = String.Format(query, did);

                SqlCommand command = new SqlCommand(query, conn);

                SqlDataReader reader = command.ExecuteReader();

                Degree degObj = null;
                if (reader.Read() == true)
                {
                    degObj = new Degree();

                    degObj.DegreeID = reader.GetInt32(0); //DegreeID
                    degObj.DegreeName = reader.GetString(1); //DegreeName;
                    degObj.MinCrHourRequired = reader.GetInt32(2);
                    degObj.MinCGPARequired = (float)reader.GetDouble(3);

                }

                return degObj;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (conn != null)
                    conn.Close();
            }
        }
        public static int SaveDegree(Degree degObj)
        {
            SqlConnection conn = null;
            int rId = 0;

            try
            {
                conn = new SqlConnection(connStr);
                conn.Open();

                String query = "";

                if (degObj.DegreeID > 0)
                {
                    query = "Update dbo.Degrees SET DegreeName='{0}', MinCrHourRequired={1}, MinCGPARequired={2} WHERE DegreeID = {3}";
                    query = String.Format(query, degObj.DegreeName, degObj.MinCrHourRequired, degObj.MinCGPARequired,degObj.DegreeID);
                }
                else
                {
                    query = "INSERT INTO dbo.Degrees(DegreeName, MinCrHourRequired, MinCGPARequired) VALUES('{0}',{1},{2})";
                    query = String.Format(query, degObj.DegreeName, degObj.MinCrHourRequired, degObj.MinCGPARequired);
                }

                SqlCommand command = new SqlCommand(query, conn);

                rId = command.ExecuteNonQuery();

                return rId;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (conn != null)
                    conn.Close();
            }
        }