public Assign_Trip()
{
InitializeComponent();
panelcleaner.Hide();
dateTimePicker1.CustomFormat = "dd:MMM:yyyy";
label20.Text = db.max_plus("SELECT max([Id])FROM [AVVMS].[dbo].[Trips]").ToString();
combotype.SelectedIndex = 0;
combovehi.SelectedIndex = 0;
DataTable dt = new DataTable();
dt = db.GetTable("SELECT [Employee ID]FROM [AVVMS].[dbo].[Employee] where [Category]='Driver' and [Status]='Available'");
for (int i = 0; i < dt.Rows.Count; i++)
{
combodriver.Items.Add(dt.Rows[i]["Employee ID"].ToString());
}
combodriver.SelectedIndex = 0;
dt = new DataTable();
dt = db.GetTable("SELECT [Employee ID]FROM [AVVMS].[dbo].[Employee] where [Category]='Cleaner' and [Status]='Available'");
for (int i = 0; i < dt.Rows.Count; i++)
{
combofirst.Items.Add(dt.Rows[i]["Employee ID"].ToString());
}
combofirst.SelectedIndex = 0;
for (int i = 1; i < combofirst.Items.Count; i++)
{
comboBox7.Items.Add(combofirst.Items[i]);
}
comboBox7.SelectedIndex = 0;
}
public Hair()
{
InitializeComponent();
DGV_traffic_exception.Rows.Add("Toll Fee", "", "", "");
DGV_traffic_exception.Rows.Add("Parking Fee", "", "", "");
DGV_traffic_exception.Rows.Add("Fuel", "", "", "");
lno.Text = db.max_plus("select MAX([no]) FROM [AVVMS].[dbo].[hair]").ToString();
}
public Vehicle_Sell(string no)
{
// TODO: Complete member initialization
InitializeComponent();
label6.Text = db.max_plus("SELECT max([Id])FROM [AVVMS].[dbo].[sell]").ToString();
label2.Text = no;
dataGridView1.Rows.Add("1", "", "");
}
public Bank_Pay(string no, string am)
{
// TODO: Complete member initialization
InitializeComponent();
label11.Text = db.max_plus("SELECT max([no])FROM [AVVMS].[dbo].[bunk pay]").ToString();
lbbunk.Text = no;
lbam.Text = am;
comboBox2.SelectedIndex = 0;
}
public Insurance_Reciept_Input()
{
InitializeComponent();
label11.Text = db.max_plus("SELECT max([no.])FROM [AVVMS].[dbo].[insurance]").ToString();
dt = db.GetTable("SELECT [Vehicle No.] FROM [AVVMS].[dbo].[Vehicles] where Status != 'Removed'");
for (int i = 0; i < dt.Rows.Count; i++)
{
comboBoxvehicle.Items.Add(dt.Rows[i]["Vehicle No."].ToString());
}
comboBoxvehicle.SelectedIndex = 0;
comboBoxpmode.SelectedIndex = 0;
}
public Maintanance_Registration()
{
InitializeComponent();
label8.Text = db.max_plus("SELECT max([no.])FROM [AVVMS].[dbo].[maintanance]").ToString();
DataTable dt = new DataTable();
dt = db.GetTable("SELECT [Vehicle No.]FROM [AVVMS].[dbo].[Vehicles] where [Status]='On Maintenence'");
for (int i = 0; i < dt.Rows.Count; i++)
{
comboBox1.Items.Add(dt.Rows[i]["Vehicle No."].ToString());
}
comboBox1.SelectedIndex = 0;
}
public Refill_Bill_Input()
{
InitializeComponent();
label11.Text = db.max_plus("SELECT max([no])FROM [AVVMS].[dbo].[refill bill]").ToString();
DataTable dt = new DataTable();
dt = db.GetTable("SELECT [Vehicle No.]FROM [AVVMS].[dbo].[Vehicles] where [Status]!='Removed'");
for (int i = 0; i < dt.Rows.Count; i++)
{
comboBoxv.Items.Add(dt.Rows[i]["Vehicle No."].ToString());
}
comboBoxv.SelectedIndex = 0;
dt = db.GetTable("SELECT [no]FROM [AVVMS].[dbo].[pbunk] where [Status]!='Removed'");
for (int i = 0; i < dt.Rows.Count; i++)
{
comboBoxbunk.Items.Add(dt.Rows[i]["no"].ToString());
}
comboBoxbunk.SelectedIndex = 0;
}
public Bank_Addition()
{
InitializeComponent();
label4.Text = db.max_plus("SELECT max([no])FROM [AVVMS].[dbo].[pbunk]").ToString();
}