public static MatherialType create(string name) { string sql = "insert into \"Matherial_type\"(\"name\") values ('" + name + "') returning *"; NpgsqlDataReader reader = new NpgsqlCommand(sql, DBConnection.getConnection()).ExecuteReader(); reader.Read(); MatherialType newOne = new MatherialType(reader.GetInt32(0), name); CommonElements.MatherialTypes.Add(newOne); return(newOne); }
private static void InitMatherialTypes() { MatherialTypes = MatherialType.getMatherialTypes(); MatherialTypes.Insert(0, new MatherialType(-1, "--Все типы--")); }