public ActionResult ChangeLinkStatus(int LinkId, bool Value) { PopularLink obj = new PopularLink(); obj = _adminRepository.GetPopularLinkById(LinkId); if (obj != null) { obj.Active = Value; } _adminRepository.UpdateLinkStatus(obj); return Json(new { Message = " Popular Link Status Changed Successfully", Success = true }); }
public ActionResult SavePopularLink(PopularLink popularlink) { if (Request.Form["PopularLinkId"] == "0") { _adminRepository.AddPopularLink(popularlink); } else { _adminRepository.UpdatePopularLink(popularlink); } PopularLinkModel obj = new PopularLinkModel(); obj.plinks = _adminRepository.GetAllPopularLinks (); return View("ManagePopularLinks", obj); }
public void UpdatePopularLink(PopularLink popularlink) { const string commandString = @"Update PopularLinks SET Active = @Active,Title =@Title, Link = @Link WHERE PopularLinkId=@PopularLinkId"; try { using (var connection = new SqlConnection(ConnectionString)) { connection.Open(); var command = new SqlCommand(commandString, connection); command.Parameters.Add("@Title", popularlink.Title ); command.Parameters.Add("@Link", popularlink.Link); command.Parameters.Add("@Active", popularlink.Active); command.Parameters.Add("@PopularLinkId", popularlink.PopularLinkId); command.ExecuteNonQuery(); } } catch (Exception ex) { throw new Exception(ex.ToString()); } }
public void AddPopularLink(PopularLink popularlink) { const string commandString = @"INSERT INTO PopularLinks (Title,Active,Link) VALUES (@Title,@Active,@Link)"; try { using (var connection = new SqlConnection(ConnectionString)) { connection.Open(); var command = new SqlCommand(commandString, connection); command.Parameters.Add("@Title", popularlink.Title); command.Parameters.Add("@Link", popularlink.Link); command.Parameters.Add("@Active", popularlink.Active); command.ExecuteNonQuery(); } } catch (Exception ex) { throw new Exception(ex.ToString()); } }
public PopularLink GetPopularLinkById(int popularlinkId) { const string commandString = @"SELECT PopularLinkId, Title, Active,Link FROM PopularLinks WHERE PopularLinkId = @PopularLinkId"; using (var connection = new SqlConnection(ConnectionString)) { connection.Open(); var command = GetCommand(commandString, connection, CommandType.Text); var obj = new PopularLink(); { command.Parameters.Add("@PopularLinkId", popularlinkId); { using (var reader = command.ExecuteReader()) { while (reader.Read()) { obj.PopularLinkId = (int)reader["PopularLinkId"]; obj.Title = (string)reader["Title"]; obj.Link = (string)reader["Link"]; obj.Active = Convert.ToBoolean(reader["Active"]); } } } } return obj; } }
public List<PopularLink> GetAllPopularLinks() { const string commandString = @"SELECT PopularLinkId, Title, Active,Link FROM PopularLinks"; using (var connection = new SqlConnection(ConnectionString)) { connection.Open(); var command = GetCommand(commandString, connection, CommandType.Text); var objlist = new List<PopularLink>(); { using (var reader = command.ExecuteReader()) { while (reader.Read()) { var obj = new PopularLink(); obj.PopularLinkId = (int)reader["PopularLinkId"]; obj.Title = (string)reader["Title"]; obj.Link = (string)reader["Link"]; obj.Active = Convert.ToBoolean(reader["Active"]); objlist.Add(obj); } } } return objlist; } }