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