private void oTrans_adapter_BeforeAdapterMethod(object sender, BeforeAdapterMethodArgs args) { // ** Argument Properties and Uses ** // ** args.MethodName ** // ** Add Event Handler Code ** // ** Use MessageBox to find adapter method name // EpiMessageBox.Show(args.MethodName) switch (args.MethodName) { case "Update": // DialogResult dialogResult = EpiMessageBox.Show("Cancel Update?", "Cancel", MessageBoxButtons.YesNo); // if ((dialogResult == DialogResult.Yes)) // { // args.Cancel = true; // } else // { // DoSomethingElse(); // } date = ((EpiDateTimeEditor)csm.GetNativeControlReference("58b174f5-b539-42ab-8e1c-1007c7b85541")); int length = date.Text.Length; if (length == 0) { custCredView = ((EpiDataView)(this.oTrans.EpiDataViews["Customer"])); custCredView.dataView[this.custCredView.Row]["LastCreditHold_c"] = DBNull.Value; } break; } }
private void oTrans_adapter_BeforeAdapterMethod(object sender, BeforeAdapterMethodArgs args) { // ** Argument Properties and Uses ** // ** args.MethodName ** // ** Add Event Handler Code ** // ** Use MessageBox to find adapter method name // EpiMessageBox.Show(args.MethodName) switch (args.MethodName) { case "Update": // DialogResult dialogResult = EpiMessageBox.Show("Cancel Update?", "Cancel", MessageBoxButtons.YesNo); // if ((dialogResult == DialogResult.Yes)) // { // args.Cancel = true; // } else // { // DoSomethingElse(); // } if (callType.Text.ToLower().Contains("sale") && inquiryType.Text.Trim().Length == 0) { throw new UIException("Inquiry Type must be filled for new sales."); } break; } }
private void oTrans_customerAdapter_BeforeAdapterMethod(object sender, BeforeAdapterMethodArgs args) { // ** Argument Properties and Uses ** // ** args.MethodName ** // ** Add Event Handler Code ** // ** Use MessageBox to find adapter method name // EpiMessageBox.Show(args.MethodName); string parentcustnum = ""; switch (args.MethodName) { case "Update": activeDistributor = ((EpiCheckBox)csm.GetNativeControlReference("4ff5eda0-9888-4703-a1b1-5185e494758e")); metroArea = ((EpiCombo)csm.GetNativeControlReference("c0355971-9f0a-4126-905a-7d5eca9fb7c5")); primaryLineVE = ((EpiCombo)csm.GetNativeControlReference("bc535f05-1878-40e0-8c80-ddd3a6d70a0f")); if (activeDistributor.Checked) { if (metroArea.Text.Length == 0 || primaryLineVE.Text.Length == 0) { throw new UIException("Metro Area and Primary Line Van Equip must be filled for an Active distributor."); } } category = ((EpiCombo)csm.GetNativeControlReference("f76dd0e7-ba1f-4fff-aaec-9cc5e3f15156")); fleetSize = ((EpiCombo)csm.GetNativeControlReference("8228301d-6ad4-4b54-8834-5a9a50535bf1")); if (category.Text == "Fleet" && fleetSize.Text.Length == 0) { throw new UIException("Fleet size must be filled for Category: Fleet"); } if (custDataView != null && custDataView.HasRow) { if (custDataView.dataView[custDataView.Row]["ParentCustID_c"].ToString() == "") { custDataView.dataView[custDataView.Row]["ParentCustNum_c"] = 0; } else { parentcustnum = GetParentCustNumByCustNum(custDataView.dataView[custDataView.Row]["ParentCustID_c"].ToString()); if (parentcustnum.Length == 0) { throw new UIException("Parent Customer ID doesn't exists."); } else { custDataView.dataView[custDataView.Row]["ParentCustNum_c"] = parentcustnum; } } } break; } }
private void oTrans_adapter_BeforeAdapterMethod(object sender, BeforeAdapterMethodArgs args) { // ** Argument Properties and Uses ** // ** args.MethodName ** // ** Add Event Handler Code ** // ** Use MessageBox to find adapter method name // EpiMessageBox.Show(args.MethodName) switch (args.MethodName) { case "Update": if (edvCRMCall.CurrentDataRow != null) { if (edvCRMCall.CurrentDataRow["CallDesc"].ToString().Contains("CS - New") && String.IsNullOrEmpty(edvCRMCall.CurrentDataRow["InquiryType_c"].ToString())) { throw new UIException("Vehicle Type is required for CS - New"); } } break; } }
private static void oTrans_receiptAdapter_BeforeAdapterMethod(object sender, BeforeAdapterMethodArgs args) { // ** Argument Properties and Uses ** // ** args.MethodName ** // ** Add Event Handler Code ** // ** Use MessageBox to find adapter method name // EpiMessageBox.Show(args.MethodName) switch (args.MethodName) { case "UpdateMaster": if (edvRcvHead.dataView[edvRcvHead.Row]["Company"].ToString() == "19268A") { if (edvMultiKeySearch.dataView[edvMultiKeySearch.Row]["PackSlip"].ToString() == "") { DynamicQueryAdapter adapterDynamicQuery = new DynamicQueryAdapter(oTrans); adapterDynamicQuery.BOConnect(); adapterDynamicQuery.ExecuteByID("GRN_Head"); DataView TB2 = new DataView(adapterDynamicQuery.QueryResults.Tables["Results"]); TB2.RowFilter = "SUBSTRING(RcvHead_PackSlip,1,3) = 'G22'"; string MaxNo = Convert.ToString(TB2.ToTable().Compute("Max(RcvHead_PackSlip)", string.Empty)); if (MaxNo == "") { MaxNo = "00000000000"; } int RNo = int.Parse(MaxNo.Substring(3, 7)) + 1; string RunningNo = RNo.ToString().PadLeft(7, '0'); edvMultiKeySearch.dataView[edvMultiKeySearch.Row]["PackSlip"] = "G22" + RunningNo; adapterDynamicQuery.Dispose(); } } if (edvRcvHead.dataView[edvRcvHead.Row]["Company"].ToString() == "19268B") { if (edvMultiKeySearch.dataView[edvMultiKeySearch.Row]["PackSlip"].ToString() == "") { DynamicQueryAdapter adapterDynamicQuery = new DynamicQueryAdapter(oTrans); adapterDynamicQuery.BOConnect(); adapterDynamicQuery.ExecuteByID("GRN_Head"); DataView TB2 = new DataView(adapterDynamicQuery.QueryResults.Tables["Results"]); TB2.RowFilter = "SUBSTRING(RcvHead_PackSlip,1,3) = 'G25'"; string MaxNo = Convert.ToString(TB2.ToTable().Compute("Max(RcvHead_PackSlip)", string.Empty)); if (MaxNo == "") { MaxNo = "00000000000"; } int RNo = int.Parse(MaxNo.Substring(3, 7)) + 1; string RunningNo = RNo.ToString().PadLeft(7, '0'); edvMultiKeySearch.dataView[edvMultiKeySearch.Row]["PackSlip"] = "G25" + RunningNo; adapterDynamicQuery.Dispose(); } } if (edvRcvHead.dataView[edvRcvHead.Row]["Company"].ToString() == "19268") { DynamicQueryAdapter adapterDynamicQuery = new DynamicQueryAdapter(oTrans); adapterDynamicQuery.BOConnect(); adapterDynamicQuery.ExecuteByID("SO_CrossComp"); DataView TB2 = new DataView(adapterDynamicQuery.QueryResults.Tables["Results"]); TB2.RowFilter = "OrderHed_Company = '19268A' AND OrderHed_ICPONum = '" + edvRcvHead.dataView[edvRcvHead.Row]["PONum"].ToString() + "'"; //MessageBox.Show(TB2.Count.ToString()); if (TB2.Count == 0) { MessageBox.Show("Please ensure CHPE SO already been approved."); edvRcvHead.dataView[edvRcvHead.Row]["PONum"] = ""; } adapterDynamicQuery.Dispose(); } break; } }
private static void oTrans_adapter_BeforeAdapterMethod(object sender, BeforeAdapterMethodArgs args) { // ** Argument Properties and Uses ** // ** args.MethodName ** // ** Add Event Handler Code ** // ** Use MessageBox to find adapter method name //MessageBox.Show(args.MethodName); switch (args.MethodName) { case "Update": if (edvPart.Row > -1) { if (edvPart.CurrentDataRow.RowState.ToString() == "Added") { if ((edvPart.dataView[edvPart.Row]["ClassID"].ToString() == "FG") || (edvPart.dataView[edvPart.Row]["ClassID"].ToString() == "SFG")) { if (edvPart.dataView[edvPart.Row]["PartNum"].ToString() == "") { DynamicQueryAdapter adapterDynamicQuery = new DynamicQueryAdapter(oTrans); adapterDynamicQuery.BOConnect(); adapterDynamicQuery.ExecuteByID("ItemMaster"); DataView TB2 = new DataView(adapterDynamicQuery.QueryResults.Tables["Results"]); string P01 = edvPart.dataView[edvPart.Row]["ShortChar02"].ToString(); TB2.RowFilter = "SUBSTRING(Part_PartNum,1,2) = '" + P01.Substring(0, 2) + "'"; string MaxNo = Convert.ToString(TB2.ToTable().Compute("Max(Calculated_FGCode)", string.Empty)); if (MaxNo == "") { MaxNo = "00000000"; } int RNo = int.Parse(MaxNo.Substring(3, 5)) + 1; string RunningNo = RNo.ToString().PadLeft(5, '0'); if (edvPart.dataView[edvPart.Row]["ClassID"].ToString() == "SFG") { edvPart.dataView[edvPart.Row]["PartNum"] = P01 + RunningNo + "KT"; } else { edvPart.dataView[edvPart.Row]["PartNum"] = P01 + RunningNo; } adapterDynamicQuery.Dispose(); } edvPart.dataView[edvPart.Row]["Character01"] = ""; edvPart.dataView[edvPart.Row]["CostMethod"] = "S"; } else if ((edvPart.dataView[edvPart.Row]["ClassID"].ToString() == "CT") || (edvPart.dataView[edvPart.Row]["ClassID"].ToString() == "DM") || (edvPart.dataView[edvPart.Row]["ClassID"].ToString() == "IM") || (edvPart.dataView[edvPart.Row]["ClassID"].ToString() == "PK")) { if (edvPart.dataView[edvPart.Row]["PartNum"].ToString() == "") { DynamicQueryAdapter adapterDynamicQuery = new DynamicQueryAdapter(oTrans); adapterDynamicQuery.BOConnect(); adapterDynamicQuery.ExecuteByID("ItemMaster"); DataView TB2 = new DataView(adapterDynamicQuery.QueryResults.Tables["Results"]); string P01 = edvPart.dataView[edvPart.Row]["Character01"].ToString(); P01 = P01.Substring(0, 4); TB2.RowFilter = "SUBSTRING(Part_PartNum,1,4) = '" + P01 + "'"; string MaxNo = Convert.ToString(TB2.ToTable().Compute("Max(Part_PartNum)", string.Empty)); if (MaxNo == "") { MaxNo = "0000000000"; } MessageBox.Show(MaxNo.Substring(5, 5)); int RNo = int.Parse(MaxNo.Substring(5, 5)) + 1; string RunningNo = RNo.ToString().PadLeft(5, '0'); edvPart.dataView[edvPart.Row]["PartNum"] = P01 + "-" + RunningNo; adapterDynamicQuery.Dispose(); } edvPart.dataView[edvPart.Row]["ShortChar02"] = ""; edvPart.dataView[edvPart.Row]["CostMethod"] = "A"; } else { cbMType.ReadOnly = true; cbFType.ReadOnly = true; edvPart.dataView[edvPart.Row]["CostMethod"] = "S"; } } } break; } }