public string UpdateBanner(BannerData bannerData) { try { //if (Helper.Encrypt("bhuvicare").Equals(lineOfBusiness.UserInfo.UserName) && Helper.Encrypt("BhuviCare@004").Equals(lineOfBusiness.UserInfo.Password)) //{ Business business = new Business(); return business.UpdateBanner(bannerData); //} //return "Invalid Credentials"; } catch (Exception ex) { return ex.Message; } }
public List<BannerData> BannerData() { List<BannerData> lstMSNews = new List<BannerData>(); using (DataSet ds = dataAccess.GetBannerData()) { if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { foreach (DataRow dataRow in ds.Tables[0].Rows) { BannerData bannerData = new BannerData() { NoteText = Helper.GetDbValue(dataRow["NoteText"]), Id = Helper.ConvertToInt(dataRow["Id"]), ButtonLink = Helper.GetDbValue(dataRow["ButtonLink"]), ImageUrl = Helper.GetDbValue(dataRow["ImageUrl"]), }; lstMSNews.Add(bannerData); } } } return lstMSNews; }
public void UpdateUpdateBannerLob(BannerData bannerData) { int maxId; string query = string.Empty; switch (bannerData.Action.ToUpper()) { case "I": maxId = GetMaxId("tblBannerImages", "Id") + 1; query = "INSERT INTO [tblBannerImages]([Id],[ImageUrl],[NoteText],[ButtonLink])VALUES(" + maxId + ",'" + bannerData.ImageUrl + "','" + bannerData.NoteText + "','" + bannerData.ButtonLink + "');"; break; case "U": query = "UPDATE [tblBannerImages] SET ImageUrl = '" + bannerData.ImageUrl + "',NoteText='" + bannerData.NoteText + "',ButtonLink='" + bannerData.ButtonLink + "' WHERE Id =" + bannerData.Id; break; case "D": query = "DELETE [tblBannerImages] WHERE Id = " + bannerData.Id; break; default: break; } ExecuteNonQuery(query); }
public string UpdateBanner(BannerData bannerData) { try { dataAccess.UpdateUpdateBannerLob(bannerData); return "OK"; } catch (Exception ex) { throw ex; } }