private void btnNextCustID_Click(object sender, System.EventArgs args) { DialogResult dialogResult = EpiMessageBox.Show("Are you sure you want to get next Cust ID?", "Cancel", MessageBoxButtons.YesNo); if ((dialogResult == DialogResult.Yes)) { this.custAdapter = new CustomerAdapter(this.oTrans); this.custAdapter.BOConnect(); DataRow currentCustomer = this.custDataView.CurrentDataRow; // Add Prefix string custID = formatNewID(currentCustomer["Name"].ToString()); // Set Suffix int custSuffix = 0; // 001 // Iterate until suffix exists with prefix do { custSuffix++; try { this.custAdapter.GetByCustID(custID + custSuffix.ToString("D3"), false); }catch (Exception e) { break; } } while(custSuffix < 1000); // Set new custID string newCustID = custID + custSuffix.ToString("D3"); //MessageBox.Show("New CustID: " + newCustID); currentCustomer["CustID"] = newCustID; /*et_newCustID = ((EpiTextBox)csm.GetNativeControlReference("3a3fffc1-6dee-4be0-b52e-7fc5f80e7b95")); * et_newCustID.Text = newCustID;*/ } }
private void CustCnt_AfterFieldChange(object sender, DataColumnChangeEventArgs args) { // ** Argument Properties and Uses ** // args.Row["FieldName"] // args.Column, args.ProposedValue, args.Row // Add Event Handler Code EpiDataView edvCustomer = ((EpiDataView)(this.oTrans.EpiDataViews["Customer"])); System.Data.DataRow edvCustomerRow = edvCustomer.CurrentDataRow; string custID = edvCustomerRow["CustID"].ToString(); CustomerAdapter custAdapter = new CustomerAdapter(this.oTrans); custAdapter.BOConnect(); custAdapter.GetByCustID(custID, false); DataRow row = custAdapter.CustomerData.Customer[0]; int primB = int.Parse(row["PrimBCon"].ToString()); int primP = int.Parse(row["PrimPCon"].ToString()); int primS = int.Parse(row["PrimSCon"].ToString()); string leadType = ""; bool warning = false; switch (args.Column.ColumnName) { case "PrimaryBilling": if (primB != 0 && args.ProposedValue.ToString() == "True") { warning = true; leadType = "billing"; } break; case "PrimaryPurchasing": if (primP != 0 && args.ProposedValue.ToString() == "True") { warning = true; leadType = "purchasing"; } break; case "PrimaryShipping": if (primS != 0 && args.ProposedValue.ToString() == "True") { warning = true; leadType = "shipping"; } break; } if (warning) { DialogResult dialogResult = EpiMessageBox.Show("There exists another contact for " + leadType + "\nContinue?", "Cancel", MessageBoxButtons.YesNo); if ((dialogResult == DialogResult.No)) { oTrans.Undo(); } } }
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()); } } } } }
private void buttonCopy_Click(object sender, System.EventArgs args) { txtCopyPart = ((EpiTextBox)csm.GetNativeControlReference("d74c3905-a49e-42f4-a48d-e2a6a8b79379")); txtCopyRev = ((EpiTextBox)csm.GetNativeControlReference("31cbeabb-4107-4626-ae5d-66897b75a8d8")); this.partRevView = ((EpiDataView)(this.oTrans.EpiDataViews["PartRev"])); DataRow dataRowPartRev = this.partRevView.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 attributes?", "Cancel", MessageBoxButtons.YesNo); if ((dialogResult == DialogResult.Yes)) { try { this.partRevAdapter = new PartRevSearchAdapter(this.oTrans); this.partRevAdapter.BOConnect(); this.partRevAdapter.GetByID(txtCopyPart.Text, txtCopyRev.Text, ""); DataRow dataRow = this.partRevAdapter.PartRevSearchData.PartRev.Rows[0]; if (this.partRevAdapter.PartRevSearchData.PartRev.Count > 0) { dataRowPartRev["Height_c"] = dataRow["Height_c"]; dataRowPartRev["Width_c"] = dataRow["Width_c"]; dataRowPartRev["Depth_c"] = dataRow["Depth_c"]; dataRowPartRev["Weight_c"] = dataRow["Weight_c"]; dataRowPartRev["PrimaryMaterial_c"] = dataRow["PrimaryMaterial_c"]; dataRowPartRev["Color_c"] = dataRow["Color_c"]; dataRowPartRev["WeightCap_c"] = dataRow["WeightCap_c"]; dataRowPartRev["InstallTime_c"] = dataRow["InstallTime_c"]; dataRowPartRev["ReqInstallKit_c"] = dataRow["ReqInstallKit_c"]; dataRowPartRev["UsedWith_c"] = dataRow["UsedWith_c"]; dataRowPartRev["MaxLadderLength_c"] = dataRow["MaxLadderLength_c"]; dataRowPartRev["PartitionOffset_c"] = dataRow["PartitionOffset_c"]; dataRowPartRev["PartitionDoorOpening_c"] = dataRow["PartitionDoorOpening_c"]; dataRowPartRev["NumShelves_c"] = dataRow["NumShelves_c"]; dataRowPartRev["OpenShelfSpace_c"] = dataRow["OpenShelfSpace_c"]; dataRowPartRev["NumSmallBins_c"] = dataRow["NumSmallBins_c"]; dataRowPartRev["NumMediumBins_c"] = dataRow["NumMediumBins_c"]; dataRowPartRev["NumLargeBins_c"] = dataRow["NumLargeBins_c"]; dataRowPartRev["NumBottles_c"] = dataRow["NumBottles_c"]; dataRowPartRev["NumDividers_c"] = dataRow["NumDividers_c"]; dataRowPartRev["QtyBoxes_c"] = dataRow["QtyBoxes_c"]; MessageBox.Show("Completed"); this.partRevAdapter.Dispose(); } } catch (Exception e) { MessageBox.Show(e.ToString()); } } } } }