public static BE.HomePage[] SelectAll()
{
ArrayList homePages = new ArrayList();
BE.HomePage homePage;
string SQLQuery = "SELECT * FROM [HomePage] ";
SqlCommand command = new SqlCommand();
command.CommandText = SQLQuery;
SqlDataReader reader = SQLHelper.ExecuteReader(command);
while (reader.Read())
{
homePage = new BE.HomePage();
homePage.Id = Convert.ToInt32(reader["Id"]);
homePage.Title = Convert.ToString(reader["Title"]);
homePage.Content = Convert.ToString(reader["Content"]);
homePage.Content1 = Convert.ToString(reader["Content1"]);
homePage.Created = Convert.ToDateTime(reader["Created"]);
homePage.CreatedBy = Convert.ToString(reader["CreatedBy"]);
homePage.Edited = Convert.ToDateTime(reader["Edited"]);
homePage.EditedBy = Convert.ToString(reader["EditedBy"]);
homePage.Publish = Convert.ToString(reader["Publish"]);
homePage.Language = Convert.ToString(reader["Language"]);
homePages.Add(homePage);
}
reader.Close();
reader.Dispose();
return((BE.HomePage[])homePages.ToArray(typeof(BE.HomePage)));
}
public static BE.HomePage Select(Int32 Id)
{
BE.HomePage homePage = new BE.HomePage();
string SQLQuery = "SELECT * FROM [HomePage] WHERE [Id]=@Id ";
SqlCommand command = new SqlCommand();
command.CommandText = SQLQuery;
command.Parameters.AddWithValue("@Id", Id);
SqlDataReader reader = SQLHelper.ExecuteReader(command);
reader.Read();
homePage.Id = Convert.ToInt32(reader["Id"]);
homePage.Title = Convert.ToString(reader["Title"]);
homePage.Content = Convert.ToString(reader["Content"]);
homePage.Content1 = Convert.ToString(reader["Content1"]);
homePage.Created = Convert.ToDateTime(reader["Created"]);
homePage.CreatedBy = Convert.ToString(reader["CreatedBy"]);
homePage.Edited = Convert.ToDateTime(reader["Edited"]);
homePage.EditedBy = Convert.ToString(reader["EditedBy"]);
homePage.Publish = Convert.ToString(reader["Publish"]);
homePage.Language = Convert.ToString(reader["Language"]);
reader.Close();
reader.Dispose();
return(homePage);
}
public static bool Update(BE.HomePage homePage)
{
string SQLQuery = "UPDATE [HomePage] SET Id = @Id, Title= @Title, Content= @Content, Content1= @Content1, Created= @Created, CreatedBy= @CreatedBy, Edited= @Edited, EditedBy= @EditedBy, Publish= @Publish, Language= @Language WHERE [Id]=@Id ";
SqlCommand command = new SqlCommand();
command.CommandText = SQLQuery;
AddParameters(command, homePage);
return(Convert.ToBoolean(SQLHelper.ExecuteNonQuery(command)));
}
public static bool Insert(BE.HomePage homePage)
{
string SQLQuery = "INSERT INTO [HomePage] ( id,title,content,content1,created,createdBy,edited,editedBy,publish,language ) VALUES (@id, @title, @content, @content1, @created, @createdBy, @edited, @editedBy, @publish, @language)";
SqlCommand command = new SqlCommand();
command.CommandText = SQLQuery;
AddParameters(command, homePage);
return(Convert.ToBoolean(SQLHelper.ExecuteNonQuery(command)));
}
private static void AddParameters(SqlCommand command, BE.HomePage homePage)
{
command.Parameters.AddWithValue("@Id", homePage.Id);
command.Parameters.AddWithValue("@Title", homePage.Title);
command.Parameters.AddWithValue("@Content", homePage.Content);
command.Parameters.AddWithValue("@Content1", homePage.Content1);
command.Parameters.AddWithValue("@Created", homePage.Created);
command.Parameters.AddWithValue("@CreatedBy", homePage.CreatedBy);
command.Parameters.AddWithValue("@Edited", homePage.Edited);
command.Parameters.AddWithValue("@EditedBy", homePage.EditedBy);
command.Parameters.AddWithValue("@Publish", homePage.Publish);
command.Parameters.AddWithValue("@Language", homePage.Language);
}
public static bool Save(BE.HomePage homePage)
{
bool IsAffected = false;
if (homePage.State == BE.RowState.Added)
{
IsAffected = Insert(homePage);
}
else if (homePage.State == BE.RowState.Modified)
{
IsAffected = Update(homePage);
}
else if (homePage.State == BE.RowState.Deleted)
{
IsAffected = Delete(homePage.Id);
}
return(IsAffected);
}
