public static BE.Links[] SelectAll()
{
ArrayList linkss = new ArrayList();
BE.Links links;
string SQLQuery = "SELECT * FROM [Links] ";
SqlCommand command = new SqlCommand();
command.CommandText = SQLQuery;
SqlDataReader reader = SQLHelper.ExecuteReader(command);
while (reader.Read())
{
links = new BE.Links();
links.ID = Convert.ToInt32(reader["ID"]);
links.UrlText = Convert.ToString(reader["UrlText"]);
links.Url = Convert.ToString(reader["Url"]);
links.Publish = Convert.ToString(reader["Publish"]);
linkss.Add(links);
}
reader.Close();
reader.Dispose();
return((BE.Links[])linkss.ToArray(typeof(BE.Links)));
}
private static void AddParameters(SqlCommand command, BE.Links links)
{
command.Parameters.AddWithValue("@ID", links.ID);
command.Parameters.AddWithValue("@UrlText", links.UrlText);
command.Parameters.AddWithValue("@Url", links.Url);
command.Parameters.AddWithValue("@Publish", links.Publish);
}
public static bool Update(BE.Links links)
{
string SQLQuery = "UPDATE [Links] SET ID = @ID, UrlText= @UrlText, Url= @Url, Publish= @Publish WHERE [Id]=@Id ";
SqlCommand command = new SqlCommand();
command.CommandText = SQLQuery;
AddParameters(command, links);
return(Convert.ToBoolean(SQLHelper.ExecuteNonQuery(command)));
}
public static bool Insert(BE.Links links)
{
string SQLQuery = "INSERT INTO [Links] ( iD,urlText,url,publish ) VALUES (@iD, @urlText, @url, @publish)";
SqlCommand command = new SqlCommand();
command.CommandText = SQLQuery;
AddParameters(command, links);
return(Convert.ToBoolean(SQLHelper.ExecuteNonQuery(command)));
}
public static bool Save(BE.Links links)
{
bool IsAffected = false;
if (links.State == BE.RowState.Added)
{
IsAffected = Insert(links);
}
else if (links.State == BE.RowState.Modified)
{
IsAffected = Update(links);
}
else if (links.State == BE.RowState.Deleted)
{
IsAffected = Delete(links.ID);
}
return(IsAffected);
}
public static BE.Links Select(Int32 Id)
{
BE.Links links = new BE.Links();
string SQLQuery = "SELECT * FROM [Links] WHERE [Id]=@Id ";
SqlCommand command = new SqlCommand();
command.CommandText = SQLQuery;
command.Parameters.AddWithValue("@Id", Id);
SqlDataReader reader = SQLHelper.ExecuteReader(command);
reader.Read();
links.ID = Convert.ToInt32(reader["ID"]);
links.UrlText = Convert.ToString(reader["UrlText"]);
links.Url = Convert.ToString(reader["Url"]);
links.Publish = Convert.ToString(reader["Publish"]);
reader.Close();
reader.Dispose();
return(links);
}
