public List <Budget_ContentOnPage> SelectByOID(Guid guidContentOID)
{
List <Budget_ContentOnPage> ContentOnPageList = null;
try
{
string sSQL = "SELECT * FROM ContentOnPage WHERE ContentOID=@ContentOID";
SqlParameter[] sqlParam = new SqlParameter[1];
sqlParam[0] = new SqlParameter("@ContentOID", SqlDbType.UniqueIdentifier);
sqlParam[0].Value = guidContentOID;
DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL, sqlParam);
if (ds.Tables[0].Rows.Count > 0)
{
ContentOnPageList = new List <Budget_ContentOnPage>();
Budget_ContentOnPage content = null;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
content = new Budget_ContentOnPage();
content.ContentOID = new Guid(ds.Tables[0].Rows[i]["ContentOID"].ToString());
content.Culture = ds.Tables[0].Rows[i]["Culture"].ToString();
content.CategoriesCode = ds.Tables[0].Rows[i]["ContentOnPage"].ToString();
content.ContentValue = ds.Tables[0].Rows[i]["ContentValue"].ToString();
ContentOnPageList.Add(content);
}
}
}
catch (Exception ex) { }
return(ContentOnPageList);
}
public Budget_ContentOnPage getContentOnPage(string sOnPage, string sCulture)
{
Budget_ContentOnPage content = null;
try
{
string sSQL = "SELECT * FROM ContentOnPage WHERE ContentOnPage=@ContentOnPage AND Culture=@Culture";
SqlParameter[] sqlParam = new SqlParameter[2];
sqlParam[0] = new SqlParameter("@ContentOnPage", SqlDbType.NVarChar);
sqlParam[0].Value = sOnPage;
sqlParam[1] = new SqlParameter("@Culture", SqlDbType.NVarChar);
sqlParam[1].Value = sCulture;
DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL, sqlParam);
if (ds.Tables[0].Rows.Count > 0)
{
content = new Budget_ContentOnPage();
content.ContentOID = new Guid(ds.Tables[0].Rows[0]["ContentOID"].ToString());
content.Culture = ds.Tables[0].Rows[0]["Culture"].ToString();
content.CategoriesCode = ds.Tables[0].Rows[0]["ContentOnPage"].ToString();
content.ContentValue = ds.Tables[0].Rows[0]["ContentValue"].ToString();
}
}
catch (Exception ex) { }
return(content);
}
public List <Budget_ContentOnPage> SelectAll()
{
List <Budget_ContentOnPage> ContentOnPageList = null;
try
{
string sSQL = "SELECT * FROM ContentOnPage";
DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL);
if (ds.Tables[0].Rows.Count > 0)
{
ContentOnPageList = new List <Budget_ContentOnPage>();
Budget_ContentOnPage content = null;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
content = new Budget_ContentOnPage();
content.ContentOID = new Guid(ds.Tables[0].Rows[i]["ContentOID"].ToString());
content.Culture = ds.Tables[0].Rows[i]["Culture"].ToString();
content.CategoriesCode = ds.Tables[0].Rows[i]["ContentOnPage"].ToString();
content.ContentValue = ds.Tables[0].Rows[i]["ContentValue"].ToString();
ContentOnPageList.Add(content);
}
}
}
catch (Exception ex) { }
return(ContentOnPageList);
}