public static bool EditLaw(Laws law, int id)
{
string conString = WebConfigurationManager.ConnectionStrings["FrozenCrittersDb"].ConnectionString;
SqlConnection con = new SqlConnection(conString);
SqlCommand addnews = new SqlCommand();
addnews.Connection = con;
addnews.CommandText = "UPDATE Laws SET LawsTitle = @LawsTitle, LawsLink = @LawsLink WHERE LawsId = " + id;
con.Open();
addnews.Parameters.AddWithValue("@LawsTitle", law.LawsTitle);
addnews.Parameters.AddWithValue("@LawsLink", law.LawsLink);
try
{
con.Open();
int rows = addnews.ExecuteNonQuery();
if (rows == 0)
{
return(true);
}
else
{
return(false);
}
}
finally
{
con.Dispose();
}
}
public static bool AddLaw(Laws law)
{
string conString = WebConfigurationManager.ConnectionStrings["FrozenCrittersDb"].ConnectionString;
SqlConnection con = new SqlConnection(conString);
SqlCommand addnews = new SqlCommand();
addnews.Connection = con;
addnews.CommandText = "INSERT INTO Laws (LawsTitle, LawsLink) VALUES(@LawsTitle, @LawsLink)";
addnews.Parameters.AddWithValue("@LawsTitle", law.LawsTitle);
addnews.Parameters.AddWithValue("@LawsLink", law.LawsLink);
try
{
con.Open();
int rows = addnews.ExecuteNonQuery();
if (rows == 0)
{
return(true);
}
else
{
return(false);
}
}
finally
{
con.Dispose();
}
}
public static Laws GetLaw(int id)
{
string conString = WebConfigurationManager.ConnectionStrings["FrozenCrittersDb"].ConnectionString;
SqlConnection con = new SqlConnection(conString);
SqlCommand getlaw = new SqlCommand();
getlaw.Connection = con;
getlaw.CommandText = "SELECT LawsId, LawsTitle, LawsLink FROM laws WHERE LawsId = " + id;
con.Open();
SqlDataReader reader = getlaw.ExecuteReader();
Laws law = new Laws();
while (reader.Read())
{
law.LawsId = (int)reader["LawsId"];
law.LawsTitle = reader["LawsTitle"].ToString();
law.LawsLink = reader["LawsLink"].ToString();
}
con.Close();
return(law);
}
public static List <Laws> GetLaws()
{
string conString = WebConfigurationManager.ConnectionStrings["FrozenCrittersDb"].ConnectionString;
SqlConnection con = new SqlConnection(conString);
SqlCommand getNews = new SqlCommand();
getNews.Connection = con;
getNews.CommandText = "SELECT * FROM Laws";
con.Open();
SqlDataReader reader = getNews.ExecuteReader();
var laws = new List <Laws>();
while (reader.Read())
{
Laws law = new Laws();
law.LawsId = (int)reader["LawsId"];
law.LawsTitle = reader["LawsTitle"].ToString();
law.LawsLink = reader["LawsLink"].ToString();
laws.Add(law);
}
con.Close();
return(laws);
}