Ejemplo n.º 1
0
        /*
         #####################################################################
         # Q6
         #              existsIn._STORECODE
         #              existsIn._ITEMCODE
         #              existsIn._QUANTITY
         #####################################################################
         */
        public static List <Exists_In> FindRunnuingOutItems()
        {
            List <Exists_In> existIns = new List <Exists_In>();
            Exists_In        existsIn;

            if (Connect())
            {
                using (SqlCommand sqlCommand = new SqlCommand("Q6", _Connection))
                {
                    sqlCommand.CommandType = CommandType.StoredProcedure;
                    sqlCommand.CommandText = "sp_FindRunnuingOutItems";

                    SqlDataReader reader;
                    try
                    {
                        reader = sqlCommand.ExecuteReader();
                    }
                    catch (Exception ex)
                    {
                        return(null);
                    }
                    while (reader.Read())
                    {
                        existsIn            = new Exists_In();
                        existsIn._STORECODE = Convert.ToInt32(reader[0]);
                        existsIn._ITEMCODE  = Convert.ToInt32(reader[1]);
                        existsIn._QUANTITY  = Convert.ToInt32(reader[2]);
                        existIns.Add(existsIn);
                    }
                    reader.Close();
                }
            }

            return(existIns);
        }
Ejemplo n.º 2
0
        /*
         #####################################################################
         # Q6
         #              existsIn._STORECODE
         #              existsIn._ITEMCODE
         #              existsIn._QUANTITY
         #####################################################################
         */
        public static List <Exists_In> FindRunnuingOutItems()
        {
            string Q6Query = " select STORECODE, ITEMCODE, QUANTITY  from EXISTS_IN " +
                             " where QUANTITY < 5 " +
                             " order by STORECODE asc, quantity asc, ITEMCODE asc  ";

            List <Exists_In> existIns = new List <Exists_In>();
            Exists_In        existsIn;

            if (Connect())
            {
                //we are going to call query called Q6
                using (SqlCommand sqlCommand = new SqlCommand())
                {
                    sqlCommand.CommandType = CommandType.Text;
                    sqlCommand.CommandText = Q6Query;
                    sqlCommand.Connection  = _Connection;
                    SqlDataReader reader;
                    try
                    {
                        reader = sqlCommand.ExecuteReader();
                    }
                    catch (Exception ex)
                    {
                        return(null);
                    }
                    //Converting query results to PersonPhoneAddress objects
                    while (reader.Read())
                    {
                        existsIn = new Exists_In();

                        existsIn._STORECODE = Convert.ToInt32(reader[0]);
                        existsIn._ITEMCODE  = Convert.ToInt32(reader[1]);

                        existsIn._QUANTITY = Convert.ToInt32(reader[2]);

                        existIns.Add(existsIn);
                    }
                    reader.Close();
                }
            }


            return(existIns);
        }