protected static void Delete(string table, int id) { string query = "DELETE FROM " + table + " WHERE id = @id"; SqlDataReader rdr = DBHandler.DatabaseOperation(query, new SqlParameter("@id", id)); DBHandler.DatabaseCleanup(rdr, _conn); }
protected static void DeleteAll(string table) { string query = "DELETE FROM " + table; SqlDataReader rdr = DBHandler.DatabaseOperation(query); DBHandler.DatabaseCleanup(rdr, _conn); }
protected static Object GetObjectFromDB(string table, string query, Func <SqlDataReader, Object> MakeObject, SqlParameter parameter = null) { query = "SELECT * FROM " + table + " " + query; SqlDataReader rdr = DBHandler.DatabaseOperation(query, parameter); Object output = null; while (rdr.Read()) { output = MakeObject(rdr); } DBHandler.DatabaseCleanup(rdr, _conn); return(output); }
protected static List <Object> GetAll(string table, Func <SqlDataReader, Object> MakeObject) { List <Object> output = new List <Object>() { }; string query = "SELECT * FROM " + table + ""; SqlDataReader rdr = DBHandler.DatabaseOperation(query); while (rdr.Read()) { output.Add(MakeObject(rdr)); } DBHandler.DatabaseCleanup(rdr, _conn); return(output); }
protected int Save(string table, List <string> columns, List <SqlParameter> parameters, int id = 0) { string query = ""; if (id == 0) { string col = "("; string val = "("; foreach (string item in columns) { col += item + ", "; val += "@" + item + ", "; } col = col.Substring(0, col.Length - 2) + ")"; val = val.Substring(0, val.Length - 2) + ")"; query = "INSERT INTO " + table + " " + col + " OUTPUT INSERTED.id VALUES " + val + ";"; } else { string update = ""; foreach (string item in columns) { update += item + "=@" + item + ", "; } update = update.Substring(0, update.Length - 2); query = "UPDATE " + table + " SET " + update + " WHERE id = @id"; parameters.Add(new SqlParameter("@id", id)); } SqlDataReader rdr = DBHandler.DatabaseOperation(query, parameters); while (rdr.Read() && id == 0) { id = rdr.GetInt32(0); } DBHandler.DatabaseCleanup(rdr, _conn); return(id); }