public Budget_BannerConfig SelectByCategoriesCode(string CategoriesCode)
{
Budget_BannerConfig banner = null;
try
{
string sSQL = @"SELECT [Categories_Banner].CategoriesCode,[Categories_Banner].CategoriesName
,[BannerConfig].BannerOID,[BannerConfig].BannerFileName,[BannerConfig].BannerURL,[BannerConfig].BannerTitle
FROM [Categories_Banner]
LEFT JOIN [BannerConfig] ON [Categories_Banner].CategoriesCode =[BannerConfig].CategoriesCode WHERE [Categories_Banner].CategoriesCode=@CategoriesCode";
SqlParameter[] sqlParam = new SqlParameter[1];
sqlParam[0] = new SqlParameter("@CategoriesCode", SqlDbType.NVarChar);
sqlParam[0].Value = CategoriesCode;
DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL, sqlParam);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
banner = new Budget_BannerConfig();
banner.CategoriesCode = ds.Tables[0].Rows[0]["CategoriesCode"].ToString();
banner.CategoriesName = ds.Tables[0].Rows[0]["CategoriesName"].ToString();
banner.BannerOID = (ds.Tables[0].Rows[0]["BannerOID"].Equals(DBNull.Value) == false) ? new Guid(ds.Tables[0].Rows[0]["BannerOID"].ToString()) : Guid.Empty;
banner.BannerFileName = (ds.Tables[0].Rows[0]["BannerFileName"].Equals(DBNull.Value) == false) ? ds.Tables[0].Rows[0]["BannerFileName"].ToString() : "";
banner.BannerURL = (ds.Tables[0].Rows[0]["BannerURL"].Equals(DBNull.Value) == false) ? ds.Tables[0].Rows[0]["BannerURL"].ToString() : "";
banner.BannerTitle = (ds.Tables[0].Rows[0]["BannerTitle"].Equals(DBNull.Value) == false) ? ds.Tables[0].Rows[0]["BannerTitle"].ToString() : "";
}
}
catch (Exception ex) { }
return(banner);
}
public List <Budget_BannerConfig> SelectAll()
{
List <Budget_BannerConfig> BannerConfigList = null;
try
{
string sSQL = @"SELECT [Categories_Banner].CategoriesCode,[Categories_Banner].CategoriesName
,[BannerConfig].BannerOID,[BannerConfig].BannerFileName,[BannerConfig].BannerURL,[BannerConfig].BannerTitle
,[ContentOnPage].*
FROM [Categories_Banner]
LEFT JOIN [BannerConfig] ON [Categories_Banner].CategoriesCode =[BannerConfig].CategoriesCode
LEFT JOIN [ContentOnPage] ON [BannerConfig].CategoriesCode = [ContentOnPage].ContentOnPage AND [ContentOnPage].Culture = 'en'";
DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL);
if (ds.Tables[0].Rows.Count > 0)
{
BannerConfigList = new List <Budget_BannerConfig>();
Budget_BannerConfig banner = new Budget_BannerConfig();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
banner = new Budget_BannerConfig();
banner.CategoriesCode = ds.Tables[0].Rows[i]["CategoriesCode"].ToString();
banner.CategoriesName = ds.Tables[0].Rows[i]["CategoriesName"].ToString();
banner.BannerOID = (ds.Tables[0].Rows[i]["BannerOID"].Equals(DBNull.Value) == false) ? new Guid(ds.Tables[0].Rows[i]["BannerOID"].ToString()) : Guid.Empty;
banner.BannerFileName = (ds.Tables[0].Rows[i]["BannerFileName"].Equals(DBNull.Value) == false) ? ds.Tables[0].Rows[i]["BannerFileName"].ToString() : "";
banner.BannerURL = (ds.Tables[0].Rows[i]["BannerURL"].Equals(DBNull.Value) == false) ? ds.Tables[0].Rows[i]["BannerURL"].ToString() : "";
banner.BannerTitle = (ds.Tables[0].Rows[i]["BannerTitle"].Equals(DBNull.Value) == false) ? ds.Tables[0].Rows[i]["BannerTitle"].ToString() : "";
banner.ContentOID = (ds.Tables[0].Rows[i]["ContentOID"].Equals(DBNull.Value) == false) ? ds.Tables[0].Rows[i]["ContentOID"].ToString() : "";
banner.ContentValue = (ds.Tables[0].Rows[i]["ContentValue"].Equals(DBNull.Value) == false) ? ds.Tables[0].Rows[i]["ContentValue"].ToString() : "";
BannerConfigList.Add(banner);
}
}
}
catch (Exception ex) { }
return(BannerConfigList);
}
