public List <Budget_NewsAndUpdate> SelectAll() { List <Budget_NewsAndUpdate> NewsAndUpdateList = null; try { string sSQL = "SELECT * FROM NewsAndUpdate Order By Seq"; DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL); if (ds.Tables[0].Rows.Count > 0) { NewsAndUpdateList = new List <Budget_NewsAndUpdate>(); Budget_NewsAndUpdate news = null; List <Details> detailList = null; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { news = new Budget_NewsAndUpdate(); news.NewsOID = new Guid(ds.Tables[0].Rows[i]["NewsOID"].ToString()); news.Enable = Convert.ToBoolean(ds.Tables[0].Rows[i]["Enable"].ToString()); news.Seq = Convert.ToInt32(ds.Tables[0].Rows[i]["Seq"].ToString()); news.FileName = ds.Tables[0].Rows[i]["FileName"].ToString(); news.BannerFileName = ds.Tables[0].Rows[i]["BannerFileName"].ToString(); //news.Title = ds.Tables[0].Rows[i]["Title"].ToString(); //news.ShortDes = ds.Tables[0].Rows[i]["ShortDes"].ToString(); //news.Descriptions = ds.Tables[0].Rows[i]["Descriptions"].ToString(); news.imageFileName1 = ds.Tables[0].Rows[i]["imageFileName1"].ToString(); news.imageFileName2 = ds.Tables[0].Rows[i]["imageFileName2"].ToString(); news.imageFileName3 = ds.Tables[0].Rows[i]["imageFileName3"].ToString(); news.imageFileName4 = ds.Tables[0].Rows[i]["imageFileName4"].ToString(); news.imageFileName5 = ds.Tables[0].Rows[i]["imageFileName5"].ToString(); news.imageFileName6 = ds.Tables[0].Rows[i]["imageFileName6"].ToString(); news.imageFileName7 = ds.Tables[0].Rows[i]["imageFileName7"].ToString(); news.imageFileName8 = ds.Tables[0].Rows[i]["imageFileName8"].ToString(); news.imageFileName9 = ds.Tables[0].Rows[i]["imageFileName9"].ToString(); news.imageFileName10 = ds.Tables[0].Rows[i]["imageFileName10"].ToString(); news.imageFileName11 = ds.Tables[0].Rows[i]["imageFileName11"].ToString(); news.imageFileName12 = ds.Tables[0].Rows[i]["imageFileName12"].ToString(); news.imageFileName13 = ds.Tables[0].Rows[i]["imageFileName13"].ToString(); news.imageFileName14 = ds.Tables[0].Rows[i]["imageFileName14"].ToString(); news.imageFileName15 = ds.Tables[0].Rows[i]["imageFileName15"].ToString(); if (ds.Tables[0].Rows[i]["StartDate"].Equals(DBNull.Value) == false) { news.StartDate = Convert.ToDateTime(ds.Tables[0].Rows[i]["StartDate"]); } detailList = getDetails(news.NewsOID); if (detailList != null) { news.NewsAndUpdateDetails = new List <Details>(); news.NewsAndUpdateDetails = detailList; } NewsAndUpdateList.Add(news); } } } catch (Exception ex) { } return(NewsAndUpdateList); }
public Budget_NewsAndUpdate SelectByOID(Guid guidNewsOID) { Budget_NewsAndUpdate news = null; try { string sSQL = "SELECT * FROM NewsAndUpdate WHERE NewsOID=@NewsOID"; SqlParameter[] sqlParam = new SqlParameter[1]; sqlParam[0] = new SqlParameter("@NewsOID", SqlDbType.UniqueIdentifier); sqlParam[0].Value = guidNewsOID; DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL, sqlParam); if (ds.Tables[0].Rows.Count > 0) { List <Details> detailList = null; news = new Budget_NewsAndUpdate(); news.NewsOID = new Guid(ds.Tables[0].Rows[0]["NewsOID"].ToString()); news.Enable = Convert.ToBoolean(ds.Tables[0].Rows[0]["Enable"].ToString()); news.Seq = Convert.ToInt32(ds.Tables[0].Rows[0]["Seq"].ToString()); news.FileName = ds.Tables[0].Rows[0]["FileName"].ToString(); news.BannerFileName = ds.Tables[0].Rows[0]["BannerFileName"].ToString(); //news.Title = ds.Tables[0].Rows[0]["Title"].ToString(); //news.ShortDes = ds.Tables[0].Rows[0]["ShortDes"].ToString(); //news.Descriptions = ds.Tables[0].Rows[0]["Descriptions"].ToString(); news.imageFileName1 = ds.Tables[0].Rows[0]["imageFileName1"].ToString(); news.imageFileName2 = ds.Tables[0].Rows[0]["imageFileName2"].ToString(); news.imageFileName3 = ds.Tables[0].Rows[0]["imageFileName3"].ToString(); news.imageFileName4 = ds.Tables[0].Rows[0]["imageFileName4"].ToString(); news.imageFileName5 = ds.Tables[0].Rows[0]["imageFileName5"].ToString(); news.imageFileName6 = ds.Tables[0].Rows[0]["imageFileName6"].ToString(); news.imageFileName7 = ds.Tables[0].Rows[0]["imageFileName7"].ToString(); news.imageFileName8 = ds.Tables[0].Rows[0]["imageFileName8"].ToString(); news.imageFileName9 = ds.Tables[0].Rows[0]["imageFileName9"].ToString(); news.imageFileName10 = ds.Tables[0].Rows[0]["imageFileName10"].ToString(); news.imageFileName11 = ds.Tables[0].Rows[0]["imageFileName11"].ToString(); news.imageFileName12 = ds.Tables[0].Rows[0]["imageFileName12"].ToString(); news.imageFileName13 = ds.Tables[0].Rows[0]["imageFileName13"].ToString(); news.imageFileName14 = ds.Tables[0].Rows[0]["imageFileName14"].ToString(); news.imageFileName15 = ds.Tables[0].Rows[0]["imageFileName15"].ToString(); if (ds.Tables[0].Rows[0]["StartDate"].Equals(DBNull.Value) == false) { news.StartDate = Convert.ToDateTime(ds.Tables[0].Rows[0]["StartDate"]); } detailList = getDetails(news.NewsOID); if (detailList != null) { news.NewsAndUpdateDetails = new List <Details>(); news.NewsAndUpdateDetails = detailList; } } } catch (Exception ex) { } return(news); }