private void btnOk_Click(object sender, EventArgs e)
{
if (!Utils.IsValidGuid(cboxComponents.SelectedValue))
{
MessageBox.Show("Sample component is required");
return;
}
if (String.IsNullOrEmpty(tbCount.Text.Trim()))
{
MessageBox.Show("Count is required");
return;
}
Guid compId = Utils.MakeGuid(cboxComponents.SelectedValue);
int count = 0;
try
{
count = Convert.ToInt32(tbCount.Text.Trim());
}
catch
{
MessageBox.Show("Invalid number format");
return;
}
if (count < 1 || count > 10000)
{
MessageBox.Show("Split count must be between 1 and 10000");
return;
}
SqlConnection conn = null;
SqlTransaction trans = null;
try
{
conn = DB.OpenConnection();
trans = conn.BeginTransaction();
DateTime currDate = DateTime.Now;
for (int i = 0; i < count; i++)
{
mNewSample.Id = Guid.NewGuid();
mNewSample.Number = DB.GetNextSampleCount(conn, trans);
mNewSample.SampleComponentId = compId;
mNewSample.TransformFromId = mOldSampleId;
mNewSample.CreateDate = currDate;
mNewSample.CreateId = Common.UserId;
mNewSample.UpdateDate = currDate;
mNewSample.UpdateId = Common.UserId;
mNewSample.StoreToDB(conn, trans);
string json = JsonConvert.SerializeObject(mNewSample);
DB.AddAuditMessage(conn, trans, "sample", mNewSample.Id, AuditOperationType.Insert, json, "");
}
trans.Commit();
}
catch (Exception ex)
{
trans?.Rollback();
Common.Log.Error(ex);
MessageBox.Show(ex.Message);
}
finally
{
conn?.Close();
}
DialogResult = DialogResult.OK;
Close();
}
private void btnCreate_Click(object sender, EventArgs e)
{
if (!Utils.IsValidGuid(cboxSampleType.SelectedValue))
{
MessageBox.Show("Sample type is mandatory");
return;
}
if (!Utils.IsValidGuid(cboxProjectMain.SelectedValue))
{
MessageBox.Show("Main project is mandatory");
return;
}
if (!Utils.IsValidGuid(cboxProjectSub.SelectedValue))
{
MessageBox.Show("Sub project is mandatory");
return;
}
if (!Utils.IsValidGuid(cboxLaboratory.SelectedValue))
{
MessageBox.Show("Laboratory is mandatory");
return;
}
SqlConnection conn = null;
SqlTransaction trans = null;
try
{
conn = DB.OpenConnection();
trans = conn.BeginTransaction();
DateTime currDate = DateTime.Now;
Sample sample = new Sample();
sample.Number = DB.GetNextSampleCount(conn, trans);
sample.LaboratoryId = Utils.MakeGuid(cboxLaboratory.SelectedValue);
sample.SampleTypeId = Utils.MakeGuid(cboxSampleType.SelectedValue);
if (Utils.IsValidGuid(cboxSampleComponent.SelectedValue))
{
sample.SampleComponentId = Utils.MakeGuid(cboxSampleComponent.SelectedValue);
}
sample.ProjectSubId = Utils.MakeGuid(cboxProjectSub.SelectedValue);
sample.InstanceStatusId = InstanceStatus.Active;
sample.CreateDate = currDate;
sample.CreateId = Common.UserId;
sample.UpdateDate = currDate;
sample.UpdateId = Common.UserId;
sample.StoreToDB(conn, trans);
string json = JsonConvert.SerializeObject(sample);
DB.AddAuditMessage(conn, trans, "sample", sample.Id, AuditOperationType.Insert, json, "");
trans.Commit();
SampleId = sample.Id;
DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
trans?.Rollback();
Common.Log.Error(ex);
MessageBox.Show(ex.Message);
DialogResult = DialogResult.Abort;
}
finally
{
conn?.Close();
}
Close();
}
private void btnOk_Click(object sender, EventArgs e)
{
if (!Utils.IsValidGuid(cboxSampleType.SelectedValue))
{
MessageBox.Show("You must select a sample type");
return;
}
Dictionary <string, object> map = new Dictionary <string, object>();
SqlConnection conn = null;
SqlTransaction trans = null;
try
{
conn = DB.OpenConnection();
trans = conn.BeginTransaction();
DateTime currDate = DateTime.Now;
Guid oldSampleId = Utils.MakeGuid(gridSamples.Rows[0].Cells["id"].Value);
Sample newSample = new Sample();
newSample.LoadFromDB(conn, trans, oldSampleId);
newSample.Id = Guid.NewGuid();
foreach (Preparation p in newSample.Preparations)
{
p.Analyses.Clear();
}
newSample.Preparations.Clear();
newSample.Parameters.Clear();
newSample.Number = DB.GetNextSampleCount(conn, trans);
newSample.ExternalId = String.IsNullOrEmpty(tbExternalId.Text.Trim()) ? String.Empty : tbExternalId.Text.Trim();
newSample.SampleTypeId = Utils.MakeGuid(cboxSampleType.SelectedValue);
if (Utils.IsValidGuid(cboxSampleComponent.SelectedValue))
{
newSample.SampleComponentId = Utils.MakeGuid(cboxSampleComponent.SelectedValue);
}
else
{
newSample.SampleComponentId = Guid.Empty;
}
newSample.TransformFromId = Guid.Empty;
newSample.MunicipalityId = Guid.Empty;
newSample.LocationType = String.Empty;
newSample.Location = String.Empty;
newSample.StationId = Guid.Empty;
newSample.SampleStorageId = Guid.Empty;
newSample.SamplerId = Guid.Empty;
newSample.SamplingMethodId = Guid.Empty;
newSample.Latitude = newSample.Longitude = newSample.Altitude = null;
newSample.InstanceStatusId = InstanceStatus.Active;
newSample.SamplingDateFrom = new DateTime(dtSamplingDate.Value.Year, dtSamplingDate.Value.Month, dtSamplingDate.Value.Day, dtSamplingTime.Value.Hour, dtSamplingTime.Value.Minute, dtSamplingTime.Value.Second);
newSample.SamplingDateTo = null;
newSample.ReferenceDate = new DateTime(dtReferenceDate.Value.Year, dtReferenceDate.Value.Month, dtReferenceDate.Value.Day, dtReferenceTime.Value.Hour, dtReferenceTime.Value.Minute, dtReferenceTime.Value.Second);
newSample.WetWeight_g = null;
newSample.DryWeight_g = null;
newSample.LodWeightStart = null;
newSample.LodWeightEnd = null;
newSample.LodTemperature = null;
newSample.LodWaterPercent = null;
newSample.LodFactor = null;
newSample.LodWeightStartAsh = null;
newSample.LodWeightEndAsh = null;
newSample.LodTemperatureAsh = null;
newSample.LodWaterPercentAsh = null;
newSample.LodFactorAsh = null;
newSample.LodWeightStartAsh2 = null;
newSample.LodWeightEndAsh2 = null;
newSample.LodTemperatureAsh2 = null;
newSample.LodWaterPercentAsh2 = null;
newSample.LodFactorAsh2 = null;
newSample.Comment = tbComment.Text.Trim();
newSample.LockedId = Guid.Empty;
newSample.CreateDate = currDate;
newSample.CreateId = Common.UserId;
newSample.UpdateDate = currDate;
newSample.UpdateId = Common.UserId;
newSample.StoreToDB(conn, trans);
string json = JsonConvert.SerializeObject(newSample);
DB.AddAuditMessage(conn, trans, "sample", newSample.Id, AuditOperationType.Insert, json, "");
SqlCommand cmd = new SqlCommand("update sample set transform_to_id = @transform_to_id where id in(" + mSampleIdsCsv + ")", conn, trans);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@transform_to_id", newSample.Id);
cmd.ExecuteNonQuery();
trans.Commit();
}
catch (Exception ex)
{
trans?.Rollback();
Common.Log.Error(ex);
MessageBox.Show(ex.Message);
return;
}
finally
{
conn?.Close();
}
DialogResult = DialogResult.OK;
Close();
}
