private void TxtFullName_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
CmbType.Focus();
}
}
private void BtnSearchTransactionType_Click(object sender, EventArgs e)
{
FrmTransactionType SearchTransactionType = new FrmTransactionType(true);
var TransTypeRes = SearchTransactionType.ShowDialog();
string TransTypeVal = "";
if (TransTypeRes == DialogResult.OK)
{
TransTypeVal = SearchTransactionType.ReturnValue1;
}
CmbType.Text = TransTypeVal;
CmbType.Select(CmbType.Text.Length, 0);
}
private void CmbFill()
{
CmbAirline.ResetText();
CmbCity.ResetText();
CmbGate.ResetText();
CmbRunway.ResetText();
CmbType.ResetText();
con.Open();
string query = "SELECT Airline FROM Airlines";
SqlCommand cmd = new SqlCommand(query, con);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
CmbAirline.Items.Add(reader.GetString(0));
}
con.Close();
con.Open();
string query1 = "SELECT City FROM Cities";
SqlCommand cmd1 = new SqlCommand(query1, con);
SqlDataReader reader1 = cmd1.ExecuteReader();
while (reader1.Read())
{
CmbCity.Items.Add(reader1.GetString(0));
}
con.Close();
con.Open();
string query2 = "SELECT Gate FROM Gates";
SqlCommand cmd2 = new SqlCommand(query2, con);
SqlDataReader reader2 = cmd2.ExecuteReader();
while (reader2.Read())
{
CmbGate.Items.Add(reader2.GetString(0));
}
con.Close();
con.Open();
string query3 = "SELECT Runway FROM Runways";
SqlCommand cmd3 = new SqlCommand(query3, con);
SqlDataReader reader3 = cmd3.ExecuteReader();
while (reader3.Read())
{
CmbRunway.Items.Add(reader3.GetString(0));
}
con.Close();
}
private void CmbType_TextChanged(object sender, EventArgs e)
{
int NumberOfChar = CmbType.Text.Length - CmbType.SelectedText.Length;
if (SearchKeyHit == true && FromTextChange == false)
{
CmbType.Items.Clear();
string Desc = "", Category = "", Hier = "";
string EnteredText = CmbType.Text.Substring(0, CmbType.Text.Length - CmbType.SelectedText.Length).Replace("::", ":");
string QueryRes = "";
int LoopCounter = 0;
if (EnteredText.Split(':').Count() == 3)
{
Desc = EnteredText.Split(':')[0];
Category = EnteredText.Split(':')[1];
Hier = EnteredText.Split(':')[2];
QueryRes = CommFunc.Fetch_DB_MultiValue("Description,Category,Hierarchy", "TransactionTypeDim", "Description like '"
+ Desc + "%' and Category like '" + Category + "%' and Hierarchy like '" + Hier + "%'");
while (LoopCounter < QueryRes.Split('|').Count())
{
CmbType.Items.Add(QueryRes.Split('|')[LoopCounter]);
LoopCounter++;
}
FromTextChange = true;
if (QueryRes != "")
{
CmbType.SelectedIndex = 0;
}
CmbType.Select(NumberOfChar, CmbType.Text.Length - NumberOfChar);
}
if (EnteredText.Split(':').Count() == 2)
{
Desc = EnteredText.Split(':')[0];
Category = EnteredText.Split(':')[1];
QueryRes = CommFunc.Fetch_DB_MultiValue("Description,Category,Hierarchy", "TransactionTypeDim", "Description like '"
+ Desc + "%' and Category like '" + Category + "%'");
while (LoopCounter < QueryRes.Split('|').Count())
{
CmbType.Items.Add(QueryRes.Split('|')[LoopCounter]);
LoopCounter++;
}
FromTextChange = true;
if (QueryRes != "")
{
CmbType.SelectedIndex = 0;
}
CmbType.Select(NumberOfChar, CmbType.Text.Length - NumberOfChar);
}
if (EnteredText.Split(':').Count() == 1)
{
Desc = EnteredText;
QueryRes = CommFunc.Fetch_DB_MultiValue("Description,Category,Hierarchy", "TransactionTypeDim", "Description like '"
+ Desc + "%'");
while (LoopCounter < QueryRes.Split('|').Count())
{
CmbType.Items.Add(QueryRes.Split('|')[LoopCounter]);
LoopCounter++;
}
FromTextChange = true;
if (QueryRes != "")
{
CmbType.SelectedIndex = 0;
}
CmbType.Select(NumberOfChar, CmbType.Text.Length - NumberOfChar);
}
else
{
FromTextChange = false;
}
}
}
private void InitializeControls()
{
TextBoxValue.SetTextDataBinding(_identity, nameof(_identity.Value));
CmbType.DataSource = Enum.GetValues(typeof(CustomerIdentity.IdentityTypes));
CmbType.SetSelectedItemDataBinding(_identity, nameof(_identity.IdentityType));
}
