private void FormNuclide_Load(object sender, EventArgs e)
{
tbProtons.KeyPress += CustomEvents.Integer_KeyPress;
tbNeutrons.KeyPress += CustomEvents.Integer_KeyPress;
tbHalflife.KeyPress += CustomEvents.Numeric_KeyPress;
SqlConnection conn = null;
try
{
conn = DB.OpenConnection();
if (p.ContainsKey("id"))
{
cboxInstanceStatus.DataSource = DB.GetIntLemmata(conn, null, "csp_select_instance_status", false);
SqlCommand cmd = new SqlCommand("csp_select_nuclide", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", p["id"]);
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (!reader.HasRows)
{
throw new Exception("Nuclide with ID " + p["id"] + " was not found");
}
reader.Read();
tbName.Text = reader.GetString("name");
tbProtons.Text = reader.GetString("protons");
tbNeutrons.Text = reader.GetString("neutrons");
cbMetaStable.Checked = reader.GetBoolean("meta_stable");
tbHalflife.Text = reader.GetDouble("half_life_year").ToString(Utils.ScientificFormat);
cboxInstanceStatus.SelectedValue = reader.GetInt32("instance_status_id");
tbComment.Text = reader.GetString("comment");
p["create_date"] = reader["create_date"];
p["create_id"] = reader["create_id"];
p["update_date"] = reader["update_date"];
p["update_id"] = reader["update_id"];
}
}
else
{
cboxInstanceStatus.DataSource = DB.GetIntLemmata(conn, null, "csp_select_instance_status", false);
cboxInstanceStatus.SelectedValue = InstanceStatus.Active;
}
}
catch (Exception ex)
{
Common.Log.Error(ex);
MessageBox.Show(ex.Message);
DialogResult = DialogResult.Abort;
Close();
}
finally
{
conn?.Close();
}
}
private void FormGeometry_Load(object sender, EventArgs e)
{
tbMinFillHeight.KeyPress += CustomEvents.Numeric_KeyPress;
tbMaxFillHeight.KeyPress += CustomEvents.Numeric_KeyPress;
tbVolume.KeyPress += CustomEvents.Numeric_KeyPress;
tbRadius.KeyPress += CustomEvents.Numeric_KeyPress;
SqlConnection conn = null;
try
{
conn = DB.OpenConnection();
if (p.ContainsKey("id"))
{
cboxInstanceStatus.DataSource = DB.GetIntLemmata(conn, null, "csp_select_instance_status", false);
SqlCommand cmd = new SqlCommand("csp_select_preparation_geometry", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", p["id"]);
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (!reader.HasRows)
{
throw new Exception("Geometry with ID " + p["id"] + " was not found");
}
reader.Read();
tbName.Text = reader.GetString("name");
tbMinFillHeight.Text = reader.GetDouble("min_fill_height_mm").ToString();
tbMaxFillHeight.Text = reader.GetDouble("max_fill_height_mm").ToString();
cboxInstanceStatus.SelectedValue = reader.GetInt32("instance_status_id");
tbComment.Text = reader.GetString("comment");
tbVolume.Text = reader.GetString("volume_l");
tbRadius.Text = reader.GetString("radius_mm");
p["create_date"] = reader.GetDateTime("create_date");
p["create_id"] = reader.GetGuid("create_id");
p["update_date"] = reader.GetDateTime("update_date");
p["update_id"] = reader.GetGuid("update_id");
}
}
else
{
cboxInstanceStatus.DataSource = DB.GetIntLemmata(conn, null, "csp_select_instance_status", false);
cboxInstanceStatus.SelectedValue = InstanceStatus.Active;
}
}
catch (Exception ex)
{
Common.Log.Error(ex);
MessageBox.Show(ex.Message);
DialogResult = DialogResult.Abort;
Close();
}
finally
{
conn?.Close();
}
}
private void FormMunicipality_Load(object sender, EventArgs e)
{
tbNumber.KeyPress += CustomEvents.Integer_KeyPress;
SqlConnection conn = null;
try
{
conn = DB.OpenConnection();
if (p.ContainsKey("id"))
{
cboxInstanceStatus.DataSource = DB.GetIntLemmata(conn, null, "csp_select_instance_status", false);
SqlCommand cmd = new SqlCommand("select name from county where id = @id", conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@id", p["county_id"]);
tbCounty.Text = cmd.ExecuteScalar().ToString();
cmd.CommandText = "csp_select_municipality";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@id", p["id"]);
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (!reader.HasRows)
{
throw new Exception("Municipality with ID " + p["id"] + " was not found");
}
reader.Read();
tbName.Text = reader.GetString("name");
tbNumber.Text = reader.GetString("municipality_number");
cboxInstanceStatus.SelectedValue = reader.GetInt32("instance_status_id");
p["create_date"] = reader["create_date"];
p["create_id"] = reader["create_id"];
p["update_date"] = reader["update_date"];
p["update_id"] = reader["update_id"];
}
}
else
{
cboxInstanceStatus.DataSource = DB.GetIntLemmata(conn, null, "csp_select_instance_status", false);
cboxInstanceStatus.SelectedValue = InstanceStatus.Active;
}
}
catch (Exception ex)
{
Common.Log.Error(ex);
MessageBox.Show(ex.Message);
DialogResult = DialogResult.Abort;
Close();
}
finally
{
conn?.Close();
}
}
private void FormSampler_Load(object sender, EventArgs e)
{
SqlConnection conn = null;
try
{
conn = DB.OpenConnection();
if (p.ContainsKey("id"))
{
UI.PopulateComboBoxes(conn, "csp_select_persons_short", new SqlParameter[] { }, cboxPersons);
UI.PopulateComboBoxes(conn, "csp_select_companies_short", new[] {
new SqlParameter("instance_status_level", InstanceStatus.Active)
}, cboxCompanies);
cboxInstanceStatus.DataSource = DB.GetIntLemmata(conn, null, "csp_select_instance_status", false);
SqlCommand cmd = new SqlCommand("csp_select_sampler", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", p["id"]);
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (!reader.HasRows)
{
Common.Log.Error("Sampler with ID " + p["id"] + " was not found");
MessageBox.Show("Sampler with ID " + p["id"] + " was not found");
Close();
}
reader.Read();
cboxPersons.SelectedValue = reader.GetGuid("person_id");
cboxCompanies.SelectedValue = reader.GetGuid("company_id");
cboxInstanceStatus.SelectedValue = reader.GetInt32("instance_status_id");
tbComment.Text = reader.GetString("comment");
p["create_date"] = reader["create_date"];
p["create_id"] = reader["create_id"];
p["update_date"] = reader["update_date"];
p["update_id"] = reader["update_id"];
cboxPersons.Enabled = false;
}
}
}
catch (Exception ex)
{
Common.Log.Error(ex);
MessageBox.Show(ex.Message);
DialogResult = DialogResult.Abort;
Close();
}
finally
{
conn?.Close();
}
}
private void FormPreparationMethod_Load(object sender, EventArgs e)
{
SqlConnection conn = null;
try
{
conn = DB.OpenConnection();
if (p.ContainsKey("id"))
{
cboxInstanceStatus.DataSource = DB.GetIntLemmata(conn, null, "csp_select_instance_status", false);
SqlCommand cmd = new SqlCommand("csp_select_preparation_method", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", p["id"]);
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (!reader.HasRows)
{
throw new Exception("Preparation method with ID " + p["id"] + " was not found");
}
reader.Read();
tbName.Text = reader.GetString("name");
tbShortName.Text = reader.GetString("name_short");
tbDescriptionLink.Text = reader.GetString("description_link");
cbDestructive.Checked = reader.GetBoolean("destructive");
cboxInstanceStatus.SelectedValue = reader.GetInt32("instance_status_id");
tbComment.Text = reader.GetString("comment");
p["create_date"] = reader["create_date"];
p["create_id"] = reader["create_id"];
p["update_date"] = reader["update_date"];
p["update_id"] = reader["update_id"];
}
}
else
{
cboxInstanceStatus.DataSource = DB.GetIntLemmata(conn, null, "csp_select_instance_status", false);
cboxInstanceStatus.SelectedValue = InstanceStatus.Active;
}
}
catch (Exception ex)
{
Common.Log.Error(ex);
MessageBox.Show(ex.Message);
DialogResult = DialogResult.Abort;
Close();
}
finally
{
conn?.Close();
}
}
private void FormCompany_Load(object sender, EventArgs e)
{
SqlConnection conn = null;
try
{
conn = DB.OpenConnection();
if (p.ContainsKey("id"))
{
cboxInstanceStatus.DataSource = DB.GetIntLemmata(conn, null, "csp_select_instance_status", false);
SqlCommand cmd = new SqlCommand("csp_select_company", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", p["id"]);
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (!reader.HasRows)
{
throw new Exception("Company with ID " + p["id"] + " was not found");
}
reader.Read();
tbName.Text = reader.GetString("name");
tbEmail.Text = reader.GetString("email");
tbPhone.Text = reader.GetString("phone");
tbAddress.Text = reader.GetString("address");
cboxInstanceStatus.SelectedValue = reader.GetInt32("instance_status_id");
tbComment.Text = reader.GetString("comment");
p["create_date"] = reader.GetDateTime("create_date");
p["create_id"] = reader.GetGuid("create_id");
p["update_date"] = reader.GetDateTime("update_date");
p["update_id"] = reader.GetGuid("update_id");
}
}
else
{
cboxInstanceStatus.DataSource = DB.GetIntLemmata(conn, null, "csp_select_instance_status", false);
cboxInstanceStatus.SelectedValue = InstanceStatus.Active;
}
}
catch (Exception ex)
{
Common.Log.Error(ex);
MessageBox.Show(ex.Message);
DialogResult = DialogResult.Abort;
Close();
}
finally
{
conn?.Close();
}
}
public FormSampler()
{
InitializeComponent();
Text = "DSA-Lims - Add sampler";
using (SqlConnection conn = DB.OpenConnection())
{
UI.PopulateComboBoxes(conn, "csp_select_persons_short", new SqlParameter[] { }, cboxPersons);
UI.PopulateComboBoxes(conn, "csp_select_companies_short", new[] {
new SqlParameter("instance_status_level", InstanceStatus.Active)
}, cboxCompanies);
cboxInstanceStatus.DataSource = DB.GetIntLemmata(conn, null, "csp_select_instance_status", false);
}
cboxInstanceStatus.SelectedValue = InstanceStatus.Active;
}
private void FormUser_Load(object sender, EventArgs e)
{
SqlConnection conn = null;
try
{
conn = DB.OpenConnection();
if (p.ContainsKey("id"))
{
cboxInstanceStatus.DataSource = DB.GetIntLemmata(conn, null, "csp_select_instance_status", false);
UI.PopulateComboBoxes(conn, "csp_select_persons_short", new SqlParameter[] { }, cboxPersons);
UI.PopulateComboBoxes(conn, "csp_select_laboratories_short", new[] {
new SqlParameter("@instance_status_level", InstanceStatus.Deleted)
}, cboxLaboratory);
SqlCommand cmd = new SqlCommand("csp_select_account", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", p["id"]);
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (!reader.HasRows)
{
throw new Exception("Account with id " + p["id"] + " was not found");
}
reader.Read();
tbUsername.Text = reader.GetString("username");
cboxPersons.SelectedValue = reader.GetGuid("person_id");
cboxLaboratory.SelectedValue = reader.GetGuid("laboratory_id");
cboxLanguage.Text = reader.GetString("language_code");
cboxInstanceStatus.SelectedValue = reader.GetInt32("instance_status_id");
p["create_date"] = reader["create_date"];
p["update_date"] = reader["update_date"];
}
}
else
{
cboxInstanceStatus.DataSource = DB.GetIntLemmata(conn, null, "csp_select_instance_status", false);
UI.PopulateComboBoxes(conn, "csp_select_persons_short", new SqlParameter[] { }, cboxPersons);
UI.PopulateComboBoxes(conn, "csp_select_laboratories_short", new[] {
new SqlParameter("@instance_status_level", InstanceStatus.Inactive)
}, cboxLaboratory);
cboxInstanceStatus.SelectedValue = InstanceStatus.Active;
}
}
catch (Exception ex)
{
Common.Log.Error(ex);
MessageBox.Show(ex.Message);
DialogResult = DialogResult.Abort;
Close();
}
finally
{
conn?.Close();
}
}
private void FormLaboratory_Load(object sender, EventArgs e)
{
SqlConnection conn = null;
try
{
conn = DB.OpenConnection();
if (p.ContainsKey("id"))
{
cboxInstanceStatus.DataSource = DB.GetIntLemmata(conn, null, "csp_select_instance_status", false);
SqlCommand cmd = new SqlCommand("csp_select_laboratory", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", p["id"]);
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (!reader.HasRows)
{
throw new Exception("Laboratory with ID " + p["id"] + " was not found");
}
reader.Read();
tbName.Text = reader.GetString("name");
tbPrefix.Text = reader.GetString("name_prefix");
tbAddress.Text = reader.GetString("address");
tbEmail.Text = reader.GetString("email");
tbPhone.Text = reader.GetString("phone");
cboxInstanceStatus.SelectedValue = reader.GetInt32("instance_status_id");
tbComment.Text = reader.GetString("comment");
if (DB.IsValidField(reader["laboratory_logo"]))
{
p["laboratory_logo"] = (byte[])reader["laboratory_logo"];
picLaboratoryLogo.Image = Image.FromStream(new MemoryStream((byte[])p["laboratory_logo"]));
lblLaboratoryLogoSize.Text = picLaboratoryLogo.Image.Width.ToString() + " x " + picLaboratoryLogo.Image.Height.ToString();
}
else
{
p["laboratory_logo"] = picLaboratoryLogo.Image = null;
}
if (DB.IsValidField(reader["accredited_logo"]))
{
p["accredited_logo"] = (byte[])reader["accredited_logo"];
picAccreditedLogo.Image = Image.FromStream(new MemoryStream((byte[])p["accredited_logo"]));
lblAccreditedLogoSize.Text = picAccreditedLogo.Image.Width.ToString() + " x " + picAccreditedLogo.Image.Height.ToString();
}
else
{
p["accredited_logo"] = picAccreditedLogo.Image = null;
}
p["assignment_counter"] = reader.GetInt32("assignment_counter");
p["create_date"] = reader.GetDateTime("create_date");
p["create_id"] = reader.GetGuid("create_id");
p["update_date"] = reader.GetDateTime("update_date");
p["update_id"] = reader.GetGuid("update_id");
}
}
else
{
cboxInstanceStatus.DataSource = DB.GetIntLemmata(conn, null, "csp_select_instance_status", false);
cboxInstanceStatus.SelectedValue = InstanceStatus.Active;
}
}
catch (Exception ex)
{
Common.Log.Error(ex);
MessageBox.Show(ex.Message);
DialogResult = DialogResult.Abort;
Close();
}
finally
{
conn?.Close();
}
}
private void FormStation_Load(object sender, EventArgs e)
{
tbAltitude.KeyPress += CustomEvents.Numeric_KeyPress;
string NL = Environment.NewLine;
ttCoords.SetToolTip(lblLatitude, "Latitude, Longitude" + NL + NL
+ "Formats: " + NL + "61° 34' 12\" N 11° 67' 20\" E" + NL + "61° 34" + Utils.NumberSeparator + "23' N 11° 67" + Utils.NumberSeparator + "33' E"
+ NL + "61" + Utils.NumberSeparator + "543478 N 11" + Utils.NumberSeparator + "776344 E" + NL + "61" + Utils.NumberSeparator + "543478 -11" + Utils.NumberSeparator + "776344" + NL + NL + "° can be replaced with *");
ttCoords.SetToolTip(lblLongitude, "Latitude, Longitude" + NL + NL
+ "Formats: " + NL + "61° 34' 12\" N 11° 67' 20\" E" + NL + "61° 34" + Utils.NumberSeparator + "23' N 11° 67" + Utils.NumberSeparator + "33' E"
+ NL + "61" + Utils.NumberSeparator + "543478 N 11" + Utils.NumberSeparator + "776344 E" + NL + "61" + Utils.NumberSeparator + "543478 -11" + Utils.NumberSeparator + "776344" + NL + NL + "° can be replaced with *");
SqlConnection conn = null;
try
{
conn = DB.OpenConnection();
if (p.ContainsKey("id"))
{
cboxInstanceStatus.DataSource = DB.GetIntLemmata(conn, null, "csp_select_instance_status", false);
SqlCommand cmd = new SqlCommand("csp_select_station", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", p["id"]);
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (!reader.HasRows)
{
throw new Exception("Station with ID " + p["id"] + " was not found");
}
reader.Read();
tbName.Text = reader.GetString("name");
tbLatitude.Text = reader.GetString("latitude");
tbLongitude.Text = reader.GetString("longitude");
tbAltitude.Text = reader.GetString("altitude");
cboxInstanceStatus.SelectedValue = reader.GetInt32("instance_status_id");
tbComment.Text = reader.GetString("comment");
p["create_date"] = reader["create_date"];
p["create_id"] = reader["create_id"];
p["update_date"] = reader["update_date"];
p["update_id"] = reader["update_id"];
}
}
else
{
cboxInstanceStatus.DataSource = DB.GetIntLemmata(conn, null, "csp_select_instance_status", false);
cboxInstanceStatus.SelectedValue = InstanceStatus.Active;
}
}
catch (Exception ex)
{
Common.Log.Error(ex);
MessageBox.Show(ex.Message);
DialogResult = DialogResult.Abort;
Close();
}
finally
{
conn?.Close();
}
}
