private void submit_btn_Click(object sender, EventArgs e)
{
SmtpClient obj = new SmtpClient();
obj.Host = "smtp.live.com";
obj.Port = 25;
obj.EnableSsl = true;
obj.DeliveryMethod = SmtpDeliveryMethod.Network;
obj.UseDefaultCredentials = false;
obj.Credentials = new NetworkCredential("*****@*****.**", "");
// mailcompse code
MailMessage msg = new MailMessage();
msg.To.Add("*****@*****.**");
msg.From = new MailAddress("*****@*****.**");
msg.Subject = "SMOTO---- TAKE A RIDE ----";
msg.Body = "Name : " + name_txt.Text + "\nEmail : " + email_txt.Text + "\nMessage : " + msg_txt.Text;
obj.Send(msg);
msgrtn = "Thank you ! :) \n for Your feedback";
messagebox msgbox = new messagebox();
msgbox.labelmsg(msgrtn);
msgbox.Show();
}
private void insert_btn_Click(object sender, EventArgs e)
{
//user table
if (dataGridView1.Enabled == true)
{
cnn.Open();
cmd.CommandText = "insert into app_users ( username,email,password) values('" + nametxt.Text + "' ,'" + emailtxt.Text + "','" + passtxt.Text + "') ";
cmd.Connection = cnn;
cmd.ExecuteNonQuery();
cnn.Close();
msgrtn = "USER INSERTED!";
messagebox msgbox = new messagebox();
msgbox.labelmsg(msgrtn);
msgbox.Show();
}
else
{
//routes table
cnn.Open();
cmd1.CommandText = "insert into Routes (Pickup_loc,Dropoff_loc,Auto,Go,Go_plus) values ('" + pickuptxt.Text + "','" + dropofftxt.Text + "','" + autotxt.Text + "','" + gotxt.Text + "','" + goplstxt.Text + "')";
cmd1.Connection = cnn;
cmd1.ExecuteNonQuery();
cnn.Close();
msgrtn = "ROUTE INSERTED!";
messagebox msgbox = new messagebox();
msgbox.labelmsg(msgrtn);
msgbox.Show();
}
}
private void delete_btn_Click(object sender, EventArgs e)
{
//user table
if (dataGridView1.Enabled == true)
{
String email = dataGridView1.Rows[rowindex].Cells[2].Value.ToString();
cnn.Open();
cmd.CommandText = "delete from app_users where email='" + email + "'";
cmd.Connection = cnn;
cmd.ExecuteNonQuery();
cnn.Close();
msgrtn = "USER DELETED !";
messagebox msgbox = new messagebox();
msgbox.labelmsg(msgrtn);
msgbox.Show();
}
else
{
//routes table
String rid = dataGridView2.Rows[rowindex].Cells[5].Value.ToString();
cnn.Open();
cmd1.CommandText = "delete from Routes where r_id ='" + rid + "'";
cmd1.Connection = cnn;
cmd1.ExecuteNonQuery();
cnn.Close();
msgrtn = "ROUTE DELETED !";
messagebox msgbox = new messagebox();
msgbox.labelmsg(msgrtn);
msgbox.Show();
}
}
private void update_btn_Click(object sender, EventArgs e)
{
//user table
if (dataGridView1.Enabled == true)
{
cnn.Open();
cmd.CommandText = "update app_users set username='******' ,email='" + emailtxt.Text + "',password='******' where id='" + idtxt.Text + "'";
cmd.Connection = cnn;
cmd.ExecuteNonQuery();
cnn.Close();
msgrtn = "USER UPDATED!";
messagebox msgbox = new messagebox();
msgbox.labelmsg(msgrtn);
msgbox.Show();
}
else
{
//routes table
cnn.Open();
cmd1.CommandText = "update Routes set Pickup_loc='" + pickuptxt.Text + "',Dropoff_loc='" + dropofftxt.Text + "',Auto='" + autotxt.Text + "',Go='" + gotxt.Text + "',Go_plus='" + goplstxt.Text + "' where r_id='" + r_idtxt.Text + "'";
cmd1.Connection = cnn;
cmd1.ExecuteNonQuery();
cnn.Close();
msgrtn = "ROUTE UPDATED!";
messagebox msgbox = new messagebox();
msgbox.labelmsg(msgrtn);
msgbox.Show();
}
}
private void ridebtn_Click(object sender, EventArgs e)
{
msgrtn = "HAVE A NICE RIDE \n PLEASE GIVE US A FEEDBACK";
messagebox msgbox = new messagebox();
msgbox.labelmsg(msgrtn);
msgbox.Show();
cnn.Open();
cmd.CommandText = "insert into history values('" + LoginInfo.email + "', '" + pick_lb.Text + "', '" + drop_lb.Text + "' , '" + fare_lb.Text + "')";
cmd.Connection = cnn;
cmd.ExecuteNonQuery();
}
private void submit_btn_Click(object sender, EventArgs e)
{
SmtpClient obj = new SmtpClient();
obj.Host = "smtp.live.com";
obj.Port = 587;
obj.EnableSsl = true;
obj.DeliveryMethod = SmtpDeliveryMethod.Network;
obj.UseDefaultCredentials = false;
obj.Credentials = new NetworkCredential("*****@*****.**", "");
// mailcompse code
MailMessage msg = new MailMessage();
msg.To.Add(email_txt.Text);
msg.From = new MailAddress("*****@*****.**");
msg.Subject = "SMOTO----- TAKE A RIDE ----your password";
cnn.Open();
cmd = new SqlCommand();
cmd.CommandText = "select * from app_users where email ='" + email_txt.Text + "'";
cmd.Connection = cnn;
SqlDataReader rd = cmd.ExecuteReader();
if (rd.HasRows)
{
while (rd.Read())
{
msg.Body = "Your Name : " + rd[1].ToString() + "\nYour Email : " + rd[2].ToString() + "\nYour Password : "******"Email has been send";
messagebox msgbox = new messagebox();
msgbox.labelmsg(msgrtn);
msgbox.Show();
}
