private void cboxSampleParameterNames_SelectedIndexChanged(object sender, EventArgs e) { tbSampleParameterValue.Text = ""; if (cboxSampleParameterNames.SelectedItem == null) { return; } tbSampleParameterValue.KeyPress -= CustomEvents.Integer_KeyPress; tbSampleParameterValue.KeyPress -= CustomEvents.Numeric_KeyPress; SampleParameterName spn = cboxSampleParameterNames.SelectedItem as SampleParameterName; switch (spn.Type) { case SampleParameterType.Integer: tbSampleParameterValue.KeyPress += CustomEvents.Integer_KeyPress; break; case SampleParameterType.Decimal: tbSampleParameterValue.KeyPress += CustomEvents.Numeric_KeyPress; break; } lblTypeInfo.Text = "Parameter type: " + spn.Type; }
private void FormSampleParameter_Load(object sender, EventArgs e) { lblTypeInfo.Text = ""; SampleParameterName spn = new SampleParameterName(); spn.Id = Guid.Empty; spn.Name = ""; spn.Type = ""; cboxSampleParameterNames.Items.Add(spn); SqlConnection conn = null; try { conn = DB.OpenConnection(); SqlDataReader reader = DB.GetDataReader(conn, null, "select id, name, type from sample_parameter_name order by name", CommandType.Text); while (reader.Read()) { spn = new SampleParameterName(); spn.Id = reader.GetGuid("id"); spn.Name = reader.GetString("name"); spn.Type = reader.GetString("type"); cboxSampleParameterNames.Items.Add(spn); } } catch (Exception ex) { Common.Log.Error(ex); MessageBox.Show(ex.Message); DialogResult = DialogResult.Abort; Close(); } finally { conn?.Close(); } cboxSampleParameterNames.DisplayMember = "Name"; cboxSampleParameterNames.ValueMember = "Id"; if (mSPId != Guid.Empty) { SampleParameter p = mSample.Parameters.Find(x => x.Id == mSPId); cboxSampleParameterNames.Text = p.Name; cboxSampleParameterNames.Enabled = false; tbSampleParameterValue.Text = p.Value; lblTypeInfo.Text = "Parameter type: " + p.Type; } }
private void btnOk_Click(object sender, EventArgs e) { SampleParameterName spn = cboxSampleParameterNames.SelectedItem as SampleParameterName; if (spn.Id == Guid.Empty) { MessageBox.Show("You must select a valid parameter type"); return; } if (string.IsNullOrEmpty(tbSampleParameterValue.Text.Trim())) { MessageBox.Show("You must provide a value for this parameter"); return; } if (mSPId == Guid.Empty) { if (mSample.Parameters.Exists(x => x.SampleId == mSample.Id && x.SampleParameterNameId == spn.Id)) { MessageBox.Show("This sample already have this parameter"); return; } SampleParameter p = new SampleParameter(); p.SampleId = mSample.Id; p.SampleParameterNameId = spn.Id; p.Name = spn.Name; p.Type = spn.Type; p.Value = tbSampleParameterValue.Text.ToString(); mSample.Parameters.Add(p); p.Dirty = true; } else { SampleParameter p = mSample.Parameters.Find(x => x.Id == mSPId); p.Value = tbSampleParameterValue.Text.ToString(); p.Dirty = true; } DialogResult = DialogResult.OK; Close(); }