public Test_Form()
{
InitializeComponent();
//oDateTimePicker.TextChanged += new EventHandler(dateTimePicker_OnTextChange);
a = new System.Windows.Forms.NumericUpDown();
this.Controls.Add(a);
a.Minimum = Convert.ToInt32("10") + 1;
a.ValueChanged += new EventHandler(a_OnValueChange);
System.Windows.Forms.Control[] c = new Control[2];
c[0] = label1;
c[1] = label9;
Common_Tasks.disableg(c);
String fields = "[Id] as [Sl. No.],[Vehicle] as [Vehicle No.],[Reason] ,[Remarks]";
string table = "[AVVMS].[dbo].[Vehicle_Notifications]";
//DGV_Vehicle.DataSource = db.GetTable(Search_Handler.query_builder_search(fields,table));
String searchkey = "v2";
String search_field = "[Vehicle]";
//DGV_Vehicle.DataSource = db.GetTable(Search_Handler.query_builder_search_feild_start(fields, table, search_field, searchkey));
//DGV_Vehicle.DataSource = db.GetTable(Search_Handler.query_builder_search_feild_end(fields, table, search_field, searchkey));
//DGV_Vehicle.DataSource = db.GetTable(Search_Handler.query_builder_search_feild_contains(fields, table, search_field, searchkey));
//DGV_Vehicle.DataSource = db.GetTable(Search_Handler.query_builder_search_feild_notcontains(fields, table, search_field, searchkey));
DGV_Vehicle.DataSource = db.GetTable(Search_Handler.query_builder_search_feild(fields, table, search_field, searchkey));
Control[] cx = new Control[2] {
label1, label9
};
Common_Tasks.disableg(cx);
}
private void TxtSearch_TextChanged(object sender, EventArgs e)
{
String fields = "[Id] as [Sl. No.],[Vehicle No.],[Journey] ,[Purpose],[Provider],[Remarks]";
string table = "[AVVMS].[dbo].[Trips]";
String search_field = "[Vehicle No.]";
String searchkey = TxtSearch.Text;
String append_text_today = "where [date] ='" + DateTime.Now.ToShortDateString() + "' and [Status] != 'Complete'";
String append_text_coming = "where [date] !='" + DateTime.Now.ToShortDateString() + "'";
if (TxtSearch.Text.Equals(""))
{
DGV_Today_Trips.DataSource = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search(fields, table), append_text_today));
fields = "[Id] as [Sl. No.],[Vehicle No.],[Journey] ,[Purpose],[Provider],[Date],[Remarks]";
dt = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search(fields, table), append_text_coming));
coming_trips_display(dt);
}
else
{
if (xPander2.IsExpanded)
{
if (RdbStartsWith.Checked)
{
if (comboBox1.SelectedItem.ToString().Equals("Today Trips"))
{
append_text_today = "and [date] ='" + DateTime.Now.ToShortDateString() + "' and [Status] != 'Complete'";
if (CmbSearchType.SelectedItem.ToString().Equals("Vehicle No."))
{
DGV_Today_Trips.DataSource = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_start(fields, table, search_field, searchkey), append_text_today));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Journey"))
{
search_field = "[Journey]";
DGV_Today_Trips.DataSource = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_start(fields, table, search_field, searchkey), append_text_today));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Purpose"))
{
search_field = "[Purpose]";
DGV_Today_Trips.DataSource = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_start(fields, table, search_field, searchkey), append_text_today));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Provider"))
{
search_field = "[Provider]";
DGV_Today_Trips.DataSource = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_start(fields, table, search_field, searchkey), append_text_today));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Remarks"))
{
search_field = "[Remarks]";
DGV_Today_Trips.DataSource = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_start(fields, table, search_field, searchkey), append_text_today));
}
}
else if (comboBox1.SelectedItem.ToString().Equals("Coming Trips"))
{
append_text_coming = "and [date] !='" + DateTime.Now.ToShortDateString() + "'";
fields = "[Id] as [Sl. No.],[Vehicle No.],[Journey] ,[Purpose],[Provider],[Date],[Remarks]";
if (CmbSearchType.SelectedItem.ToString().Equals("Vehicle No."))
{
dt = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_start(fields, table, search_field, searchkey), append_text_coming));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Journey"))
{
search_field = "[Journey]";
dt = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_start(fields, table, search_field, searchkey), append_text_coming));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Purpose"))
{
search_field = "[Purpose]";
dt = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_start(fields, table, search_field, searchkey), append_text_coming));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Provider"))
{
search_field = "[Provider]";
dt = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_start(fields, table, search_field, searchkey), append_text_coming));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Date"))
{
search_field = "[Date]";
dt = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_start(fields, table, search_field, searchkey), append_text_coming));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Remarks"))
{
search_field = "[Remarks]";
dt = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_start(fields, table, search_field, searchkey), append_text_coming));
}
coming_trips_display(dt);
}
}
else if (RdbEndsWithH.Checked)
{
if (comboBox1.SelectedItem.ToString().Equals("Today Trips"))
{
append_text_today = "and [date] ='" + DateTime.Now.ToShortDateString() + "' and [Status] != 'Complete'";
if (CmbSearchType.SelectedItem.ToString().Equals("Vehicle No."))
{
DGV_Today_Trips.DataSource = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_end(fields, table, search_field, searchkey), append_text_today));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Journey"))
{
search_field = "[Journey]";
DGV_Today_Trips.DataSource = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_end(fields, table, search_field, searchkey), append_text_today));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Purpose"))
{
search_field = "[Purpose]";
DGV_Today_Trips.DataSource = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_end(fields, table, search_field, searchkey), append_text_today));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Provider"))
{
search_field = "[Provider]";
DGV_Today_Trips.DataSource = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_end(fields, table, search_field, searchkey), append_text_today));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Remarks"))
{
search_field = "[Remarks]";
DGV_Today_Trips.DataSource = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_end(fields, table, search_field, searchkey), append_text_today));
}
}
else if (comboBox1.SelectedItem.ToString().Equals("Coming Trips"))
{
append_text_coming = "and [date] !='" + DateTime.Now.ToShortDateString() + "'";
fields = "[Id] as [Sl. No.],[Vehicle No.],[Journey] ,[Purpose],[Provider],[Date],[Remarks]";
if (CmbSearchType.SelectedItem.ToString().Equals("Vehicle No."))
{
dt = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_end(fields, table, search_field, searchkey), append_text_coming));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Journey"))
{
search_field = "[Journey]";
dt = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_end(fields, table, search_field, searchkey), append_text_coming));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Purpose"))
{
search_field = "[Purpose]";
dt = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_end(fields, table, search_field, searchkey), append_text_coming));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Provider"))
{
search_field = "[Provider]";
dt = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_end(fields, table, search_field, searchkey), append_text_coming));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Date"))
{
search_field = "[Date]";
dt = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_end(fields, table, search_field, searchkey), append_text_coming));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Remarks"))
{
search_field = "[Remarks]";
dt = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_end(fields, table, search_field, searchkey), append_text_coming));
}
coming_trips_display(dt);
}
}
else if (RdbContains.Checked)
{
if (comboBox1.SelectedItem.ToString().Equals("Today Trips"))
{
append_text_today = "and [date] ='" + DateTime.Now.ToShortDateString() + "' and [Status] != 'Complete'";
if (CmbSearchType.SelectedItem.ToString().Equals("Vehicle No."))
{
DGV_Today_Trips.DataSource = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_contains(fields, table, search_field, searchkey), append_text_today));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Journey"))
{
search_field = "[Journey]";
DGV_Today_Trips.DataSource = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_contains(fields, table, search_field, searchkey), append_text_today));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Purpose"))
{
search_field = "[Purpose]";
DGV_Today_Trips.DataSource = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_contains(fields, table, search_field, searchkey), append_text_today));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Provider"))
{
search_field = "[Provider]";
DGV_Today_Trips.DataSource = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_contains(fields, table, search_field, searchkey), append_text_today));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Remarks"))
{
search_field = "[Remarks]";
DGV_Today_Trips.DataSource = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_contains(fields, table, search_field, searchkey), append_text_today));
}
}
else if (comboBox1.SelectedItem.ToString().Equals("Coming Trips"))
{
append_text_coming = "and [date] !='" + DateTime.Now.ToShortDateString() + "'";
fields = "[Id] as [Sl. No.],[Vehicle No.],[Journey] ,[Purpose],[Provider],[Date],[Remarks]";
if (CmbSearchType.SelectedItem.ToString().Equals("Vehicle No."))
{
dt = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_contains(fields, table, search_field, searchkey), append_text_coming));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Journey"))
{
search_field = "[Journey]";
dt = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_contains(fields, table, search_field, searchkey), append_text_coming));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Purpose"))
{
search_field = "[Purpose]";
dt = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_contains(fields, table, search_field, searchkey), append_text_coming));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Provider"))
{
search_field = "[Provider]";
dt = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_contains(fields, table, search_field, searchkey), append_text_coming));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Date"))
{
search_field = "[Date]";
dt = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_contains(fields, table, search_field, searchkey), append_text_coming));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Remarks"))
{
search_field = "[Remarks]";
dt = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_contains(fields, table, search_field, searchkey), append_text_coming));
}
coming_trips_display(dt);
}
}
else if (RdbDoesNotContains.Checked)
{
if (comboBox1.SelectedItem.ToString().Equals("Today Trips"))
{
append_text_today = "and [date] ='" + DateTime.Now.ToShortDateString() + "' and [Status] != 'Complete'";
if (CmbSearchType.SelectedItem.ToString().Equals("Vehicle No."))
{
DGV_Today_Trips.DataSource = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_notcontains(fields, table, search_field, searchkey), append_text_today));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Journey"))
{
search_field = "[Journey]";
DGV_Today_Trips.DataSource = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_notcontains(fields, table, search_field, searchkey), append_text_today));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Purpose"))
{
search_field = "[Purpose]";
DGV_Today_Trips.DataSource = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_notcontains(fields, table, search_field, searchkey), append_text_today));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Provider"))
{
search_field = "[Provider]";
DGV_Today_Trips.DataSource = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_notcontains(fields, table, search_field, searchkey), append_text_today));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Remarks"))
{
search_field = "[Remarks]";
DGV_Today_Trips.DataSource = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_notcontains(fields, table, search_field, searchkey), append_text_today));
}
}
else if (comboBox1.SelectedItem.ToString().Equals("Coming Trips"))
{
append_text_coming = "and [date] !='" + DateTime.Now.ToShortDateString() + "'";
fields = "[Id] as [Sl. No.],[Vehicle No.],[Journey] ,[Purpose],[Provider],[Date],[Remarks]";
if (CmbSearchType.SelectedItem.ToString().Equals("Vehicle No."))
{
dt = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_notcontains(fields, table, search_field, searchkey), append_text_coming));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Journey"))
{
search_field = "[Journey]";
dt = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_notcontains(fields, table, search_field, searchkey), append_text_coming));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Purpose"))
{
search_field = "[Purpose]";
dt = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_notcontains(fields, table, search_field, searchkey), append_text_coming));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Provider"))
{
search_field = "[Provider]";
dt = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_notcontains(fields, table, search_field, searchkey), append_text_coming));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Date"))
{
search_field = "[Date]";
dt = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_notcontains(fields, table, search_field, searchkey), append_text_coming));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Remarks"))
{
search_field = "[Remarks]";
dt = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild_notcontains(fields, table, search_field, searchkey), append_text_coming));
}
coming_trips_display(dt);
}
}
}
else
{
if (comboBox1.SelectedItem.ToString().Equals("Today Trips"))
{
append_text_today = "and [date] ='" + DateTime.Now.ToShortDateString() + "' and [Status] != 'Complete'";
if (CmbSearchType.SelectedItem.ToString().Equals("Vehicle No."))
{
DGV_Today_Trips.DataSource = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild(fields, table, search_field, searchkey), append_text_today));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Journey"))
{
search_field = "[Journey]";
DGV_Today_Trips.DataSource = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild(fields, table, search_field, searchkey), append_text_today));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Purpose"))
{
search_field = "[Purpose]";
DGV_Today_Trips.DataSource = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild(fields, table, search_field, searchkey), append_text_today));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Provider"))
{
search_field = "[Provider]";
DGV_Today_Trips.DataSource = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild(fields, table, search_field, searchkey), append_text_today));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Remarks"))
{
search_field = "[Remarks]";
DGV_Today_Trips.DataSource = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild(fields, table, search_field, searchkey), append_text_today));
}
}
else if (comboBox1.SelectedItem.ToString().Equals("Coming Trips"))
{
append_text_coming = "and [date] !='" + DateTime.Now.ToShortDateString() + "'";
fields = "[Id] as [Sl. No.],[Vehicle No.],[Journey] ,[Purpose],[Provider],[Date],[Remarks]";
if (CmbSearchType.SelectedItem.ToString().Equals("Vehicle No."))
{
dt = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild(fields, table, search_field, searchkey), append_text_coming));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Journey"))
{
search_field = "[Journey]";
dt = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild(fields, table, search_field, searchkey), append_text_coming));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Purpose"))
{
search_field = "[Purpose]";
dt = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild(fields, table, search_field, searchkey), append_text_coming));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Provider"))
{
search_field = "[Provider]";
dt = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild(fields, table, search_field, searchkey), append_text_coming));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Date"))
{
search_field = "[Date]";
dt = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild(fields, table, search_field, searchkey), append_text_coming));
}
else if (CmbSearchType.SelectedItem.ToString().Equals("Remarks"))
{
search_field = "[Remarks]";
dt = db.GetTable(Search_Handler.query_append(Search_Handler.query_builder_search_feild(fields, table, search_field, searchkey), append_text_coming));
}
coming_trips_display(dt);
}
}
}
}
