public void DeleteChild(string vBrand, string vVehicle, string vYear, string vLength, string vHeight) { try { EpiDataView edvPartRev = ((EpiDataView)(this.oTrans.EpiDataViews["PartRev"])); System.Data.DataRow edvPartRevRow = edvPartRev.CurrentDataRow; if ((edvPartRevRow != null)) { string vPartNum = edvPartRevRow["PartNum"].ToString(); string vRevisionNum = edvPartRevRow["RevisionNum"].ToString(); //MessageBox.Show("vPartNum: " + vPartNum + " vRevisionNum: " + vRevisionNum); UD100Adapter ud100AdapterN = new UD100Adapter(PartForm); ud100AdapterN.BOConnect(); ud100AdapterN.GetByID(vBrand, vVehicle, vYear, vLength, vHeight); DataRow[] drsDeleted = ud100AdapterN.UD100Data.UD100A.Select("ChildKey1 = \'" + vPartNum + "\' and ChildKey2 = \'" + vRevisionNum + "\'"); for (int i = 0; (i < drsDeleted.Length); i = (i + 1)) { ud100AdapterN.Delete(drsDeleted[i]); } ud100AdapterN.Update(); ud100AdapterN.Dispose(); FillVehicleGrid(vPartNum, vRevisionNum); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void btnCopyVehicles_Click(object sender, System.EventArgs args) { txtCopyPart = ((EpiTextBox)csm.GetNativeControlReference("d74c3905-a49e-42f4-a48d-e2a6a8b79379")); txtCopyRev = ((EpiTextBox)csm.GetNativeControlReference("31cbeabb-4107-4626-ae5d-66897b75a8d8")); EpiDataView epiViewPartRev = ((EpiDataView)(this.oTrans.EpiDataViews["PartRev"])); DataRow dataRowPartRev = epiViewPartRev.CurrentDataRow; string partNum; string revisionNum; if ((dataRowPartRev != null)) { partNum = dataRowPartRev["PartNum"].ToString(); revisionNum = dataRowPartRev["RevisionNum"].ToString(); if (txtCopyPart.Text == partNum && txtCopyRev.Text == revisionNum) { MessageBox.Show("Cannot copy from same Part Revision"); } else if (txtCopyPart.Text == "" || txtCopyRev.Text == "") { MessageBox.Show("Choose a Part Revision"); } else { DialogResult dialogResult = EpiMessageBox.Show("Are you sure you want to copy vehicles?", "Cancel", MessageBoxButtons.YesNo); if ((dialogResult == DialogResult.Yes)) { try { // Set UD100Adapter UD100Adapter ud100Adapter = new UD100Adapter(PartForm); ud100Adapter.BOConnect(); Hashtable whereClauses = new Hashtable(1); string whereClause = "ChildKey1 <> '' AND ChildKey2 <> ''"; whereClauses.Add("UD100A", whereClause); SearchOptions searchOptions = SearchOptions.CreateRuntimeSearch(whereClauses, DataSetMode.RowsDataSet); ud100Adapter.InvokeSearch(searchOptions); // Delete all current PartRev's vehicles DataRow[] deleteRows = ud100Adapter.UD100Data.UD100A.Select("ChildKey1 = \'" + partNum + "\' and ChildKey2 = \'" + revisionNum + "\'"); for (int i = 0; (i < deleteRows.Length); i++) { ud100Adapter.Delete(deleteRows[i]); } // Copy all selected PartRev's vehicles DataRow[] copyRows = ud100Adapter.UD100Data.UD100A.Select("ChildKey1 = \'" + txtCopyPart.Text + "\' and ChildKey2 = \'" + txtCopyRev.Text + "\'"); for (int i = 0; (i < copyRows.Length); i++) { CreateChild(copyRows[i]["Brand_c"].ToString(), copyRows[i]["Model_c"].ToString(), copyRows[i]["Year_c"].ToString(), copyRows[i]["Length_c"].ToString(), copyRows[i]["Height_c"].ToString()); } ud100Adapter.Update(); ud100Adapter.Dispose(); MessageBox.Show("Completed"); } catch (Exception e) { MessageBox.Show(e.ToString()); } } } } }