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