private void ppDeliverMethod_EditValueChanged(object sender, EventArgs e)
{
layoutControlGroup10.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
layoutControlItem22.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
CTechCore.Tools.CustomControls.CustomSearchEditor cntrl = (CTechCore.Tools.CustomControls.CustomSearchEditor)sender;
if (cntrl.EditValue is int && (int)cntrl.EditValue > 0)
{
DataView dv = (DataView)cntrl.Properties.DataSource;
DataRow dr = dv.Table.Select($"counter = {(int)cntrl.EditValue}").FirstOrDefault();
if (dr.Field <string>("method").ToUpper().StartsWith("3RD"))
{
layoutControlGroup10.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
layoutControlItem22.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
}
}
else if (cntrl.EditValue is DataRow)
{
DataRow dr = (DataRow)cntrl.EditValue;
if (dr.Field <string>("method").ToUpper().StartsWith("3RD"))
{
layoutControlGroup10.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
layoutControlItem22.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
}
}
}
private void ppStk_EditValueChanged(object sender, EventArgs e)
{
Decimal finalPrice = 0;
CTechCore.Tools.CustomControls.CustomSearchEditor cntrl = (CTechCore.Tools.CustomControls.CustomSearchEditor)sender;
DataRow dr = ((DataView)cntrl.Properties.DataSource).Table.Select($"StockLink = {(int)cntrl.EditValue}").FirstOrDefault();
int stockLink = int.Parse(dr["StockLink"].ToString());
Decimal defaultPrice = Decimal.Parse(dr["fExclPrice"].ToString());
SalesOrder so = (SalesOrder)salesOrderBindingSource.DataSource;
Detail soLine = (Detail)gridView1.GetFocusedRow();
Models.Stock.StockPrice CurPrice = new Models.Stock.StockPrice(ClientID: so.CustomerID, docdate: so.OrderDate, stockId: (int)cntrl.EditValue, qty: 0);
if (soLine.PriceListID > 0)
{
DataTable dt = new DataTable();
MyApp.Evo.ExecSQL($"SELECT * FROM zz_CTECH_InvLinesDiscInfo WHERE AutoIDX = {soLine.PriceListID}", ref dt);
if (dt.Rows.Count > 0)
{
CurPrice.ID = dt.Rows[0].Field <int>("AutoIDX");
if (
dr.Field <int>("StockLink") == int.Parse(dt.Rows[0]["StockLink"].ToString()) &&
(so.OrderDate >= DateTime.Parse(dt.Rows[0]["dEffDate"].ToString()) && so.OrderDate <= DateTime.Parse(dt.Rows[0]["dExpDate"].ToString())))
{
CurPrice.SpecialPrice = bool.Parse(dt.Rows[0]["bUseStockPrc"].ToString()) ? decimal.Parse(dt.Rows[0]["fPriceDisc"].ToString()) : 0;
CurPrice.UseStockPrc = bool.Parse(dt.Rows[0]["bUseStockPrc"].ToString());
CurPrice.UseThisPriceExcl = decimal.Parse(dt.Rows[0]["fPriceDisc"].ToString());
}
}
}
finalPrice = CurPrice.UseThisPriceExcl;
}
private void PpAddress_EditValueChanged(object sender, EventArgs e)
{
CTechCore.Tools.CustomControls.CustomSearchEditor cntrl = (CTechCore.Tools.CustomControls.CustomSearchEditor)sender;
DataRow row = (DataRow)cntrl.EditValue;
txtAddr1.Text = row["Address1"].ToString();
txtAddr2.Text = row["Address2"].ToString();
txtAddr3.Text = row["Address3"].ToString();
txtAddr4.Text = row["Address4"].ToString();
txtAddr5.Text = row["Address5"].ToString();
txtAddrPC.Text = row["AddressPC"].ToString();
txtName.Text = row["Name"].ToString();
txtcontactnumber.Text = row["ContactNumber"].ToString();
txtContactPerson.Text = row["ContactPerson"].ToString();
}
private void ppRep_EditValueChanged(object sender, EventArgs e)
{
SalesOrder so = (SalesOrder)salesOrderBindingSource.DataSource;
CTechCore.Tools.CustomControls.CustomSearchEditor cntrl = (CTechCore.Tools.CustomControls.CustomSearchEditor)sender;
if (cntrl.EditValue is int && (int)cntrl.EditValue > 0)
{
DataView dv = (DataView)cntrl.Properties.DataSource;
DataRow dr = dv.Table.Select($"idSalesRep = {(int)cntrl.EditValue}").FirstOrDefault();
so.SalesRepresentativeEMail = dr.Field <string>("RepMail");
}
else if (cntrl.EditValue is DataRow)
{
so.SalesRepresentativeEMail = ((DataRow)cntrl.EditValue).Field <string>("RepMail");
}
else
{
}
}
private void ppCustomer_EditValueChanged(object sender, EventArgs e)
{
CTechCore.Tools.CustomControls.CustomSearchEditor cntrl = ((CTechCore.Tools.CustomControls.CustomSearchEditor)sender);
if (cntrl.EditValue != null && cntrl.EditValue is int && (int)cntrl.EditValue > 0)
{
SalesOrder so = (SalesOrder)salesOrderBindingSource.DataSource;
Cursor.Current = Cursors.WaitCursor;
ppStk.DataSource = new DataView(HertexData.StockItems.GetStockItemList((int)cntrl.EditValue));
ppStk.PopupControl.Width = 1000;
ppStk.cntrlSearch1.Columns.ToList().ForEach(c => c.Visible = new List <string>()
{
"Item", "ItemDesc", "ItemGroup"
}.Contains(c.FieldName));
ppStk.cntrlSearch1.Columns["Item"].MinWidth = 100;
ppStk.cntrlSearch1.Columns["ItemDesc"].MinWidth = 300;
ppStk.cntrlSearch1.Columns["ItemColour"].MinWidth = 200;
Console.WriteLine($"lookup stk: {so.CustomerInfo.Field<int>("ClientID")} | {so.CustomerInfo.Field<string>("Account")} | {so.CustomerInfo.Field<string>("Name")}");
Cursor.Current = Cursors.Default;
}
else
{
ppStk.DataSource = null;
}
}
