internal static void NewInspection(Guid sectionID) { string str = "SELECT * FROM Inspection_Data WHERE [INSP_DATA_INSP_DATE]>=#" + Conversions.ToString(DateAndTime.DateAdd(DateInterval.Day, (double)checked (-1 * Inspection.IInspectionWindow), DateAndTime.Today)) + "# AND [INSP_DATA_SEC_ID]={" + sectionID.ToString() + "}"; DataTable dataTable1 = mdUtility.DB.GetDataTable(str); DataTable dataTable2 = mdUtility.DB.GetDataTable("SELECT * FROM [Section Info] WHERE [sec_id]={" + sectionID.ToString() + "}"); DateTime dateTime = new frmDatePicker().ShowDialog(new DateTime?(DateAndTime.DateAdd(DateInterval.Day, (double)checked (-1 * Inspection.IInspectionWindow), DateAndTime.Today)), new DateTime?(DateAndTime.Today)); Guid guid; if (dataTable1.Rows.Count == 0) { DataRow row = dataTable1.NewRow(); DataRow dataRow = row; dataRow["INSP_DATA_SEC_ID"] = (object)sectionID; guid = Guid.Parse(mdUtility.GetUniqueID()); dataRow["INSP_DATA_ID"] = (object)guid; dataRow["inspectorlink"] = (object)mdUtility.strCurrentInspector; dataRow["INSP_Source"] = (object)nameof(Inspection); dataRow["INSP_DATA_INSP_DATE"] = (object)dateTime; dataRow["INSP_DATA_SAMP"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(Microsoft.VisualBasic.CompilerServices.Operators.CompareString(mdUtility.fMainForm.CurrentLocation, "", false) == 0, (object)false, (object)true)); dataRow["bred_status"] = (object)"N"; dataRow["insp_data_type"] = (object)2; dataTable1.Rows.Add(row); mdUtility.DB.SaveDataTable(ref dataTable1, str); Section.SectionMaterialLink(sectionID.ToString()); mdUtility.fMainForm.m_bInspNew = true; } else { object obj = dataTable1.Rows[0]["INSP_DATA_ID"]; guid = obj != null ? (Guid)obj : new Guid(); } DataTable dataTable3 = mdUtility.DB.GetDataTable("SELECT SUM(SAMP_DATA_QTY) AS SAMP_QTY_SUM FROM Sample_Data WHERE [SAMP_DATA_INSP_DATA_ID]={" + guid.ToString() + "}"); DataTable tableSchema = mdUtility.DB.GetTableSchema("Sample_Data"); DataRow row1 = tableSchema.NewRow(); DataRow dataRow1 = row1; dataRow1["BRED_Status"] = (object)"N"; dataRow1["samp_data_id"] = (object)mdUtility.GetUniqueID(); dataRow1["samp_data_insp_data_id"] = (object)guid; double num = Conversions.ToDouble(Microsoft.VisualBasic.CompilerServices.Operators.SubtractObject(dataTable2.Rows[0]["sec_qty"], UtilityFunctions.FixDBNull(RuntimeHelpers.GetObjectValue(dataTable3.Rows[0]["SAMP_QTY_SUM"]), (object)0))); dataRow1["samp_data_qty"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(num < 0.0, (object)0, (object)num)); dataRow1["samp_data_paint"] = RuntimeHelpers.GetObjectValue(dataTable2.Rows[0]["sec_paint"]); if (mdUtility.fMainForm.tvInspection.Visible && Microsoft.VisualBasic.CompilerServices.Operators.CompareString(mdUtility.fMainForm.CurrentLocation, "", false) != 0) { dataRow1["samp_data_loc"] = (object)mdUtility.fMainForm.tvInspection.GetNodeByKey(mdUtility.fMainForm.CurrentLocation).Tag.ToString(); } tableSchema.Rows.Add(row1); mdUtility.DB.SaveDataTable(ref tableSchema, "SELECT * FROM Sample_Data"); mdUtility.fMainForm.m_bSampleNew = true; mdUtility.fMainForm.m_bInspLoaded = false; Inspection.LoadInspectionDates(sectionID.ToString()); mdUtility.fMainForm.m_bInspLoaded = true; mdUtility.fMainForm.SetInspChanged(true); if (!mdUtility.fMainForm.txtSQuantity.Visible) { return; } mdUtility.fMainForm.txtSQuantity.Focus(); }
internal static void CopyInspection(string InspectionID) { DateTime dateTime = DateAndTime.DateAdd(DateInterval.Day, (double)checked (-1 * Inspection.IInspectionWindow), DateAndTime.Today); DataTable dataTable1 = mdUtility.DB.GetDataTable("SELECT * FROM Inspection_Data WHERE [insp_data_id]={" + InspectionID + "}"); if (dataTable1.Rows.Count <= 0) { throw new Exception("Unable to find the source inspection record."); } DataTable dataTable2 = mdUtility.DB.GetDataTable("SELECT * FROM Inspection_Data WHERE [INSP_DATA_INSP_DATE]>=#" + Conversions.ToString(dateTime) + "# AND [INSP_DATA_SEC_ID]={" + dataTable1.Rows[0]["insp_data_sec_id"].ToString() + "}"); bool flag; string uniqueId1; if (dataTable2.Rows.Count == 0) { flag = false; DataRow drDest = dataTable2.NewRow(); Inspection.CopyDataRow(dataTable1.Rows[0], ref drDest); DataRow dataRow = drDest; dataRow["bred_status"] = (object)"N"; uniqueId1 = mdUtility.GetUniqueID(); dataRow["insp_data_id"] = (object)uniqueId1; dataRow["insp_data_insp_date"] = (object)DateAndTime.Today; dataRow["InspectorLink"] = (object)mdUtility.strCurrentInspector; dataRow["INSP_Source"] = (object)nameof(Inspection); dataTable2.Rows.Add(drDest); mdUtility.DB.SaveDataTable(ref dataTable2, "SELECT * FROM Inspection_Data"); mdUtility.fMainForm.m_bInspNew = true; } else { flag = true; uniqueId1 = Conversions.ToString(dataTable2.Rows[0]["insp_data_id"]); } string sSQL; if (flag) { sSQL = "SELECT * FROM Sample_Data WHERE [samp_data_insp_data_id]={" + InspectionID + "} AND [samp_data_id]={" + Strings.Replace(Conversions.ToString(mdUtility.fMainForm.cboLocation.SelectedValue), "'", "''", 1, -1, CompareMethod.Binary) + "}"; } else { sSQL = "SELECT * FROM Sample_Data WHERE [samp_data_insp_data_id]={" + InspectionID + "}"; } DataTable dataTable3 = mdUtility.DB.GetDataTable(sSQL); DataTable tableSchema1 = mdUtility.DB.GetTableSchema("Sample_Data"); try { foreach (DataRow row1 in dataTable3.Rows) { DataRow drDest = tableSchema1.NewRow(); Inspection.CopyDataRow(row1, ref drDest); DataRow dataRow1 = drDest; dataRow1["BRED_Status"] = (object)"C"; string uniqueId2 = mdUtility.GetUniqueID(); dataRow1["samp_data_id"] = (object)uniqueId2; dataRow1["samp_data_insp_data_id"] = (object)uniqueId1; dataRow1["samp_data_comments"] = (object)DBNull.Value; tableSchema1.Rows.Add(drDest); mdUtility.DB.SaveDataTable(ref tableSchema1, "SELECT * FROM Sample_Data"); mdUtility.fMainForm.m_bSampleNew = true; if (Microsoft.VisualBasic.CompilerServices.Operators.ConditionalCompareObjectEqual(dataTable2.Rows[0]["insp_data_type"], (object)1, false)) { DataTable tableSchema2 = mdUtility.DB.GetTableSchema("Sample_Subcomponent"); DataTable dataTable4 = mdUtility.DB.GetDataTable(Conversions.ToString(Microsoft.VisualBasic.CompilerServices.Operators.ConcatenateObject(Microsoft.VisualBasic.CompilerServices.Operators.ConcatenateObject((object)"SELECT * FROM Sample_Subcomponent WHERE [samp_subcomp_samp_id]={", row1["samp_data_id"]), (object)"}"))); try { foreach (DataRow row2 in dataTable4.Rows) { drDest = tableSchema2.NewRow(); Inspection.CopyDataRow(row2, ref drDest); DataRow dataRow2 = drDest; dataRow2["BRED_Status"] = (object)"N"; string uniqueId3 = mdUtility.GetUniqueID(); dataRow2["samp_subcomp_id"] = (object)uniqueId3; dataRow2["samp_subcomp_samp_id"] = (object)uniqueId2; dataRow2["samp_subcomp_comments"] = (object)DBNull.Value; dataRow2["samp_subcomp_ci"] = (object)DBNull.Value; tableSchema2.Rows.Add(drDest); mdUtility.DB.SaveDataTable(ref tableSchema2, "SELECT * FROM Sample_Subcomponent"); DataTable tableSchema3 = mdUtility.DB.GetTableSchema("Sample_SubComp_Distress"); DataTable dataTable5 = mdUtility.DB.GetDataTable(Conversions.ToString(Microsoft.VisualBasic.CompilerServices.Operators.ConcatenateObject(Microsoft.VisualBasic.CompilerServices.Operators.ConcatenateObject((object)"SELECT * FROM Sample_SubComp_Distress WHERE [ssd_subcomp_id]={", row2["samp_subcomp_id"]), (object)"}"))); try { foreach (DataRow row3 in dataTable5.Rows) { drDest = tableSchema3.NewRow(); Inspection.CopyDataRow(row3, ref drDest); DataRow dataRow3 = drDest; dataRow3["BRED_Status"] = (object)"N"; dataRow3["ssd_id"] = (object)mdUtility.GetUniqueID(); dataRow3["ssd_subcomp_id"] = (object)uniqueId3; tableSchema3.Rows.Add(drDest); mdUtility.DB.SaveDataTable(ref tableSchema3, "SELECT * FROM Sample_SubComp_Distress"); } } finally { IEnumerator enumerator; if (enumerator is IDisposable) { (enumerator as IDisposable).Dispose(); } } } } finally { IEnumerator enumerator; if (enumerator is IDisposable) { (enumerator as IDisposable).Dispose(); } } } } } finally { IEnumerator enumerator; if (enumerator is IDisposable) { (enumerator as IDisposable).Dispose(); } } mdUtility.fMainForm.m_bInspLoaded = false; Inspection.LoadInspectionDates(dataTable2.Rows[0]["insp_data_sec_id"].ToString()); mdUtility.fMainForm.m_bInspLoaded = true; mdUtility.fMainForm.SetInspChanged(true); }