void full_view_Click(object seder, RoutedEventArgs e)
        {
            string user = Properties.Settings.Default.User;

            if (user == "ADMIN" || user == "MANAGER" || user == "USER")
            {
                try
                {
                    Connection con = new Connection();
                    con.open_connection();
                    OdbcCommand     cmd1 = new OdbcCommand("select DRIVER_NAME,VEHICLE_NUMBER,LICENCE_NUMBER,DATE_FORMAT(expiry,'%d/%m/%Y')AS EXPIRY,LICENCE_TYPE,ADDRESS,BANK_NAME,BRANCH,ACCOUNT_NO,CONTACT,DATE_FORMAT(join_date,'%d/%m/%Y')AS JOIN_DATE from driver_details where bool=0", con.conn);
                    OdbcDataAdapter da   = new OdbcDataAdapter(cmd1);
                    DataTable       dt   = new DataTable();
                    da.Fill(dt);
                    if (dt.Rows.Count > 0)
                    {
                        MainWindow m = new MainWindow();
                        Custom_Report.Clear();
                        Custom_Report.LocalReport.DataSources.Clear();
                        Custom_Report.Reset();
                        ReportDataSource ds = new ReportDataSource("Driver_Fullview_DataSet", dt);
                        Custom_Report.LocalReport.DataSources.Add(ds);
                        Custom_Report.LocalReport.ReportEmbeddedResource = "Project_Transport.Driver_Full_Report.rdlc";
                        ReportParameter[] param = new ReportParameter[2];
                        param[0] = new ReportParameter("Nos", dt.Rows.Count.ToString());
                        param[1] = new ReportParameter("Title", m.Title_Name.Content.ToString());
                        Custom_Report.LocalReport.SetParameters(param);
                        Custom_Report.RefreshReport();
                    }
                    else
                    {
                        MessageBox.Show("Driver Details Doesnot Exist");
                    }
                    con.close_connection();
                }
                catch (OdbcException ex)
                {
                    MessageBox.Show("Error :" + ex);
                }
            }
            else
            {
                MessageBox.Show("Access Denied");
            }
        }
        void get_driver_details(object sender, RoutedEventArgs e)

        {
            string user = Properties.Settings.Default.User;

            if (user == "ADMIN" || user == "MANAGER" || user == "USER")
            {
                Connection con = new Connection();

                if (!String.IsNullOrEmpty(combo.Text) && !String.IsNullOrEmpty(combo1.Text) && !String.IsNullOrEmpty(combo2.Text))
                {
                    try
                    {
                        MainWindow m = new MainWindow();
                        con.open_connection();
                        OdbcCommand     cmd = new OdbcCommand("select total_trips,total_km,total_advance,total_expense,advance_balance,remarks_reason,fine_amount,allowance,salary from driver_remarks where driver_id='" + combo.Text + "' AND remarks_month='" + combo1.Text.Substring(0, 2) + "'  AND remarks_year='" + combo2.Text + "'", con.conn);
                        OdbcDataAdapter da  = new OdbcDataAdapter(cmd);
                        DataTable       dt  = new DataTable();
                        da.Fill(dt);
                        if (dt.Rows.Count > 0)
                        {
                            string reason    = dt.Rows[0]["remarks_reason"].ToString();
                            string detuct    = dt.Rows[0]["fine_amount"].ToString();
                            string allowance = dt.Rows[0]["allowance"].ToString();
                            string salary    = dt.Rows[0]["salary"].ToString();
                            string km        = dt.Rows[0]["total_km"].ToString();
                            string trip      = dt.Rows[0]["total_trips"].ToString();
                            string advance   = dt.Rows[0]["total_advance"].ToString();
                            string expense   = dt.Rows[0]["total_expense"].ToString();
                            string balance   = dt.Rows[0]["advance_balance"].ToString();
                            Custom_Report.Reset();
                            Custom_Report.Clear();
                            ReportParameter[] param = new ReportParameter[13];
                            Custom_Report.LocalReport.ReportEmbeddedResource = "Project_Transport.Driver_Payment_Report.rdlc";
                            param[0]  = new ReportParameter("Title", m.Title_Name.Content.ToString());
                            param[1]  = new ReportParameter("Id", combo.Text);
                            param[2]  = new ReportParameter("Type", combo1.Text.Substring(0, 2) + "/" + combo2.Text);
                            param[3]  = new ReportParameter("Date", DateTime.Now.ToShortDateString());
                            param[4]  = new ReportParameter("Totalkm", km);
                            param[5]  = new ReportParameter("Advance", advance);
                            param[6]  = new ReportParameter("Expense", expense);
                            param[7]  = new ReportParameter("Balance", balance);
                            param[8]  = new ReportParameter("Reason", reason);
                            param[9]  = new ReportParameter("Remarks_Amount", detuct);
                            param[10] = new ReportParameter("Allowance", allowance);
                            param[11] = new ReportParameter("Salary", salary);
                            param[12] = new ReportParameter("Trips", trip);
                            Custom_Report.LocalReport.SetParameters(param);
                            Custom_Report.RefreshReport();
                            combo1.Text = ""; combo.Text = ""; combo2.Text = "";
                        }
                        else
                        {
                            MessageBox.Show("Payment not Availble");
                            combo1.Text = ""; combo.Text = ""; combo2.Text = "";
                        }
                    }
                    catch (OdbcException ex)
                    {
                        MessageBox.Show("Exception" + ex);
                    }
                }
                else if (!String.IsNullOrEmpty(combo.Text) && !String.IsNullOrEmpty(combo1.Text))
                {
                    try
                    {
                        int        year = DateTime.Now.Year;
                        MainWindow m    = new MainWindow();
                        con.open_connection();
                        OdbcCommand     cmd = new OdbcCommand("select total_trips,total_km,total_advance,total_expense,advance_balance,remarks_reason,fine_amount,allowance,salary from driver_remarks where driver_id='" + combo.Text + "' AND remarks_month='" + combo1.Text.Substring(0, 2) + "'  AND remarks_year='" + year + "'", con.conn);
                        OdbcDataAdapter da  = new OdbcDataAdapter(cmd);
                        DataTable       dt  = new DataTable();
                        da.Fill(dt);
                        if (dt.Rows.Count > 0)
                        {
                            string reason    = dt.Rows[0]["remarks_reason"].ToString();
                            string detuct    = dt.Rows[0]["fine_amount"].ToString();
                            string allowance = dt.Rows[0]["allowance"].ToString();
                            string salary    = dt.Rows[0]["salary"].ToString();
                            string km        = dt.Rows[0]["total_km"].ToString();
                            string trip      = dt.Rows[0]["total_trips"].ToString();
                            string advance   = dt.Rows[0]["total_advance"].ToString();
                            string expense   = dt.Rows[0]["total_expense"].ToString();
                            string balance   = dt.Rows[0]["advance_balance"].ToString();
                            Custom_Report.Reset();
                            Custom_Report.Clear();
                            ReportParameter[] param = new ReportParameter[13];
                            Custom_Report.LocalReport.ReportEmbeddedResource = "Project_Transport.Driver_Payment_Report.rdlc";
                            param[0]  = new ReportParameter("Title", m.Title_Name.Content.ToString());
                            param[1]  = new ReportParameter("Id", combo.Text);
                            param[2]  = new ReportParameter("Type", combo1.Text.Substring(0, 2) + "/" + year);
                            param[3]  = new ReportParameter("Date", DateTime.Now.ToShortDateString());
                            param[4]  = new ReportParameter("Totalkm", km);
                            param[5]  = new ReportParameter("Advance", advance);
                            param[6]  = new ReportParameter("Expense", expense);
                            param[7]  = new ReportParameter("Balance", balance);
                            param[8]  = new ReportParameter("Reason", reason);
                            param[9]  = new ReportParameter("Remarks_Amount", detuct);
                            param[10] = new ReportParameter("Allowance", allowance);
                            param[11] = new ReportParameter("Salary", salary);
                            param[12] = new ReportParameter("Trips", trip);
                            Custom_Report.LocalReport.SetParameters(param);
                            Custom_Report.RefreshReport();
                            combo1.Text = ""; combo.Text = ""; combo2.Text = "";
                        }
                        else
                        {
                            MessageBox.Show("Payment not Availble");
                            combo1.Text = ""; combo.Text = ""; combo2.Text = "";
                        }
                    }
                    catch (OdbcException ex)
                    {
                        MessageBox.Show("Exception" + ex);
                    }
                }
                else if (!String.IsNullOrEmpty(combo.Text) && !String.IsNullOrEmpty(combo2.Text))
                {
                    try
                    {
                        MainWindow m = new MainWindow();
                        con.open_connection();
                        OdbcCommand     cmd = new OdbcCommand("select remarks_month,total_trips,total_km,allowance,salary,fine_amount,(allowance+salary)-fine_amount as grand_total from driver_remarks where driver_id='" + combo.Text + "'  AND remarks_year='" + combo2.Text + "'", con.conn);
                        OdbcDataAdapter da  = new OdbcDataAdapter(cmd);
                        DataTable       dt  = new DataTable();
                        da.Fill(dt);
                        if (dt.Rows.Count > 0)
                        {
                            Custom_Report.Reset();
                            Custom_Report.Clear();
                            Custom_Report.LocalReport.DataSources.Clear();
                            ReportDataSource ds = new ReportDataSource("DataSet1", dt);
                            Custom_Report.LocalReport.DataSources.Add(ds);
                            ReportParameter[] param = new ReportParameter[4];
                            Custom_Report.LocalReport.ReportEmbeddedResource = "Project_Transport.Year_Wise_Payment_Report.rdlc";
                            param[0] = new ReportParameter("Title", m.Title_Name.Content.ToString());
                            param[1] = new ReportParameter("Id", combo.Text);
                            param[2] = new ReportParameter("Type", combo2.Text);
                            param[3] = new ReportParameter("Date", DateTime.Now.ToShortDateString());
                            Custom_Report.LocalReport.SetParameters(param);
                            Custom_Report.RefreshReport();
                            combo1.Text = ""; combo.Text = ""; combo2.Text = "";
                        }
                        else
                        {
                            MessageBox.Show("Record not Found");
                            combo1.Text = ""; combo.Text = ""; combo2.Text = "";
                        }
                    }
                    catch (OdbcException ex)
                    {
                        MessageBox.Show("Exception" + ex);
                    }
                }
                else if (!String.IsNullOrEmpty(combo.Text))
                {
                    try
                    {
                        MainWindow m = new MainWindow();
                        con.open_connection();
                        OdbcCommand     cmd = new OdbcCommand("select remarks_month,total_trips,total_km,allowance,salary,fine_amount,(allowance+salary)-fine_amount as grand_total from driver_remarks where driver_id='" + combo.Text + "'", con.conn);
                        OdbcDataAdapter da  = new OdbcDataAdapter(cmd);
                        DataTable       dt  = new DataTable();
                        da.Fill(dt);
                        if (dt.Rows.Count > 0)
                        {
                            Custom_Report.Reset();
                            Custom_Report.Clear();
                            Custom_Report.LocalReport.DataSources.Clear();
                            ReportDataSource ds = new ReportDataSource("DataSet1", dt);
                            Custom_Report.LocalReport.DataSources.Add(ds);
                            ReportParameter[] param = new ReportParameter[4];
                            Custom_Report.LocalReport.ReportEmbeddedResource = "Project_Transport.Year_Wise_Payment_Report.rdlc";
                            param[0] = new ReportParameter("Title", m.Title_Name.Content.ToString());
                            param[1] = new ReportParameter("Id", combo.Text);
                            param[2] = new ReportParameter("Type", "ALL");
                            param[3] = new ReportParameter("Date", DateTime.Now.ToShortDateString());
                            Custom_Report.LocalReport.SetParameters(param);
                            Custom_Report.RefreshReport();
                            combo1.Text = ""; combo.Text = ""; combo2.Text = "";
                        }
                        else
                        {
                            MessageBox.Show("Record not Found");
                            combo1.Text = ""; combo.Text = ""; combo2.Text = "";
                        }
                    }
                    catch (OdbcException ex)
                    {
                        MessageBox.Show("Exception" + ex);
                    }
                }
            }
            else
            {
                MessageBox.Show("Access Denied");
            }
        }