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);
}
