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;
}
}
