public static bool Delete(DbConfigItem item) { bool result = false; using (StoredProcedure sp = new StoredProcedure("DbConfig_DeleteItem")) { sp.Params.Add("@Name", System.Data.SqlDbType.NVarChar, 255).Value = item.Name; result = sp.ExecuteNonQuery() > 0; } return result; }
public static DbConfigItem GetByID(string id) { DbConfigItem item = null; using (StoredProcedure sp = new StoredProcedure("DbConfig_GetByID")) { sp.Params.Add("@Name", System.Data.SqlDbType.NVarChar,255).Value = id; using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader()) { if (r != null && r.Read()) { item = new DbConfigItem(); item.Name = Convert.ToString(r["Name"]); item.Value = Convert.ToString(r["Value"]); item.DateCreated = Convert.ToDateTime(r["DateCreated"]); } } } return item; }
public static List<DbConfigItem> GetAll() { List<DbConfigItem> all = new List<DbConfigItem>(); using (StoredProcedure sp = new StoredProcedure("DbConfig_GetAll")) { using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader()) { if (r != null) { while (r.Read()) { DbConfigItem item = new DbConfigItem(); item.Name = Convert.ToString(r["Name"]); item.Value = Convert.ToString(r["Value"]); item.DateCreated = Convert.ToDateTime(r["DateCreated"]); all.Add(item); } } } } return all; }
public static bool Save(DbConfigItem item) { if (item == null) throw new ArgumentNullException("item"); return Save(item.Name, item.Value); }