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();
}
}
