public void PreviewTextInput1(object sender, TextCompositionEventArgs e)
{
Get_String g = new Get_String();
string s = g.Vehicle_Number;
if (!string.IsNullOrWhiteSpace(s))
{
i = s.Length;
}
if (i < 2)
{
if (IsNumber(e.Text) == false)
{
i++;
}
else if (IsNumber(e.Text) == true)
{
e.Handled = true;
}
//else if (e.Text == ".")
//{
// if (((TextBox)sender).Text.IndexOf(e.Text) > -1)
// {
// e.Handled = true;
// }
//}
}
else
{
i = 1;
}
}
//*** Tyre Maintenance ***//
void lpg_tyre_entry_click(object sender, RoutedEventArgs e)
{
Get_String g = new Get_String();
g.Tyre_Vehicle_Number = "";
this.DataContext = g;
hide_all_panel();
tyre_panel.Visibility = System.Windows.Visibility.Visible;
}
private void User_Creation_panel_open(object sender, RoutedEventArgs e)
{
hide_all_panel();
user_create.Visibility = System.Windows.Visibility.Visible;
Get_String g = new Get_String();
g.Name = "";
this.DataContext = g;
}
void diesel_view_click(object sender, RoutedEventArgs e)
{
Get_String g = new Get_String();
g.Trip_Num = "";
this.DataContext = g;
hide_all_panel();
diesel_card_view.Visibility = Visibility.Visible;
}
public void deposit_entry_click(object sender, RoutedEventArgs e)
{
Get_String g = new Get_String();
g.Credit_Amount = "";
this.DataContext = g;
hide_all_panel();
diesel_card_deposit.Visibility = Visibility.Visible;
}
//*** Diesel Card Entry ***//
void diesel_card_entry_click(object sender, RoutedEventArgs e)
{
Get_String g = new Get_String();
g.Customer_Id = "";
g.Card_Id = "";
this.DataContext = g;
hide_all_panel();
diesel_panel.Visibility = Visibility.Visible;
}
public void driver_payment_click(object sender, RoutedEventArgs e)
{
Get_String g = new Get_String();
g.Month = "";
g.Year = "";
g.Expense_Cost = "0";
g.Remarks = "NOTHING";
g.Remarks_Amount = "0";
g.Salary = "0";
this.DataContext = g;
hide_all_panel();
driver_salary.Visibility = Visibility.Visible;
}
//*** Vehicle Entry Panel ***//
void New_Entry_Click(object sender, RoutedEventArgs e)
{
hide_all_panel();
vehicle_panel.Visibility = Visibility.Visible;
Get_String g = new Get_String();
g.Model = "";
g.Vehicle_Number = "";
g.Load_Number = "";
g.Trailer_Number = "";
g.Corporation = "";
g.Load_Model = "";
g.Trailer_Model = "";
this.DataContext = g;
}
void on_trip_checked(object sender, RoutedEventArgs e)
{
Get_String g = new Get_String();
g.Trip_Vehicle_Number = "";
this.DataContext = g;
Trip_Viewer.Clear();
Load.Visibility = System.Windows.Visibility.Visible;
//Unload.Visibility = System.Windows.Visibility.Hidden;
//Closed.Visibility = System.Windows.Visibility.Hidden;
Connection con = new Connection();
con.open_connection();
OdbcCommand cmd = new OdbcCommand("select vehicle_number from lpg_trip_details where trip_status='RUNNING'", con.conn);
OdbcDataAdapter da = new OdbcDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
viewcmb.Items.Clear();
viewcmb.Items.Add("ALL");
for (int i = 0; i < dt.Rows.Count; i++)
{
viewcmb.Items.Add(dt.Rows[i]["vehicle_number"]);
}
l1.Visibility = System.Windows.Visibility.Hidden;
l2.Visibility = System.Windows.Visibility.Hidden;
lpg_from.Visibility = System.Windows.Visibility.Hidden;
lpg_to.Visibility = System.Windows.Visibility.Hidden;
b1.Visibility = System.Windows.Visibility.Hidden;
Okay_btn.Visibility = System.Windows.Visibility.Visible;
viewcmb.Visibility = System.Windows.Visibility.Visible;
lpg_trip_expense.Visibility = System.Windows.Visibility.Hidden;
lpg_trip_expense.Text = "";
}
else
{
lpg_load_details_view.ItemsSource = null;
lpg_load_details_view.Items.Refresh();
MessageBox.Show("Record Not Found");
viewcmb.Items.Clear();
}
}
//*** Maintenance View ***//
void maintenance_view_panel_open(object sender, RoutedEventArgs e)
{
hide_all_panel();
maintenance_view_panel.Visibility = Visibility.Visible;
//Get_String g = new Get_String();
//g.Vehicle_Number = "";
//g.Month = "";
//g.Year = "";
//this.DataContext =g;
Get_String g = new Get_String();
g.Maintenance_Number = "";
g.Maintenance_Month = "";
g.Maintenance_Year = "";
this.DataContext = g;
}
void body_build_expense_view(object sender, RoutedEventArgs e)
{
Get_String g = new Get_String();
g.Body_Vehicle_Number = "";
g.Bill_Num = "";
this.DataContext = g;
btn1.Background = System.Windows.Media.Brushes.Yellow;
btn2.Background = System.Windows.Media.Brushes.Yellow;
btn3.Background = System.Windows.Media.Brushes.Green;
sample.Visibility = Visibility.Visible;
btnval = "V";
control_hide();
sample.ItemsSource = null;
sample.Items.Refresh();
}
public void Get_Details(string s1, string s2, string s3)
{
p1 = s1; p2 = s2; veh_no = s3;
if (!string.IsNullOrWhiteSpace(s3))
{
Connection con = new Connection();
con.connection_string();
OdbcCommand cmd = new OdbcCommand("select " + s1 + ",DATE_FORMAT(" + s2 + ",'%d-%m-%Y') AS date FROM trailer where vehicle_no='" + s3 + "'", con.str);
OdbcDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
string DR = dr[0].ToString();
if (!string.IsNullOrWhiteSpace(DR))
{
OdbcCommand cmd1 = new OdbcCommand("select no,starting_km,company from trailer_tyre_details where id='" + DR + "'", con.str);
OdbcDataReader dr1 = cmd1.ExecuteReader();
while (dr1.Read())
{
rmv_vehicle_tyre_number.Text = dr1[0].ToString();
rmv_vehicle_tyre_km.Text = dr1[1].ToString();
rmv_vehicle_tyre_company.Text = dr1[2].ToString();
rmv_vehicle_tyre_add_date.Text = dr[1].ToString();
tyre_details_remove_panel.Visibility = Visibility.Visible;
tyre_details_entry_panel.Visibility = System.Windows.Visibility.Hidden;
}
}
else
{
Get_String g = new Get_String();
g.Tyre_No = "";
g.Start_Km = "";
g.Tyre_Company = "";
g.Tyre_Price = "";
this.DataContext = g;
tyre_details_entry_panel.Visibility = System.Windows.Visibility.Visible;
tyre_details_remove_panel.Visibility = Visibility.Hidden;
}
}
con.close_string();
}
else
{
MessageBox.Show("Please Select Vehicle Number");
}
}
void Update_Click(object sender, RoutedEventArgs e)
{
hide_all_panel();
vehicle_update.Visibility = Visibility.Visible;
Get_String g = new Get_String();
g.Update_Trailer_Number = "";
g.Update_Trailer_Trans_Name = "";
g.Update_Load_Number = "";
g.Update_Load_Trans_Name = "";
g.Update_Model = "";
g.Update_Vehicle_Corporation = "";
g.Update_Vehicle_Number = "";
g.Up_Load_Model = "";
g.Up_Trailer_Model = "";
this.DataContext = g;
}
//*** Driver Details ***//
void driver_new_entry_click(object sender, RoutedEventArgs e)
{
hide_all_panel();
driver_panel.Visibility = Visibility.Visible;
Get_String g = new Get_String();
g.Driver_Name = "";
g.Licence_No = "";
g.Address = "";
g.Contact = "";
g.Referer_Name = "";
g.Bank_Name = "";
g.Acc_No = "";
g.Branch = "";
g.IFSC = "";
this.DataContext = g;
}
void driver_update_click(object sender, RoutedEventArgs e)
{
hide_all_panel();
driver_update.Visibility = Visibility.Visible;
Get_String g = new Get_String();
g.Update_Driver_Name1 = "";
g.Update_Licence_No = "";
g.Update_Address = "";
g.Update_Contact = "";
g.Update_Referer_Name = "";
g.Update_Bank_Name = "";
g.Update_Acc_No = "";
g.Update_Branch = "";
g.Update_IFSC = "";
this.DataContext = g;
}
public Profit_Viewer()
{
InitializeComponent();
year_cmbbox.Items.Clear();
int year = Convert.ToInt32(DateTime.Now.ToString("yyyy"));
for (int i = 1; i < 6; i++)
{
year_cmbbox.Items.Add(year);
year -= 1;
}
Get_String g = new Get_String();
g.Report_Month = "";
g.Report_Year = "";
this.DataContext = g;
month_cmbbox.IsEnabled = false;
year_cmbbox.IsEnabled = false;
}
void body_build_expense_update(object sender, RoutedEventArgs e)
{
Get_String g = new Get_String();
g.Body_Vehicle_Number = "";
g.Description = "";
g.Quantity = "1";
g.Rate = "";
g.Bill_No = "";
g.Discount = "";
this.DataContext = g;
btn1.Background = System.Windows.Media.Brushes.Yellow;
btn2.Background = System.Windows.Media.Brushes.Green;
btn3.Background = System.Windows.Media.Brushes.Yellow;
sample.Visibility = Visibility.Visible;
btnval = "E";
control_view();
sample.ItemsSource = null;
sample.Items.Refresh();
}
void closed_checked(object sender, RoutedEventArgs e)
{
Get_String g = new Get_String();
g.Trip_View_Number = "";
g.Trip_View_Year = "";
g.Trip_View_Month = "";
this.DataContext = g;
//Trip_Viewer2.Clear();
Load.Visibility = System.Windows.Visibility.Visible;
//Unload.Visibility = System.Windows.Visibility.Hidden;
//Closed.Visibility = System.Windows.Visibility.Visible;
Connection con = new Connection();
con.open_connection();
OdbcCommand cmd = new OdbcCommand("select CORPORATION,TRIP_NUMBER,DRIVER_NAME,ORIGIN,DESTINATION,DATE_FORMAT(load_date,'%d/%m/%Y') AS LOAD_DATE,DATE_FORMAT(unload_date,'%d/%m/%Y')AS UNLOAD_DATE,LOAD_WEIGHT,UNLOAD_WEIGHT,STARTING_KM,ENDING_KM,TOTAL_KM,TRIP_DIESEL,DIESEL_AMOUNT,TRIP_MILEAGE,TRIP_ADVANCE,TRIP_FRIEGHT,TRIP_EXPENSE,TRIP_BALANCE,TRIP_PROFIT,PAYMENT_TYPE from lpg_trip_details where trip_status='CLOSED'", con.conn);
OdbcDataAdapter da = new OdbcDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
l1.Visibility = System.Windows.Visibility.Visible;
l2.Visibility = System.Windows.Visibility.Visible;
lpg_from.Visibility = System.Windows.Visibility.Visible;
lpg_to.Visibility = System.Windows.Visibility.Visible;
b1.Visibility = System.Windows.Visibility.Visible;
Okay_btn.Visibility = System.Windows.Visibility.Hidden;
viewcmb.Visibility = System.Windows.Visibility.Hidden;
lpg_trip_expense.Visibility = System.Windows.Visibility.Visible;
lpg_trip_expense.Text = "";
}
else
{
lpg_load_details_view.ItemsSource = null;
lpg_load_details_view.Items.Refresh();
MessageBox.Show("Record Not Found");
}
}
void body_build_expense_insert(object sender, RoutedEventArgs e)
{
Get_String g = new Get_String();
g.Body_Vehicle_Number = "";
g.Description = "";
g.Quantity = "1";
g.Rate = "";
g.Bill_No = "";
g.Discount = "";
this.DataContext = g;
btn1.Background = System.Windows.Media.Brushes.Green;
btn2.Background = System.Windows.Media.Brushes.Yellow;
btn3.Background = System.Windows.Media.Brushes.Yellow;
sample.Visibility = Visibility.Visible;
btnval = "N";
control_view();
bill_date.Visibility = Visibility.Visible;
bill_no.Visibility = Visibility.Visible;
bill_num.Visibility = Visibility.Visible;
view_bill_number.Visibility = Visibility.Hidden;
add_all_bill_number.Visibility = Visibility.Hidden;
Connection con = new Connection();
con.connection_string();
OdbcCommand cmd = new OdbcCommand("delete from electrical", con.str);
cmd.ExecuteNonQuery();
con.close_string();
bill_num.IsEnabled = true;
bill_num.Text = "";
body_array_clear();
sample.ItemsSource = null;
sample.Items.Refresh();
body_descrip.Focus();
}
