Esempio n. 1
0
        public LibraryClassification GetLibraryClassThree(int classId, string userID)
        {
            LibraryClassification retVal = new LibraryClassification();
            MySqlConnection       con    = new MySqlConnection(DbCon.connectionString);
            string          sqlInsert    = "SELECT `id`, `classoneid`, `classtwoid`, `code`, `title`, `active` FROM `libraryclassthree` WHERE `id` = @classId ";
            MySqlDataReader dr           = null;
            MySqlCommand    cmd;

            con.Open();
            cmd = new MySqlCommand(sqlInsert, con);
            cmd.Parameters.AddWithValue("@classId", classId);
            dr = cmd.ExecuteReader();

            while (dr.Read()) //iterate through the records in the result dataset
            {
                LibraryClassification Mod = new LibraryClassification();
                Mod.ID         = dr.GetInt32(0);
                Mod.IDclassOne = dr.GetInt32(1);
                Mod.IDclassTwo = dr.GetInt32(2);
                Mod.CodeStack  = dr.GetString(3);
                Mod.TitleStack = dr.GetString(4) + " ( " + dr.GetString(3) + " )";
                Mod.Active     = dr.GetInt32(5);
                //retVal.Add(Mod);
            }


            con.Close();

            return(retVal);
        }
Esempio n. 2
0
        public List <LibraryClassification> GetAllLibraryClassification(string userID)
        {
            List <LibraryClassification> retVal = new List <LibraryClassification>();
            MySqlConnection con       = new MySqlConnection(DbCon.connectionString);
            string          sqlInsert = "SELECT libraryclassone.id,libraryclassone.`code`,libraryclassone.title,libraryclasstwo.id,libraryclasstwo.`code`,libraryclasstwo.title,libraryclassthree.id,libraryclassthree.`code`,libraryclassthree.title FROM libraryclassone INNER JOIN libraryclasstwo ON libraryclassone.id = libraryclasstwo.classoneid INNER JOIN libraryclassthree ON libraryclasstwo.id = libraryclassthree.classtwoid WHERE libraryclassone.active = 1 AND libraryclasstwo.active = 1 AND libraryclassthree.active = 1 ORDER BY libraryclassone.id ";
            MySqlDataReader dr        = null;
            MySqlCommand    cmd;

            con.Open();
            cmd = new MySqlCommand(sqlInsert, con);
            //cmd.Parameters.AddWithValue("@active", Active);
            dr = cmd.ExecuteReader();

            while (dr.Read()) //iterate through the records in the result dataset
            {
                LibraryClassification Mod = new LibraryClassification();
                Mod.ID           = dr.GetInt32(0);
                Mod.CodeBlock    = dr.GetString(1);
                Mod.TitleBlock   = dr.GetString(2) + " ( " + dr.GetString(1) + " )";
                Mod.IDclassTwo   = dr.GetInt32(3);
                Mod.CodeShelve   = dr.GetString(4);
                Mod.TitleShelve  = dr.GetString(5) + " ( " + dr.GetString(4) + " )";
                Mod.IDclassThree = dr.GetInt32(6);
                Mod.CodeStack    = dr.GetString(7);
                Mod.TitleStack   = dr.GetString(8) + " ( " + dr.GetString(7) + " )";
                retVal.Add(Mod);
            }


            con.Close();

            return(retVal);
        }
Esempio n. 3
0
        public List <LibraryClassification> GetAllLibraryClassTwo(int Active, string userID)
        {
            List <LibraryClassification> retVal = new List <LibraryClassification>();
            MySqlConnection con       = new MySqlConnection(DbCon.connectionString);
            string          sqlInsert = "SELECT `id`, `classoneid`, `code`, `title`, `active` FROM `libraryclasstwo` WHERE `active` = @active ";
            MySqlDataReader dr        = null;
            MySqlCommand    cmd;

            con.Open();
            cmd = new MySqlCommand(sqlInsert, con);
            cmd.Parameters.AddWithValue("@active", Active);
            dr = cmd.ExecuteReader();

            while (dr.Read()) //iterate through the records in the result dataset
            {
                LibraryClassification Mod = new LibraryClassification();
                Mod.ID          = dr.GetInt32(0);
                Mod.IDclassOne  = dr.GetInt32(1);
                Mod.CodeShelve  = dr.GetString(2);
                Mod.TitleShelve = dr.GetString(3) + " ( " + dr.GetString(2) + " )";
                Mod.Active      = dr.GetInt32(4);
                retVal.Add(Mod);
            }


            con.Close();

            return(retVal);
        }