private void button3_Click(object sender, EventArgs e)
{
if (Validation2())
{
if (tnew.Text.Equals(trnew.Text))
{
err.Dispose();
String oldp = db.GetValue("SELECT [Password]FROM [AVVMS].[dbo].[Login]");
if (oldp.Equals(told.Text))
{
db.Ins_Up_Del("UPDATE [AVVMS].[dbo].[Login]SET [Password] = '" + tnew.Text + "'");
MessageBox.Show("Up Success");
Common_Tasks.nullify(told);
Common_Tasks.nullify(tnew);
Common_Tasks.nullify(trnew);
}
else
{
err.Dispose();
err.SetError(told, "Enter Correct old password");
told.Focus();
}
}
else
{
err.Dispose();
err.SetError(tnew, "Unmatched passwords");
tnew.Focus();
}
}
}
public Trip_Completion(string id, string vehicle, string purpose, string name, string address, string mobile, string driver, string startm, string startt, string sdate, string remark, string j)
{
InitializeComponent();
jtype = 1;
dateTimePicker1.MinDate = DateTime.Parse(sdate);
numericUpDown1.Minimum = ((Convert.ToInt32(startm)));
DGV_traffic_exception.Rows.Add("Toll Fee", "", "");
DGV_traffic_exception.Rows.Add("Parking Fee", "", "");
DGV_traffic_exception.Rows.Add("Fuel", "", "");
label20.Text = id;
lb_address.Text = address;
lb_driver.Text = driver;
lb_mobile.Text = mobile;
lb_name.Text = name;
lb_purpose.Text = purpose;
lb_smeter.Text = startm;
lb_vehicle.Text = vehicle;
lb_remarks.Text = remark;
ld_sdatea.Text = sdate + " " + startt;
date = sdate;
lb_j.Text = j;
Common_Tasks.nullify(lb_fc);
Common_Tasks.nullify(lb_sc);
Common_Tasks.nullify(label11);
Common_Tasks.nullify(label4);
label31.Text = db.GetValue("SELECT [mail]FROM [AVVMS].[dbo].[Trips] where [Id]='" + id + "'");
groupBox2.Text = groupBox2.Text + " : For Driver";
lbextraheavy.Hide();
tkmdheavy.Hide();
panelheavy.Hide();
lb_b.Hide();
txt_hbatha.Hide();
ebatha.Text = db.GetValue("SELECT [light extra amount]FROM [AVVMS].[dbo].[batha]");
hbatha.Text = db.GetValue("SELECT [light hault batha]FROM [AVVMS].[dbo].[batha]");
ini_flag = 1;
}
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 dataGridView6_Click(object sender, EventArgs e)
{
if (dataGridView6.SelectedRows.Count != 0)
{
groupBox1.Text = "Trip No. : " + dataGridView6.SelectedRows[0].Cells[0].Value.ToString();
if (db.GetValue("SELECT [Type]FROM [AVVMS].[dbo].[Vehicles] where [Vehicle No.]='" + dataGridView6.SelectedRows[0].Cells[1].Value.ToString() + "'").Contains("Heavy"))
{
dt = db.GetTable("SELECT [first cleaner],[second cleaner],[address],[start meter],[start time],[moment slip no.]FROM [AVVMS].[dbo].[Trips] where [id]=" + dataGridView6.SelectedRows[0].Cells[0].Value.ToString() + "");
lb_fc.Text = "First Cleaner : " + dt.Rows[0]["first cleaner"].ToString();
if (dt.Rows[0]["second cleaner"].ToString().Equals(""))
{
Common_Tasks.nullify(lb_sc);
}
else
{
lb_sc.Text = "Second Cleaner : " + dt.Rows[0]["second cleaner"].ToString();
}
}
else
{
Common_Tasks.nullify(lb_fc);
Common_Tasks.nullify(lb_sc);
dt = db.GetTable("SELECT [address],[start meter],[start time],[moment slip no.]FROM [AVVMS].[dbo].[Trips] where [id]=" + dataGridView6.SelectedRows[0].Cells[0].Value.ToString() + "");
}
lb_address.Text = "Provider Address : " + dt.Rows[0]["address"].ToString();
lb_startmeter.Text = "Start Meter : " + dt.Rows[0]["start meter"].ToString();
lb_starttime.Text = "Start Time : " + dt.Rows[0]["start time"].ToString();
lb_moment.Text = "Moment Slip No. : " + dt.Rows[0]["moment slip no."].ToString();
groupBox1.Show();
}
}
public Trip_Completion(string id, string vehicle, string purpose, string name, string address, string mobile, string driver, string startm, string startt, string sdate, string remark, string j, string fc, string sc)
{
InitializeComponent();
dateTimePicker1.MinDate = DateTime.Parse(sdate);
numericUpDown1.Minimum = ((Convert.ToInt32(startm)));
DGV_traffic_exception.Rows.Add("Toll Fee", "", "");
DGV_traffic_exception.Rows.Add("Parking Fee", "", "");
DGV_traffic_exception.Rows.Add("Fuel", "", "");
label20.Text = id;
lb_address.Text = address;
lb_driver.Text = driver;
lb_mobile.Text = mobile;
lb_name.Text = name;
lb_purpose.Text = purpose;
lb_smeter.Text = startm;
lb_vehicle.Text = vehicle;
lb_remarks.Text = remark;
ld_sdatea.Text = sdate + " " + startt;
date = sdate;
lb_j.Text = j;
lb_fc.Text = fc;
lb_sc.Text = sc;
label31.Text = db.GetValue("SELECT [mail]FROM [AVVMS].[dbo].[Trips] where [Id]='" + id + "'");
tefc.Text = db.GetValue("SELECT [heavy extra amount cleaner]FROM [AVVMS].[dbo].[batha]");
if (db.GetValue("SELECT [Type]FROM [AVVMS].[dbo].[Employee] where [Employee ID]='" + fc + "'").Equals("Permanent"))
{
tkmfc.Text = db.GetValue("SELECT [heavy km alavence permanent cleaner]FROM [AVVMS].[dbo].[batha]");
}
else
{
tkmfc.Text = db.GetValue("SELECT [heavy km alavance temporary cleaner]FROM [AVVMS].[dbo].[batha]");
}
if (sc.Equals(""))
{
groupBox2.Text = groupBox2.Text + " : For Driver,First Cleaner";
panel2sc.Hide();
Common_Tasks.nullify(label4);
jtype = 2;
}
else
{
groupBox2.Text = groupBox2.Text + " : For Driver,First Cleaner,Second Cleaner";
jtype = 3;
tesc.Text = tefc.Text;
if (db.GetValue("SELECT [Type]FROM [AVVMS].[dbo].[Employee] where [Employee ID]='" + sc + "'").Equals("Permanent"))
{
tkmsc.Text = db.GetValue("SELECT [heavy km alavence permanent cleaner]FROM [AVVMS].[dbo].[batha]");
}
else
{
tkmsc.Text = db.GetValue("SELECT [heavy km alavance temporary cleaner]FROM [AVVMS].[dbo].[batha]");
}
}
lb_b.Hide();
txt_hbatha.Hide();
ebatha.Text = db.GetValue("SELECT [heavy extra amount driver]FROM [AVVMS].[dbo].[batha]");
hbatha.Text = db.GetValue("SELECT [heavy hault batha]FROM [AVVMS].[dbo].[batha]");
tkmdheavy.Text = db.GetValue("SELECT [heavy km alavence driver]FROM [AVVMS].[dbo].[batha]");
ini_flag = 1;
}
private void button1_Click(object sender, EventArgs e)
{
if (Validation())
{
error.Dispose();
if (cal_flag == 1)
{
db.Ins_Up_Del("UPDATE [AVVMS].[dbo].[Trips]SET [status] = 'Complete',km=" + lb_ekm.Text + " WHERE [Id]='" + label20.Text + "'");
db.Ins_Up_Del("UPDATE [AVVMS].[dbo].[Vehicles]SET [Status] = 'Available', [Meter Reading]=" + numericUpDown1.Value + ",[fuel]=" + lb_rfuel.Text + " WHERE [Vehicle No.] = '" + lb_vehicle.Text + "'");
if ((Convert.ToDouble(dt.Rows[0]["Fuel Refill Limit"].ToString())) >= (Convert.ToDouble(lb_rfuel.Text)))
{
db.Ins_Up_Del("INSERT INTO [AVVMS].[dbo].[Refill_Notifications]([Vehicle],[Remain],[Limit],[LastRefillDate])VALUES('" + lb_vehicle.Text + "'," + lb_rfuel.Text + "," + dt.Rows[0]["Fuel Refill Limit"].ToString() + ",'" + db.GetValue("SELECT [last refill date]FROM Vehicles WHERE ([Vehicle No.] = '" + lb_vehicle.Text + "')") + "')");
Program.pi.Display("Vehicle No. " + lb_vehicle.Text + " is in refill stage");
}
db.Ins_Up_Del("UPDATE [AVVMS].[dbo].[Employee]SET [Status] = 'Available'WHERE [Employee ID] = '" + lb_driver.Text + "'");
if (!lb_fc.Text.Equals(""))
{
db.Ins_Up_Del("UPDATE [AVVMS].[dbo].[Employee]SET [Status] = 'Available'WHERE [Employee ID] = '" + lb_fc.Text + "'");
}
if (!lb_sc.Text.Equals(""))
{
db.Ins_Up_Del("UPDATE [AVVMS].[dbo].[Employee]SET [Status] = 'Available'WHERE [Employee ID] = '" + lb_sc.Text + "'");
}
if (txt_hbatha.Visible)
{
db.Ins_Up_Del("INSERT INTO [AVVMS].[dbo].[Batha_Report]([Trip No.],[Date],[Batha],[Batha Amount],[Employee ID])VALUES('" + label20.Text + "','" + date + "','" + lb_b.Text + "','" + txt_hbatha.Text + "','" + lb_driver.Text + "')");
}
try
{
MailMessage email = new MailMessage();
email.From = new MailAddress("*****@*****.**");
email.To.Add(label31.Text);
email.Body = "Your Trip Expense " + lb_total.Text;
email.Subject = "Arya Vydya Shala Trip ";
SmtpClient mailclient = new SmtpClient("smtp.gmail.com", 587);
mailclient.Credentials = new NetworkCredential("avvmskottakkal", "9895091284");
mailclient.EnableSsl = true;
//SmtpClient mailclient = new SmtpClient("localhost", 25);
//mailclient.Credentials = new NetworkCredential("*****@*****.**", "9895204814");
mailclient.Send(email);
}
catch (Exception ex)
{
MessageBox.Show("Mailing Failure...\nReason : " + ex.Message + "\n" + ex.HelpLink);
}
MessageBox.Show("De-Assigned Successfully");
this.Close();
}
else
{
int c1f = 0;
oa = 0;
for (int i = 0; i < DGV_traffic_exception.Rows.Count; i++)
{
if (DGV_traffic_exception.Rows[i].Cells[0].Value.ToString().Equals(""))
{
c1f = 1;
MessageBox.Show("Enter Description For Overhead Expense " + (i + 1));
}
}
if (c1f == 0)
{
for (int i = 0; i < DGV_traffic_exception.Rows.Count; i++)
{
if (DGV_traffic_exception.Rows[i].Cells[1].Value.ToString().Equals(""))
{
c1f = 1;
MessageBox.Show("Enter Amount For Overhead Expense " + (i + 1));
}
else
{
try
{
Decimal k = Convert.ToDecimal(DGV_traffic_exception.Rows[i].Cells[1].Value.ToString());
}
catch (FormatException ex)
{
c1f = 1;
MessageBox.Show("Enter Correct Amount For Overhead Expense " + (i + 1));
}
}
}
}
if (c1f == 0)
{
if (carebatha())
{
for (int i = 0; i < DGV_traffic_exception.Rows.Count; i++)
{
oa = oa + Convert.ToDecimal(DGV_traffic_exception.Rows[i].Cells[1].Value.ToString());
}
if (jtype == 1)
{
lb_total.Text = ((Convert.ToDecimal(ebatha.Text)) + (Convert.ToDecimal(hbatha.Text)) + (Convert.ToDecimal(txt_hbatha.Text)) + oa).ToString();
}
else if (jtype == 2)
{
lbchault.Text = lbchault.Text + " *2";
lb_b.Text = lb_b.Text + " *2";
lb_total.Text = ((Convert.ToDecimal(ebatha.Text)) + ((Convert.ToDecimal(hbatha.Text)) * 2) + ((Convert.ToDecimal(txt_hbatha.Text)) * 2) + (Convert.ToDecimal(tkmdheavy.Text)) + (Convert.ToDecimal(tefc.Text)) + (Convert.ToDecimal(tkmfc.Text)) + oa).ToString();
}
else if (jtype == 3)
{
lbchault.Text = lbchault.Text + " *3";
lb_b.Text = lb_b.Text + " *3";
lb_total.Text = ((Convert.ToDecimal(ebatha.Text)) + ((Convert.ToDecimal(hbatha.Text)) * 3) + ((Convert.ToDecimal(txt_hbatha.Text)) * 3) + (Convert.ToDecimal(tkmdheavy.Text)) + (Convert.ToDecimal(tefc.Text)) + (Convert.ToDecimal(tkmfc.Text)) + (Convert.ToDecimal(tesc.Text)) + (Convert.ToDecimal(tkmsc.Text)) + oa).ToString();
}
lb_total.Show();
cal_flag = 1;
button2.Hide();
button3.Hide();
DGV_traffic_exception.ReadOnly = true;
Common_Tasks.disable(ebatha);
Common_Tasks.disable(txt_hbatha);
Common_Tasks.disable(hbatha);
Common_Tasks.disable(numericUpDown1);
oac = 0;
for (int i = 0; i < DGV_traffic_exception.Rows.Count; i++)
{
oac = oac + Convert.ToDecimal(DGV_traffic_exception.Rows[i].Cells[1].Value.ToString());
}
total.Text = "Total : " + oac.ToString();
Common_Tasks.disable(dateTimePicker1);
Common_Tasks.disable(timePicker);
Common_Tasks.disable(panelheavy);
Common_Tasks.disable(tkmdheavy);
button1.Text = "Submit,Mail";
}
}
}
}
}