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