public static BE.ContactUs Select(Int32 Id) { BE.ContactUs contactUs = new BE.ContactUs(); string SQLQuery = "SELECT * FROM [ContactUs] WHERE [Id]=@Id "; SqlCommand command = new SqlCommand(); command.CommandText = SQLQuery; command.Parameters.AddWithValue("@Id", Id); SqlDataReader reader = SQLHelper.ExecuteReader(command); reader.Read(); contactUs.Id = Convert.ToInt32(reader["Id"]); contactUs.Post = Convert.ToString(reader["Post"]); contactUs.ContactName = Convert.ToString(reader["ContactName"]); contactUs.Tel = Convert.ToString(reader["Tel"]); contactUs.Fax = Convert.ToString(reader["Fax"]); contactUs.Email = Convert.ToString(reader["Email"]); contactUs.Pobox = Convert.ToString(reader["Pobox"]); contactUs.Created = Convert.ToDateTime(reader["Created"]); contactUs.Creator = Convert.ToString(reader["Creator"]); contactUs.Edited = Convert.ToDateTime(reader["Edited"]); contactUs.Editor = Convert.ToString(reader["Editor"]); contactUs.Publishing = Convert.ToString(reader["Publishing"]); contactUs.Language = Convert.ToString(reader["Language"]); reader.Close(); reader.Dispose(); return(contactUs); }
public static bool Update(BE.ContactUs contactUs) { string SQLQuery = "UPDATE [ContactUs] SET Id = @Id, Post= @Post, ContactName= @ContactName, Tel= @Tel, Fax= @Fax, Email= @Email, Pobox= @Pobox, Created= @Created, Creator= @Creator, Edited= @Edited, Editor= @Editor, Publishing= @Publishing, Language= @Language WHERE [Id]=@Id "; SqlCommand command = new SqlCommand(); command.CommandText = SQLQuery; AddParameters(command, contactUs); return(Convert.ToBoolean(SQLHelper.ExecuteNonQuery(command))); }
public static bool Insert(BE.ContactUs contactUs) { string SQLQuery = "INSERT INTO [ContactUs] ( id,post,contactName,tel,fax,email,pobox,created,creator,edited,editor,publishing,language ) VALUES (@id, @post, @contactName, @tel, @fax, @email, @pobox, @created, @creator, @edited, @editor, @publishing, @language)"; SqlCommand command = new SqlCommand(); command.CommandText = SQLQuery; AddParameters(command, contactUs); return(Convert.ToBoolean(SQLHelper.ExecuteNonQuery(command))); }
private static void AddParameters(SqlCommand command, BE.ContactUs contactUs) { command.Parameters.AddWithValue("@Id", contactUs.Id); command.Parameters.AddWithValue("@Post", contactUs.Post); command.Parameters.AddWithValue("@ContactName", contactUs.ContactName); command.Parameters.AddWithValue("@Tel", contactUs.Tel); command.Parameters.AddWithValue("@Fax", contactUs.Fax); command.Parameters.AddWithValue("@Email", contactUs.Email); command.Parameters.AddWithValue("@Pobox", contactUs.Pobox); command.Parameters.AddWithValue("@Created", contactUs.Created); command.Parameters.AddWithValue("@Creator", contactUs.Creator); command.Parameters.AddWithValue("@Edited", contactUs.Edited); command.Parameters.AddWithValue("@Editor", contactUs.Editor); command.Parameters.AddWithValue("@Publishing", contactUs.Publishing); command.Parameters.AddWithValue("@Language", contactUs.Language); }
public static bool Save(BE.ContactUs contactUs) { bool IsAffected = false; if (contactUs.State == BE.RowState.Added) { IsAffected = Insert(contactUs); } else if (contactUs.State == BE.RowState.Modified) { IsAffected = Update(contactUs); } else if (contactUs.State == BE.RowState.Deleted) { IsAffected = Delete(contactUs.Id); } return(IsAffected); }
public static BE.ContactUs[] SelectAll() { ArrayList contactUss = new ArrayList(); BE.ContactUs contactUs; string SQLQuery = "SELECT * FROM [ContactUs] "; SqlCommand command = new SqlCommand(); command.CommandText = SQLQuery; SqlDataReader reader = SQLHelper.ExecuteReader(command); while (reader.Read()) { contactUs = new BE.ContactUs(); contactUs.Id = Convert.ToInt32(reader["Id"]); contactUs.Post = Convert.ToString(reader["Post"]); contactUs.ContactName = Convert.ToString(reader["ContactName"]); contactUs.Tel = Convert.ToString(reader["Tel"]); contactUs.Fax = Convert.ToString(reader["Fax"]); contactUs.Email = Convert.ToString(reader["Email"]); contactUs.Pobox = Convert.ToString(reader["Pobox"]); contactUs.Created = Convert.ToDateTime(reader["Created"]); contactUs.Creator = Convert.ToString(reader["Creator"]); contactUs.Edited = Convert.ToDateTime(reader["Edited"]); contactUs.Editor = Convert.ToString(reader["Editor"]); contactUs.Publishing = Convert.ToString(reader["Publishing"]); contactUs.Language = Convert.ToString(reader["Language"]); contactUss.Add(contactUs); } reader.Close(); reader.Dispose(); return((BE.ContactUs[])contactUss.ToArray(typeof(BE.ContactUs))); }