예제 #1
0
        public List <SubletImage> GetSubletImages(string SubId)
        {
            SqlConnection      con = null;
            List <SubletImage> sil = new List <SubletImage>();

            try
            {
                con = connect("ConnectionStringName"); // create a connection to the database using the connection String defined in the web config file

                String     selectSTR = "SELECT * FROM SubImgTbl WHERE " + SubId + ";";
                SqlCommand cmd       = new SqlCommand(selectSTR, con);

                // get a reader
                SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); // CommandBehavior.CloseConnection: the connection will be closed after reading has reached the end

                while (dr.Read())
                {   // Read till the end of the data into a row
                    SubletImage si = new SubletImage();
                    si.SubletID   = Convert.ToInt32(dr["SubletID"]);
                    si.ImagePath1 = (string)dr["ImgPath1"];
                    si.ImagePath2 = (string)dr["ImgPath2"];
                    si.ImagePath3 = (string)dr["ImgPath3"];
                    si.ImagePath4 = (string)dr["ImgPath4"];
                    si.ImagePath5 = (string)dr["ImgPath5"];
                    sil.Add(si);
                }

                return(sil);
            }
            catch (Exception ex)
            {
                // write to log
                throw (ex);
            }
            finally
            {
                if (con != null)
                {
                    con.Close();
                }
            }
        }
예제 #2
0
        // GET api/<controller>/5
        public List <SubletImage> Get(string SubId)
        {
            SubletImage sl = new SubletImage();

            return(sl.GetSubletImages(SubId));
        }