public BannerImageModel GetBannerImage()
{
try
{
BannerImageModel _bannerImageModel = new BannerImageModel();
using (SqlConnection conn = new SqlConnection(ConnString))
{
using (SqlCommand cmd = new SqlCommand("SELECT TOP 1 * FROM BannerImage", conn))
{
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
_bannerImageModel.BannerID = dr["BannerID"].ToString();
_bannerImageModel.BannerImagePath = dr["BannerImage"].ToString();
}
}
}
return _bannerImageModel;
}
catch (Exception ex)
{
ErrHandler.WriteError(ex.Message);
return null;
}
}
private void GetBannerDetails()
{
try
{
BannerImageViewModel _bannerImageViewModel = new BannerImageViewModel();
BannerImageModel _bannerImageModel = new BannerImageModel();
_bannerImageModel = _bannerImageViewModel.GetBannerImage();
img_prev.Src = _bannerImageModel.BannerImagePath;
hdBanner.Value = _bannerImageModel.BannerID;
}
catch (Exception ex)
{
ErrHandler.WriteError(ex.Message);
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(@"<script language='javascript'>");
sb.Append(@"alert('Error : " + ex.Message + "')");
sb.Append(@"</script>");
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Error", sb.ToString(), false);
}
}
