private void button5_Click(object sender, EventArgs e) { this.Hide(); WorkTicketSummary ss = new WorkTicketSummary(label2.Text); ss.Show(); }
private void button7_Click(object sender, EventArgs e) { if (txtFinalReading.Text == "") { MessageBox.Show("Please enter final speed reading"); } else { //Computing journey Kilometer double j1, j2, z; double.TryParse(txtFinalReading.Text, out j1); double.TryParse(dgv1[4, dgv1.Rows.Count - 1].Value.ToString(), out j2); z = j1 - j2; if (z > 0) { txtKm.Text = z.ToString("c").Remove(0, 1); } else if (z == 0) { MessageBox.Show("The Vehicle " + cmbRegNo + "did not make a journey"); } //txtPayments.Text = dgvAccounts3[11, dgvAccounts3.Rows.Count - 1].Value.ToString(); //double.TryParse(txtOthers.Text, out d1); //s = a1 + b1 + c1 + d1; //if (s > 0) // txtTotalExpenses.Text = s.ToString("c").Remove(0, 1); using (SqlConnection sqlCon = new SqlConnection(connectionString)) { foreach (DataGridViewRow row in dgv1.Rows) { for (int i = 0; i < dgv1.Rows.Count; i++) { if (cmbSatation.SelectedIndex == 0) { sqlCon.Open(); SqlCommand sqlCmd = new SqlCommand("FinalEntry", sqlCon); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.AddWithValue("@UserID", 0); sqlCmd.Parameters.AddWithValue("@DriverID", dgv1.Rows[i].Cells["txtDriverID"].Value); sqlCmd.Parameters.AddWithValue("@DriverName", dgv1.Rows[i].Cells["txtDriverName"].Value); sqlCmd.Parameters.AddWithValue("@RegNo", dgv1.Rows[i].Cells["txtRegNo"].Value); sqlCmd.Parameters.AddWithValue("@MileageReading", dgv1.Rows[i].Cells["txtMileageReading"].Value); sqlCmd.Parameters.AddWithValue("@OilDrawn", dgv1.Rows[i].Cells["txtOilDrawn"].Value); sqlCmd.Parameters.AddWithValue("@FuelDrawn", dgv1.Rows[i].Cells["txtFuelDrawn"].Value); sqlCmd.Parameters.AddWithValue("@Destination", dgv1.Rows[i].Cells["txtDestination"].Value); sqlCmd.Parameters.AddWithValue("@lpgStation", dgv1.Rows[i].Cells["txtlpgStation"].Value); sqlCmd.Parameters.AddWithValue("@Date", dgv1.Rows[i].Cells["txtDate"].Value); sqlCmd.Parameters.AddWithValue("@VoucherNo", dgv1.Rows[i].Cells["txtVoucherNo"].Value); sqlCmd.Parameters.AddWithValue("@@FinalSpeedReading", txtFinalReading.Text.Trim()); sqlCmd.Parameters.AddWithValue("@journeyKilometer", txtKm.Text.Trim());; sqlCmd.Parameters.AddWithValue("@AuthorizingOfficerName", dgv1.Rows[i].Cells["txtAuthorizingOfficerName"].Value); sqlCmd.Parameters.AddWithValue("@AuthorizingOfficerNo", dgv1.Rows[i].Cells["txtAuthorizingOfficerNo"].Value); sqlCmd.Parameters.AddWithValue("@AuthorizingOfficerDesignation", dgv1.Rows[i].Cells["txtAuthorizingOfficerDesignation"].Value); sqlCmd.ExecuteNonQuery(); sqlCon.Close(); } if (cmbSatation.SelectedIndex == 1) { sqlCon.Open(); SqlCommand sqlCmd = new SqlCommand("FinalEntry2", sqlCon); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.AddWithValue("@UserID", 0); sqlCmd.Parameters.AddWithValue("@DriverID", dgv1.Rows[i].Cells["txtDriverID"].Value); sqlCmd.Parameters.AddWithValue("@DriverName", dgv1.Rows[i].Cells["txtDriverName"].Value); sqlCmd.Parameters.AddWithValue("@RegNo", dgv1.Rows[i].Cells["txtRegNo"].Value); sqlCmd.Parameters.AddWithValue("@MileageReading", dgv1.Rows[i].Cells["txtMileageReading"].Value); sqlCmd.Parameters.AddWithValue("@OilDrawn", dgv1.Rows[i].Cells["txtOilDrawn"].Value); sqlCmd.Parameters.AddWithValue("@FuelDrawn", dgv1.Rows[i].Cells["txtFuelDrawn"].Value); sqlCmd.Parameters.AddWithValue("@Destination", dgv1.Rows[i].Cells["txtDestination"].Value); sqlCmd.Parameters.AddWithValue("@lpgStation", dgv1.Rows[i].Cells["txtlpgStation"].Value); sqlCmd.Parameters.AddWithValue("@Date", dgv1.Rows[i].Cells["txtDate"].Value); sqlCmd.Parameters.AddWithValue("@VoucherNo", dgv1.Rows[i].Cells["txtVoucherNo"].Value); sqlCmd.Parameters.AddWithValue("@FinalSpeedReading", txtFinalReading.Text.Trim()); sqlCmd.Parameters.AddWithValue("@journeyKilometer", txtKm.Text.Trim());; sqlCmd.Parameters.AddWithValue("@AuthorizingOfficerName", dgv1.Rows[i].Cells["txtAuthorizingOfficerName"].Value); sqlCmd.Parameters.AddWithValue("@AuthorizingOfficerNo", dgv1.Rows[i].Cells["txtAuthorizingOfficerNo"].Value); sqlCmd.Parameters.AddWithValue("@AuthorizingOfficerDesignation", dgv1.Rows[i].Cells["txtAuthorizingOfficerDesignation"].Value); sqlCmd.ExecuteNonQuery(); sqlCon.Close(); } if (cmbSatation.SelectedIndex == 2) { sqlCon.Open(); SqlCommand sqlCmd = new SqlCommand("FinalEntry3", sqlCon); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.AddWithValue("@UserID", 0); sqlCmd.Parameters.AddWithValue("@DriverID", dgv1.Rows[i].Cells["txtDriverID"].Value); sqlCmd.Parameters.AddWithValue("@DriverName", dgv1.Rows[i].Cells["txtDriverName"].Value); sqlCmd.Parameters.AddWithValue("@RegNo", dgv1.Rows[i].Cells["txtRegNo"].Value); sqlCmd.Parameters.AddWithValue("@MileageReading", dgv1.Rows[i].Cells["txtMileageReading"].Value); sqlCmd.Parameters.AddWithValue("@OilDrawn", dgv1.Rows[i].Cells["txtOilDrawn"].Value); sqlCmd.Parameters.AddWithValue("@FuelDrawn", dgv1.Rows[i].Cells["txtFuelDrawn"].Value); sqlCmd.Parameters.AddWithValue("@Destination", dgv1.Rows[i].Cells["txtDestination"].Value); sqlCmd.Parameters.AddWithValue("@lpgStation", dgv1.Rows[i].Cells["txtlpgStation"].Value); sqlCmd.Parameters.AddWithValue("@Date", dgv1.Rows[i].Cells["txtDate"].Value); sqlCmd.Parameters.AddWithValue("@VoucherNo", dgv1.Rows[i].Cells["txtVoucherNo"].Value); sqlCmd.Parameters.AddWithValue("@@FinalSpeedReading", txtFinalReading.Text.Trim()); sqlCmd.Parameters.AddWithValue("@journeyKilometer", txtKm.Text.Trim());; sqlCmd.Parameters.AddWithValue("@AuthorizingOfficerName", dgv1.Rows[i].Cells["txtAuthorizingOfficerName"].Value); sqlCmd.Parameters.AddWithValue("@AuthorizingOfficerNo", dgv1.Rows[i].Cells["txtAuthorizingOfficerNo"].Value); sqlCmd.Parameters.AddWithValue("@AuthorizingOfficerDesignation", dgv1.Rows[i].Cells["txtAuthorizingOfficerDesignation"].Value); sqlCmd.ExecuteNonQuery(); sqlCon.Close(); } } } } this.Hide(); WorkTicketSummary ss = new WorkTicketSummary(label3.Text); ss.Show(); } }