예제 #1
0
        public static List <Subjects> GetAll()
        {
            List <Subjects> subjects = new List <Subjects>();
            // 1) Create the connection
            SqlConnection connection = new SqlConnection();

            connection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["SqlConnection"].ConnectionString;

            // 2) Open the connection
            connection.Open();

            // 3) Execute query
            SqlCommand command = new SqlCommand();

            command.Connection  = connection;
            command.CommandText = string.Format("select * from subjects");

            SqlDataReader dataReader = command.ExecuteReader();

            while (dataReader.Read())
            {
                Subjects subject = new Subjects();

                subject.Id       = Convert.ToInt32(dataReader["Id"]);
                subject.Name     = Convert.ToString(dataReader["Name"]);
                subject.BranchId = Convert.ToInt32(dataReader["BranchId"]);
                subject.Branch   = BranchDA.GetSingle(subject.BranchId);
                subjects.Add(subject);
            }
            // 4) Close the connection
            connection.Close();


            return(subjects);
        }
예제 #2
0
        public static Subjects GetSingle(int Id)
        {
            Subjects subjects = null;
            // 1) Create the connection
            SqlConnection connection = new SqlConnection();

            connection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["SqlConnection"].ConnectionString;

            // 2) Open the connection
            connection.Open();

            // 3) Execute query
            SqlCommand command = new SqlCommand();

            command.Connection  = connection;
            command.CommandText = string.Format("select * from subjects where id = '{0}'", Id);

            SqlDataReader dataReader = command.ExecuteReader();

            if (dataReader.Read())
            {
                subjects = new Subjects();

                subjects.Id       = Convert.ToInt32(dataReader["Id"]);
                subjects.Name     = Convert.ToString(dataReader["Name"]);
                subjects.BranchId = Convert.ToInt32(dataReader["BranchId"]);

                subjects.Branch = BranchDA.GetSingle(subjects.BranchId);
            }

            // 4) Close the connection
            connection.Close();

            return(subjects);
        }