Esempio n. 1
0
        public List <TravelBlog> SelectAll(string PrefixTable)
        {
            List <TravelBlog> TravelBlogList = null;

            try
            {
                string sSQL = "SELECT * FROM ##TravelBlog";

                DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL.Replace("##", PrefixTable));
                if (ds.Tables[0].Rows.Count > 0)
                {
                    TravelBlogList = new List <TravelBlog>();
                    TravelBlog blog = null;
                    for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                    {
                        blog = new TravelBlog();
                        blog.TravelBlogOID   = new Guid(ds.Tables[0].Rows[i]["TravelBlogOID"].ToString());
                        blog.Enable          = Convert.ToBoolean(ds.Tables[0].Rows[i]["Enable"].ToString());
                        blog.Seq             = Convert.ToInt32(ds.Tables[0].Rows[i]["Seq"].ToString());
                        blog.FileName        = ds.Tables[0].Rows[i]["FileName"].ToString();
                        blog.BannerFileName  = ds.Tables[0].Rows[i]["BannerFileName"].ToString();
                        blog.Title           = ds.Tables[0].Rows[i]["Title"].ToString();
                        blog.ShortDes        = ds.Tables[0].Rows[i]["ShortDes"].ToString();
                        blog.Descriptions    = ds.Tables[0].Rows[i]["Descriptions"].ToString();
                        blog.imageFileName1  = ds.Tables[0].Rows[i]["imageFileName1"].ToString();
                        blog.imageFileName2  = ds.Tables[0].Rows[i]["imageFileName2"].ToString();
                        blog.imageFileName3  = ds.Tables[0].Rows[i]["imageFileName3"].ToString();
                        blog.imageFileName4  = ds.Tables[0].Rows[i]["imageFileName4"].ToString();
                        blog.imageFileName5  = ds.Tables[0].Rows[i]["imageFileName5"].ToString();
                        blog.imageFileName6  = ds.Tables[0].Rows[i]["imageFileName6"].ToString();
                        blog.imageFileName7  = ds.Tables[0].Rows[i]["imageFileName7"].ToString();
                        blog.imageFileName8  = ds.Tables[0].Rows[i]["imageFileName8"].ToString();
                        blog.imageFileName9  = ds.Tables[0].Rows[i]["imageFileName9"].ToString();
                        blog.imageFileName10 = ds.Tables[0].Rows[i]["imageFileName10"].ToString();
                        blog.imageFileName11 = ds.Tables[0].Rows[i]["imageFileName11"].ToString();
                        blog.imageFileName12 = ds.Tables[0].Rows[i]["imageFileName12"].ToString();
                        blog.imageFileName13 = ds.Tables[0].Rows[i]["imageFileName13"].ToString();
                        blog.imageFileName14 = ds.Tables[0].Rows[i]["imageFileName14"].ToString();
                        blog.imageFileName15 = ds.Tables[0].Rows[i]["imageFileName15"].ToString();
                        blog.Latitude_From   = ds.Tables[0].Rows[i]["Latitude_From"].ToString();
                        blog.Latitude_To     = ds.Tables[0].Rows[i]["Latitude_To"].ToString();
                        blog.Longitude_From  = ds.Tables[0].Rows[i]["Longitude_From"].ToString();
                        blog.Longitude_To    = ds.Tables[0].Rows[i]["Longitude_To"].ToString();
                        TravelBlogList.Add(blog);
                    }
                }
            }
            catch (Exception ex) { }
            return(TravelBlogList);
        }
Esempio n. 2
0
        public TravelBlog SelectByOID(string PrefixTable, Guid guidTravelBlogOID)
        {
            TravelBlog blog = null;

            try
            {
                string         sSQL     = "SELECT * FROM ##TravelBlog WHERE TravelBlogOID=@TravelBlogOID";
                SqlParameter[] sqlParam = new SqlParameter[1];
                sqlParam[0]       = new SqlParameter("@TravelBlogOID", SqlDbType.UniqueIdentifier);
                sqlParam[0].Value = guidTravelBlogOID;
                DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL.Replace("##", PrefixTable), sqlParam);
                if (ds.Tables[0].Rows.Count > 0)
                {
                    blog = new TravelBlog();
                    blog.TravelBlogOID   = new Guid(ds.Tables[0].Rows[0]["TravelBlogOID"].ToString());
                    blog.Enable          = Convert.ToBoolean(ds.Tables[0].Rows[0]["Enable"].ToString());
                    blog.Seq             = Convert.ToInt32(ds.Tables[0].Rows[0]["Seq"].ToString());
                    blog.FileName        = ds.Tables[0].Rows[0]["FileName"].ToString();
                    blog.BannerFileName  = ds.Tables[0].Rows[0]["BannerFileName"].ToString();
                    blog.Title           = ds.Tables[0].Rows[0]["Title"].ToString();
                    blog.ShortDes        = ds.Tables[0].Rows[0]["ShortDes"].ToString();
                    blog.Descriptions    = ds.Tables[0].Rows[0]["Descriptions"].ToString();
                    blog.imageFileName1  = ds.Tables[0].Rows[0]["imageFileName1"].ToString();
                    blog.imageFileName2  = ds.Tables[0].Rows[0]["imageFileName2"].ToString();
                    blog.imageFileName3  = ds.Tables[0].Rows[0]["imageFileName3"].ToString();
                    blog.imageFileName4  = ds.Tables[0].Rows[0]["imageFileName4"].ToString();
                    blog.imageFileName5  = ds.Tables[0].Rows[0]["imageFileName5"].ToString();
                    blog.imageFileName6  = ds.Tables[0].Rows[0]["imageFileName6"].ToString();
                    blog.imageFileName7  = ds.Tables[0].Rows[0]["imageFileName7"].ToString();
                    blog.imageFileName8  = ds.Tables[0].Rows[0]["imageFileName8"].ToString();
                    blog.imageFileName9  = ds.Tables[0].Rows[0]["imageFileName9"].ToString();
                    blog.imageFileName10 = ds.Tables[0].Rows[0]["imageFileName10"].ToString();
                    blog.imageFileName11 = ds.Tables[0].Rows[0]["imageFileName11"].ToString();
                    blog.imageFileName12 = ds.Tables[0].Rows[0]["imageFileName12"].ToString();
                    blog.imageFileName13 = ds.Tables[0].Rows[0]["imageFileName13"].ToString();
                    blog.imageFileName14 = ds.Tables[0].Rows[0]["imageFileName14"].ToString();
                    blog.imageFileName15 = ds.Tables[0].Rows[0]["imageFileName15"].ToString();
                    blog.Latitude_From   = ds.Tables[0].Rows[0]["Latitude_From"].ToString();
                    blog.Latitude_To     = ds.Tables[0].Rows[0]["Latitude_To"].ToString();
                    blog.Longitude_From  = ds.Tables[0].Rows[0]["Longitude_From"].ToString();
                    blog.Longitude_To    = ds.Tables[0].Rows[0]["Longitude_To"].ToString();
                }
            }
            catch (Exception ex) { }
            return(blog);
        }