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