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