public JsonResult AddBanner(string title, string subTitle, string filename) { int orderId; int id = DataProvider.InsertHomeBanner(title, subTitle, filename, out orderId); BennerGalleryItem banner = new BennerGalleryItem() { Id = id, OrderId = orderId, ImageName = filename, Title = title, SubTitle = subTitle }; string html = this.RenderPartialToString("Partials/_HomeBannerRow", banner); return Json(new { success = true, html = html }); }
public static List<BennerGalleryItem> GetBannersGallery() { List<BennerGalleryItem> banners = new List<BennerGalleryItem>(); using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[CONNECTION_STRING].ConnectionString)) { using (SqlCommand cmd = new SqlCommand("GetBannersGallery", conn)) { cmd.CommandType = CommandType.StoredProcedure; conn.Open(); using (IDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { BennerGalleryItem banner = new BennerGalleryItem() { Id = reader.GetInt32(0), OrderId = reader.GetInt32(4), Title = reader.GetString(1), SubTitle = reader.GetString(2), ImageName = reader.GetString(3) }; banners.Add(banner); } } conn.Close(); } } return banners; }