Example #1
0
        public void purge()
        {
            string r = "delete from img_stg where " +
                       "ID = @ID";

            sql_code.prms_p prms = new mvc.business.sql_code.prms_p();

            prms.enroll("ID", ID, System.Data.SqlDbType.VarChar
                        );

            sql_code.run_non_query(r, prms
                                   );
        }
Example #2
0
        public static img_stg_p get(string ID
                                    )

        {
            string r = "select * from img_stg " +
                       " where " +
                       "ID = @ID";

            sql_code.prms_p prms = new mvc.business.sql_code.prms_p();

            prms.enroll("ID", ID, System.Data.SqlDbType.VarChar
                        );

            SqlConnection conn = null;

            SqlDataReader SDR = sql_code.run_query(r, prms, ref conn
                                                   );

            img_stg_p ims = null;


            if (SDR.Read()
                )
            {
                ims = get(SDR);
            }

            SDR.Close();

            SDR.Dispose();

            conn.Close();

            conn.Dispose();

            return(ims);
        }