private void update <T>(IdType type, string id, UpdateOpt opt, T value) { string sql = "UPDATE Students SET " + opt.ToString() + " = @val WHERE " + type.ToString() + " = @id"; SqlCommand cmd = connection.CreateCommand(); cmd.CommandText = sql; System.Data.SqlDbType sqlDbType = System.Data.SqlDbType.Int; if (opt == UpdateOpt.CurrentTaskAnswer) { sqlDbType = System.Data.SqlDbType.Float; } cmd.Parameters.Add("@val", sqlDbType).Value = value; cmd.Parameters.Add("@id", sqlDbType).Value = id; cmd.ExecuteNonQuery(); }
public void Update(UpdateOpt opt, Action <GarterWWW> callback) // map / rename / access - public_private / owner { SendRequest(Garter.AssetsManagementType.UPDATE, Garter.I.ToJson(opt), callback); }