Example #1
0
        private void btnOk_Click(object sender, EventArgs e)
        {
            if (!Utils.IsValidGuid(cboxAnalMethods.SelectedValue))
            {
                MessageBox.Show("Analysis method is mandatory");
                return;
            }

            if (String.IsNullOrEmpty(tbCount.Text.Trim()))
            {
                MessageBox.Show("Count is mandatory");
                return;
            }

            int count = Convert.ToInt32(tbCount.Text.Trim());

            if (count == 0)
            {
                MessageBox.Show("Count can not be zero");
                return;
            }

            SqlConnection  connection  = null;
            SqlTransaction transaction = null;

            try
            {
                connection  = DB.OpenConnection();
                transaction = connection.BeginTransaction();

                int nextAnalNumber = DB.GetNextAnalysisNumber(connection, transaction, mPrep.Id);

                SqlCommand cmd = new SqlCommand("csp_insert_analysis", connection, transaction);
                cmd.CommandType = CommandType.StoredProcedure;

                while (count > 0)
                {
                    Guid newAnalId = Guid.NewGuid();
                    cmd.Parameters.Clear();
                    cmd.Parameters.AddWithValue("@id", newAnalId);
                    cmd.Parameters.AddWithValue("@number", nextAnalNumber++);
                    cmd.Parameters.AddWithValue("@assignment_id", DBNull.Value);
                    cmd.Parameters.AddWithValue("@laboratory_id", Common.LabId, Guid.Empty);
                    cmd.Parameters.AddWithValue("@preparation_id", mPrep.Id);
                    cmd.Parameters.AddWithValue("@analysis_method_id", cboxAnalMethods.SelectedValue, Guid.Empty);
                    cmd.Parameters.AddWithValue("@workflow_status_id", 1);
                    cmd.Parameters.AddWithValue("@specter_reference", DBNull.Value);
                    cmd.Parameters.AddWithValue("@activity_unit_id", DBNull.Value);
                    cmd.Parameters.AddWithValue("@activity_unit_type_id", DBNull.Value);
                    cmd.Parameters.AddWithValue("@sigma_act", 0d);
                    cmd.Parameters.AddWithValue("@sigma_mda", 0d);
                    cmd.Parameters.AddWithValue("@nuclide_library", DBNull.Value);
                    cmd.Parameters.AddWithValue("@mda_library", DBNull.Value);
                    cmd.Parameters.AddWithValue("@instance_status_id", InstanceStatus.Active);
                    cmd.Parameters.AddWithValue("@comment", DBNull.Value);
                    cmd.Parameters.AddWithValue("@create_date", DateTime.Now);
                    cmd.Parameters.AddWithValue("@create_id", Common.UserId, Guid.Empty);
                    cmd.Parameters.AddWithValue("@update_date", DateTime.Now);
                    cmd.Parameters.AddWithValue("@update_id", Common.UserId, Guid.Empty);

                    cmd.ExecuteNonQuery();
                    count--;
                }

                string json = JsonConvert.SerializeObject(mSample);
                DB.AddAuditMessage(connection, transaction, "sample", mSample.Id, AuditOperationType.Update, json, "");

                transaction.Commit();

                DialogResult = DialogResult.OK;
            }
            catch (Exception ex)
            {
                transaction?.Rollback();
                Common.Log.Error(ex);
                DialogResult = DialogResult.Abort;
                MessageBox.Show(ex.Message);
            }
            finally
            {
                connection?.Close();
            }

            Close();
        }
        private void btnOk_Click(object sender, EventArgs e)
        {
            try
            {
                if (String.IsNullOrEmpty(cboxPrinters.Text))
                {
                    MessageBox.Show("You must select a printer");
                    return;
                }

                if (cboxPaperSizes.SelectedItem == null)
                {
                    MessageBox.Show("You must select a printer size");
                    return;
                }

                if (String.IsNullOrEmpty(tbCopies.Text))
                {
                    MessageBox.Show("Number of copies must be a positive number");
                    return;
                }

                int copies = Convert.ToInt32(tbCopies.Text);
                if (copies < 1)
                {
                    MessageBox.Show("Number of copies must be a positive number");
                    return;
                }

                PaperSize paperSize = cboxPaperSizes.SelectedItem as PaperSize;
                printDocument.DefaultPageSettings.Landscape = cbLandscape.Checked;
                printDocument.DefaultPageSettings.PaperSize = paperSize;

                printDocument.PrintPage += PrintDocument_PrintPage;

                string query = @"
select 
    ps.name as 'project_sub_name', 
    pm.name as 'project_main_name'    
from project_sub ps
    inner join project_main pm on pm.id = ps.project_main_id and ps.id = @psid
";

                SqlConnection conn = null;
                try
                {
                    conn = DB.OpenConnection();
                    using (SqlDataReader reader = DB.GetDataReader(conn, null, query, CommandType.Text, new SqlParameter("@psid", mProjectId)))
                    {
                        if (!reader.HasRows)
                        {
                            MessageBox.Show("No id found for sub project");
                            return;
                        }

                        reader.Read();

                        ProjectMainName = reader.GetString("project_main_name");
                        ProjectSubName  = reader.GetString("project_sub_name");

                        for (int c = 0; c < copies; c++)
                        {
                            printDocument.Print();
                        }
                    }
                }
                catch (Exception ex)
                {
                    Common.Log.Error(ex);
                    MessageBox.Show(ex.Message);
                    return;
                }
                finally
                {
                    conn?.Close();
                }

                mSettings.LabelPrinterName      = cboxPrinters.Text;
                mSettings.LabelPrinterPaperName = paperSize.PaperName;
                mSettings.LabelPrinterLandscape = cbLandscape.Checked;

                DialogResult = DialogResult.OK;
                Close();
            }
            catch (Exception ex)
            {
                Common.Log.Error(ex);
                MessageBox.Show(ex.Message);
            }
        }