public Hire GetHireById(String Hire_ID) { try { string sql = "select * from Hire where Hire_Id ='" + Hire_ID + "' "; SqlCommand cmd = new SqlCommand(sql, m_con); m_con.Open(); SqlDataReader dreader = cmd.ExecuteReader(); // We are going to store vehicle data in this variable (Driver) Hire h = new Hire(); if (dreader.Read()) { h.Hire_Id = dreader[0].ToString(); h.D_Id = dreader[1].ToString(); h.C_Id = dreader[2].ToString(); h.V_Id = dreader[3].ToString(); h.V_Type_Id = dreader[4].ToString(); h.P_Id = dreader[5].ToString(); h.Base_Cost = dreader[6].ToString(); dreader.Close(); return(h); } else { return(null); } } catch (Exception ex) { return(null); } finally { m_con.Close(); } }
private double doCalculation_Hire() { try { if (comboBox8.SelectedValue != null && comboBox9.SelectedValue != null) { string vTypeName = comboBox8.Text; string vTypeID = comboBox8.SelectedValue.ToString(); PrintConsole("on Changed combo1 vTypeName ", vTypeName); PrintConsole("on Changed combo1 vTypeID ", vTypeID); string packageName = comboBox9.Text; string packageId = comboBox9.SelectedValue.ToString(); PrintConsole("on Changed combo1 driverName ", packageName); PrintConsole("on Changed combo1 driverId ", packageId); h = c.GetHireById(vTypeID); string sql_1 = "select * from Package where V_Type_Id ='" + comboBox8.SelectedValue + "' "; SqlCommand cmd_1 = new SqlCommand(sql_1, m_con); m_con.Open(); SqlDataReader dreader_1 = cmd_1.ExecuteReader(); try { if (dreader_1.Read()) { PrintConsole("Sithumini", dreader_1[5].ToString()); PrintConsole("Sithumini_s", comboBox9.SelectedValue.ToString()); if (dreader_1[0].ToString().Equals(comboBox9.SelectedValue.ToString())) { PrintConsole("Base_Cost ", dreader_1[6].ToString()); BaseCost = Convert.ToInt32(dreader_1[6].ToString()); //hireBaseCost = Convert.ToInt32(dreader[6].ToString()); if (radioButton1.Checked == true) { lblbasehirecharge.Text = BaseCost.ToString(); label45.Text = "...".ToString(); } if (radioButton2.Checked == true) { label45.Text = BaseCost.ToString(); lblbasehirecharge.Text = "...".ToString(); } } } dreader_1.Close(); } catch (Exception ex) { MessageBox.Show("Error"); } finally { m_con.Close(); } string startKm = textBox4.Text; PrintConsole("Start km ", startKm.ToString()); PrintConsole("Start km String.IsNullOrEmpty(startKm)", String.IsNullOrEmpty(startKm) + ""); string endKm = textBox5.Text; PrintConsole("End km ", endKm.ToString()); int sk = 0; int ek = 0; if (!String.IsNullOrEmpty(startKm)) { sk = Convert.ToInt32(startKm); } if (!String.IsNullOrEmpty(endKm)) { ek = Convert.ToInt32(endKm); } int distance = ek - sk; PrintConsole("Distance ", distance.ToString()); p = c.GetPackageById(packageId); PrintConsole("MaxKm ", p.Max_Km.ToString()); int Max_Km = Convert.ToInt32(p.Max_Km); int Extra_Km_Rate = Convert.ToInt32(p.Extra_Km_Rate); int packagecost = Convert.ToInt32(p.Cost); if (Max_Km < distance) { extrakmcharge = (distance - Max_Km) * Extra_Km_Rate; PrintConsole("extrakmcharge ", extrakmcharge.ToString()); if (radioButton1.Checked == true) { label44.Text = extrakmcharge.ToString(); label47.Text = "...".ToString(); } if (radioButton2.Checked == true) { label47.Text = extrakmcharge.ToString(); label44.Text = "...".ToString(); } } else { label44.Text = "...".ToString(); label47.Text = "...".ToString(); } DateTime starttime = dateTimePicker5.Value; DateTime endtime = dateTimePicker6.Value; PrintConsole("starttime ", starttime.ToString()); PrintConsole("endtime ", endtime.ToString()); TimeSpan timedifference = endtime - starttime; PrintConsole("timedifference ", timedifference.ToString()); double tdf = timedifference.TotalHours; PrintConsole("tdf ", tdf.ToString()); p = c.GetPackageById(packageId); int Extra_Hr_Rate = Convert.ToInt32(p.Extra_Hr_Rate); PrintConsole("Extra hr rate ", p.Extra_Hr_Rate.ToString()); int Max_Hr = Convert.ToInt32(p.Max_Hr); if (tdf > Max_Hr) { waitingcharge = (tdf - Max_Hr) * Extra_Hr_Rate; PrintConsole("waitingcharge ", waitingcharge.ToString()); if (radioButton1.Checked == true) { label43.Text = Math.Round(waitingcharge, 2).ToString(); } if (radioButton2.Checked == true) { label43.Text = "...".ToString(); } } DateTime d3 = dateTimePicker3.Value; DateTime d4 = dateTimePicker4.Value; TimeSpan t = d4 - d3; double dDays = t.TotalDays; days = Convert.ToInt32(dDays); PrintConsole("Number of days ", days.ToString()); v = c.GetVehicleTypeById(vTypeID); p = c.GetPackageById(packageId); h = c.GetHireById(vTypeID); int vehicle_night_park_rate = Convert.ToInt32(p.Vehicle_Night_Park_Rate_Per_Night); int driver_overnight_rate = Convert.ToInt32(p.Driver_Overnight_Rate_Per_Night); if (days >= 2) { overnightstaycharge = (days * vehicle_night_park_rate) + (days * driver_overnight_rate); PrintConsole("overnightstaycharge ", overnightstaycharge.ToString()); if (radioButton2.Checked == true) { label46.Text = overnightstaycharge.ToString(); } if (radioButton1.Checked == true) { label46.Text = "...".ToString(); } } //h = c.GetHireById(vTypeID); //string sql_1 = "select * from Package where V_Type_Id ='" + comboBox8.SelectedValue + "' "; //SqlCommand cmd_1 = new SqlCommand(sql_1, m_con); //m_con.Open(); //SqlDataReader dreader_1 = cmd_1.ExecuteReader(); //try //{ // if (dreader_1.Read()) // { // PrintConsole("Sithumini", dreader_1[5].ToString()); // PrintConsole("Sithumini_s", comboBox9.SelectedValue.ToString()); // if (dreader_1[0].ToString().Equals(comboBox9.SelectedValue.ToString())) // { // PrintConsole("Base_Cost ", dreader_1[6].ToString()); // BaseCost = Convert.ToInt32(dreader_1[6].ToString()); // //hireBaseCost = Convert.ToInt32(dreader[6].ToString()); // if (radioButton1.Checked == true) // { // lblbasehirecharge.Text = BaseCost.ToString(); // label45.Text = "...".ToString(); // } // if (radioButton2.Checked == true) // { // label45.Text = BaseCost.ToString(); // lblbasehirecharge.Text = "...".ToString(); // } // } // } // dreader_1.Close(); //} //catch (Exception ex) //{ // MessageBox.Show("Error"); //} //finally //{ // m_con.Close(); //} if (radioButton1.Checked == true) { totalhirecost = BaseCost + waitingcharge + extrakmcharge; PrintConsole("Day total", totalhirecost.ToString()); label27.Text = totalhirecost.ToString(); label50.Text = "...".ToString(); //int totalhirecost = Convert.ToInt32(totalhire); } if (radioButton2.Checked == true) { totalhirecost = BaseCost + overnightstaycharge + extrakmcharge; PrintConsole("long tour", totalhirecost.ToString()); label50.Text = totalhirecost.ToString(); label27.Text = "...".ToString(); //it totalhirecost = Convert.ToInt32(totalhire); } } } catch (Exception ex) { MessageBox.Show("Error"); } return(totalhirecost); }