private void estimation_Click(object sender, EventArgs e)
{
try
{
float cost = float.Parse(duration.Text);
float total1 = cost * 3 + 1000;
// int x;
total.Text = total1.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
try
{
Database1 db = new Database1();
MySqlConnection conn = db.getConnection();
MySqlCommand cmd = conn.CreateCommand();
genarateID1();
cmd.CommandText = "insert into vestimation (estimationID,projectID,vehicleID,estCost) values('" + estimation1 + "','" + projectID.Text + "','" + vehicleID.Text + "','" + double.Parse(total.Text) + "')";
cmd.ExecuteNonQuery();
conn.Close();
MessageBox.Show("Success");
}
catch (MySqlException ex)
{
MessageBox.Show(Convert.ToString(ex));
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button2_Click(object sender, EventArgs e)
{
try
{
Database1 db = new Database1();
string query = "select *from reserved where vehicleID like '%" + search.Text + "%'";
MySqlConnection conn = db.getConnection();
MySqlDataAdapter adapter = new MySqlDataAdapter(query, conn);
DataTable table = new DataTable();
adapter.Fill(table);
BindingSource bsource = new BindingSource();
bsource.DataSource = table;
vehicle_reserve.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
vehicle_reserve.DataSource = bsource;
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void genarateID1()
{
Database1 db = new Database1();
MySqlConnection conn = db.getConnection();
MySqlCommand cmd = new MySqlCommand("select count(estimationID) from vestimation", conn);
int i = Convert.ToInt32(cmd.ExecuteScalar());
conn.Close();
i++;
estimation1 = estimation1 + i.ToString();
}
private void genarateID()
{
Database1 db = new Database1();
MySqlConnection conn = db.getConnection();
MySqlCommand cmd = new MySqlCommand("select count(incomeID) from vincome", conn);
int i = Convert.ToInt32(cmd.ExecuteScalar());
conn.Close();
i++;
incomeID1.Text = incomeid + i.ToString();
}
private void bunifuFlatButton1_Click(object sender, EventArgs e)
{
try
{
float km = float.Parse(milage.Text);
float cost = float.Parse(duration.Text);
float total1 = cost * 3 + 1000 + (km / 100 * 10);
total.Text = total1.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
try
{
Database1 db = new Database1();
//string query = "select *from Employee";
MySqlConnection conn = db.getConnection();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "update register set status='Aviliable' where vehicleID='" + vehicleID.Text + "'";
cmd.ExecuteNonQuery();
conn.Close();
MessageBox.Show("the record wass updated success");
}
catch (SqlException ex)
{
MessageBox.Show(Convert.ToString(ex));
}
try
{
Database1 db = new Database1();
MySqlConnection conn = db.getConnection();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "insert into vincome (incomeID,projectID,vehicleID,duration) values('" + incomeID1.Text + "','" + projectID.Text + "','" + vehicleID.Text + "','" + Convert.ToInt32(duration.Text) + "')";
cmd.ExecuteNonQuery();
conn.Close();
genarateID();
MessageBox.Show("Success");
}
catch (MySqlException ex)
{
MessageBox.Show(Convert.ToString(ex));
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
vehicleID.Clear();
duration.Clear();
}
private void generateID()
{
Database1 db = new Database1();
MySqlConnection conn = db.getConnection();
MySqlCommand cmd = new MySqlCommand("SELECT COUNT(JobID) from assignJobs", conn);
int i = Convert.ToInt32(cmd.ExecuteScalar());
conn.Close();
i++;
bunifuMaterialTextbox2.Text = jbID + i.ToString();
}
private void genarateID()
{
Database1 db = new Database1();
MySqlConnection conn = db.getConnection();
MySqlCommand cmd = new MySqlCommand("select Count(vehicleID) from register", conn);
int i = Convert.ToInt32(cmd.ExecuteScalar());
conn.Close();
i++;
vehicleID.Text = vehicleid + i.ToString();
}
private void genarateID()
{
Database1 db = new Database1();
MySqlConnection conn = db.getConnection();
MySqlCommand cmd = new MySqlCommand("select Count(Serv_No) from services", conn);
int i = Convert.ToInt32(cmd.ExecuteScalar());
conn.Close();
i++;
Serv_No.Text = serid + i.ToString();
}
private void button1_Click_1(object sender, EventArgs e)
{
try
{
Database1 db = new Database1();
MySqlConnection conn = db.getConnection();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "insert into reserved (vehicleID,startDate,endDate,projectID,projectName,duration) values('" + comboBox1.Text + "','" + startDate.Value.Date.ToString("yyyy-MM-dd") + "','" + endDate.Value.Date.ToString("yyyy-MM-dd") + "','" + projectID.Text + "','" + projectName.Text + "','" + duration.Text + "')";
cmd.ExecuteNonQuery();
conn.Close();
MessageBox.Show("The record wass inserterd success");
}
catch (SqlException ex)
{
MessageBox.Show(Convert.ToString(ex));
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
try
{
Database1 db = new Database1();
MySqlConnection conn = db.getConnection();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "update register set status='Not aviliable' where vehicleID='" + comboBox1.Text + "'";
cmd.ExecuteNonQuery();
conn.Close();
MessageBox.Show("the record wass updated success");
}
catch (SqlException ex)
{
MessageBox.Show(Convert.ToString(ex));
}
}
private void button2_Click(object sender, EventArgs e)
{
try
{
Database1 db = new Database1();
//string query = "select *from Employee";
MySqlConnection conn = db.getConnection();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "update register set vNo='" + vNo.Text + "',category='" + category.Text + "',vModel='" + vModel.Text + "',chassisNo='" + Convert.ToInt32(chassisNo.Text) + "',fuelType='" + fuelType.Text + "',engineNo='" + Convert.ToInt32(engineNo.Text) + "',manufactYear='" + manufactYear.Text + "' where vehicleID='" + vehicleID.Text + "'";
cmd.ExecuteNonQuery();
conn.Close();
MessageBox.Show("the record wass updated success");
}
catch (SqlException ex)
{
MessageBox.Show(Convert.ToString(ex));
}
}
private void add2_Click(object sender, EventArgs e)
{
try
{
Database1 db = new Database1();
MySqlConnection conn = db.getConnection();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "insert into repair (Rep_Id,Note,Rep_cost,V_Id) values('" + Rep_Id.Text + "','" + rNote.Text + "','" + Rep_Cost.Text + "','" + vId.Text + "')";
cmd.ExecuteNonQuery();
conn.Close();
MessageBox.Show("Success");
}
catch (MySqlException ex)
{
MessageBox.Show(Convert.ToString(ex));
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button1_Click_1(object sender, EventArgs e)
{
try
{
//byte[] image = null;
//FileStream streem = new FileStream(imageLocation, FileMode.Open, FileAccess.Read);
//BinaryReader brs = new BinaryReader(streem);
//image = brs.ReadBytes((int)streem.Length);
MemoryStream ms = new MemoryStream();
image1.Image.Save(ms, image1.Image.RawFormat);
byte[] img = ms.ToArray();
bool test = Validte_Data();
if (test == true)
{
Database1 db = new Database1();
MySqlConnection conn = db.getConnection();
MySqlCommand cmd = conn.CreateCommand();
string status = "Aviliable";
cmd.CommandText = "insert into register (vehicleID,vNo,category,vModel,chassisNo,fuelType,engineNo,manufactYear,image,status) values('" + vehicleID.Text + "','" + vNo.Text + "','" + category.Text + "','" + vModel.Text + "','" + Convert.ToInt32(chassisNo.Text) + "','" + fuelType.Text + "','" + Convert.ToInt32(engineNo.Text) + "','" + manufactYear.Text + "',@img,'" + status + "')";
cmd.Parameters.Add(new MySqlParameter("@img", MySqlDbType.LongBlob));
cmd.Parameters["@img"].Value = img;
// VehicleNo,vehicleManufact,vehicleModel,chassieNo,fuelType,enginNo,manufactYear ,'" + txt2.Text + "','" + txt3.Text + "','" + txt4.Text + "'," + txt5.Text + "','" + txt6.Text + "','" + txt7.Text + "','" + txt8.Text + "
cmd.ExecuteNonQuery();
conn.Close();
genarateID();
MessageBox.Show("the record wass inserterd success");
}
}
catch (MySqlException ex)
{
MessageBox.Show(Convert.ToString(ex));
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void add1_Click(object sender, EventArgs e)
{
try
{
Database1 db = new Database1();
MySqlConnection conn = db.getConnection();
MySqlCommand cmd = conn.CreateCommand();
fillcombo();
cmd.CommandText = "insert into services (Serv_No,Next_Milage,Note,Services,Current_Milage,V_Id,sCost) values('" + Serv_No.Text + "','" + Convert.ToInt32(Next_Milage.Text) + "','" + Note.Text + "','" + Services.Text + "','" + Convert.ToInt32(Current_Milage.Text) + "','" + V_Id.Text + "','" + Convert.ToDouble(sCost.Text) + "')";
cmd.ExecuteNonQuery();
conn.Close();
MessageBox.Show("Success");
}
catch (MySqlException ex)
{
MessageBox.Show(Convert.ToString(ex));
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void vehicle_details_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
int index = e.RowIndex;
DataGridViewRow selectedRow = vehicle_details.Rows[index];
vehicleID.Text = selectedRow.Cells[0].Value.ToString();
vNo.Text = selectedRow.Cells[1].Value.ToString();
category.Text = selectedRow.Cells[2].Value.ToString();
vModel.Text = selectedRow.Cells[3].Value.ToString();
chassisNo.Text = selectedRow.Cells[4].Value.ToString();
fuelType.Text = selectedRow.Cells[5].Value.ToString();
engineNo.Text = selectedRow.Cells[6].Value.ToString();
manufactYear.Text = selectedRow.Cells[7].Value.ToString();
avilibility.Text = selectedRow.Cells[9].Value.ToString();
try
{
Database1 db = new Database1();
MySqlConnection conn = db.getConnection();
MySqlCommand cmd = conn.CreateCommand();
// string query = "select *from register";
string sql = "select image from register where vNo='" + vNo.Text + "'";
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
cmd = new MySqlCommand(sql, conn);
MySqlDataReader DataRead = cmd.ExecuteReader();
DataRead.Read();
if (DataRead.HasRows)
{
//vehicleID.Text = DataRead[0].ToString();
byte[] image1 = (byte[])(DataRead[0]);
if (imageBox == null)
{
imageBox.Image = null;
}
else
{
MemoryStream mstreem = new MemoryStream(image1);
imageBox.Image = Image.FromStream(mstreem);
}
}
else
{
MessageBox.Show("Not Avilible");
}
conn.Close();
}
catch (Exception ex)
{
imageBox.Image = null;
}
}
