private void personalCarUseToolStripMenuItem_Click_1(object sender, EventArgs e)
{
Personal_Car_Use_Form o = new Personal_Car_Use_Form();
o.Show();
this.Hide();
}
private void personalCarUseToolStripMenuItem_Click(object sender, EventArgs e)
{
Personal_Car_Use_Form obj = new Personal_Car_Use_Form();
obj.Show();
Visible = false;
}
private void SubmitButton_Click(object sender, EventArgs e)
{
return_date = ReturnDatePicker.Value;
return_time = RetrunTimePicker.Value;
string req_num = RequisitionNumberComboBox.Text;
string tid = TeacherIdComboBox.Text;
int km = Int32.Parse(TotalKmTextBox.Text);
TimeSpan d1 = return_date - d;
TimeSpan t1 = return_time - stime;
int day = d1.Days;
int hours = day * 24 + t1.Hours;
if (t1.Minutes > 30)
{
hours = hours + 1;
}
int totalcost = 0;
SqlConnection cnn = new SqlConnection("Server=.\\SQLEXPRESS;Database=DTMS; Integrated Security=true");
SqlCommand cmd = new SqlCommand("select transport_rent_per_hour,transport_holdage_per_hour from transport where transport_number='" + transport_number + "' ;", cnn);
cnn.Open();
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
int trph = Int32.Parse(reader[0].ToString());
int thph = Int32.Parse(reader[1].ToString());
reader.Close();
totalcost = trph * km + thph * hours;
String Query = "insert into per_car_use (teacher_id,teacher_name,teacher_designation,transport_category,start_date,return_date,start_time,return_time,total_hours,total_km,total_taka) values ( '" + this.TeacherIdComboBox.Text + "' ,'" + tn + "', '" + td + "','" + tc + "','" + d + "','" + return_date + "','" + stime + "','" + return_time + "','" + hours + "','" + km + "','" + totalcost + "');";
cmd = new SqlCommand(Query, cnn);
//SqlDataReader MyReader;
cmd.ExecuteReader();
this.TeacherIdComboBox.Text = string.Empty;
//MessageBox.Show("Saved", "Result", MessageBoxButtons.OKCancel, MessageBoxIcon.Hand);
MessageBox.Show("saved");
Personal_Car_Use_Form obj = new Personal_Car_Use_Form();
obj.Show();
Visible = false;
}
