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;
}
}
