void Payment_Report_Back_Click(object sender, RoutedEventArgs e)
{
Report_viewer.Clear();
//Report_viewer.Reset();
print_pay_slip_panel.Visibility = System.Windows.Visibility.Hidden;
}
void driver_salary_done_click(Object sender, RoutedEventArgs e)
{
string user = Properties.Settings.Default.User;
if (user == "ADMIN" || user == "MANAGER")
{
MessageBoxResult mr = MessageBox.Show("Are You Sure, Want To Insert Payment", "Insert Data", MessageBoxButton.OKCancel, MessageBoxImage.Question);
if (mr == MessageBoxResult.OK)
{
try
{
Connection con = new Connection();
con.open_connection();
double sa = 0;
double re = 0;
if (!string.IsNullOrWhiteSpace(salary.Text))
{
sa = Convert.ToDouble(salary.Text);
}
if (!string.IsNullOrWhiteSpace(remarks_reason.Text))
{
re = Convert.ToDouble(remarks_reason.Text);
}
// double profit = Convert.ToDouble(grand_profit.Content);
double payment = Convert.ToDouble(grand_pay.Content);
string MONTH = month.Text.Substring(0, 2);
if (sa == 0)
{
MessageBox.Show("Calculate Salary then press DONE Button");
}
else
{
driver_pay_img1.Visibility = System.Windows.Visibility.Hidden;
driver_pay_img2.Visibility = System.Windows.Visibility.Visible;
time1.Start();
OdbcCommand cmdd = new OdbcCommand("insert into driver_remarks(driver_id,remarks_reason,fine_amount,allowance,salary,grand_pay,remarks_month,remarks_year,total_trips,total_km,total_advance,total_expense,advance_balance,date)values('" + driver_id.Text + "','" + remarks.Text + "'," + re + "," + Convert.ToDouble(km_expense.Content) + ",'" + sa + "','" + payment + "','" + MONTH + "','" + year.Text + "','" + Convert.ToInt32(total_trip.Content) + "','" + Convert.ToInt32(total_km.Content) + "','" + Convert.ToInt32(driver_advance.Content) + "','" + Convert.ToDouble(expense.Content) + "','" + Convert.ToDouble(driver_balance.Content) + "',now())", con.conn);
cmdd.ExecuteNonQuery();
insert.Visibility = System.Windows.Visibility.Hidden;
MessageBoxResult mrs = MessageBox.Show("Are You Want payment Slip", "Pay Slip", MessageBoxButton.OKCancel, MessageBoxImage.Question);
if (mrs == MessageBoxResult.OK)
{
print_pay_slip_panel.Visibility = System.Windows.Visibility.Visible;
Report_viewer.LocalReport.ReportEmbeddedResource = "Project_Transport.Driver_Pay_Report.rdlc";
ReportParameter[] param = new ReportParameter[13];
param[0] = new ReportParameter("Title", Properties.Settings.Default.Title.ToString());
param[1] = new ReportParameter("MonthYear", month.Text.Substring(0, 2) + "/" + year.Text);
param[2] = new ReportParameter("Date", Convert.ToDateTime(DateTime.Now).ToString("dd/MM/yyyy"));
param[3] = new ReportParameter("Driver_id", driver_id.Text);
param[4] = new ReportParameter("Total_trip", total_trip.Content.ToString());
param[5] = new ReportParameter("Total_advance", driver_advance.Content.ToString());
param[6] = new ReportParameter("Expense", expense.Content.ToString());
param[7] = new ReportParameter("Balance", driver_balance.Content.ToString());
param[8] = new ReportParameter("Allowance", km_expense.Content.ToString());
param[9] = new ReportParameter("Remarks", remarks.Text);
param[10] = new ReportParameter("Fine", remarks_reason.Text);
param[11] = new ReportParameter("Salary", salary.Text);
param[12] = new ReportParameter("Grand_pay", grand_pay.Content.ToString());
Report_viewer.LocalReport.SetParameters(param);
Report_viewer.RefreshReport();
}
else if (mrs == MessageBoxResult.Cancel)
{
}
total_trip.Content = "0"; total_km.Content = "0"; driver_advance.Content = "0"; expense.Content = "0"; driver_balance.Content = "0"; expense_cost.Text = ""; expense_cost.IsEnabled = false;
km_expense.Content = "0"; salary.Text = "0"; remarks.Text = "NOTHING"; remarks_reason.Text = "0"; grand_pay.Content = "0"; month.Text = ""; year.Text = ""; driver_id.Text = "";
}
con.close_connection();
}
catch (OdbcException ex)
{
MessageBox.Show("Error :" + ex);
}
}
else if (mr == MessageBoxResult.Cancel)
{
}
}
else
{
MessageBox.Show("Access Denied");
}
}
