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