/// <summary>
/// Create InvoiceDetailFromToInvoicesDateNotPaid binding s ource data
/// </summary>
/// <param name="fromDate">The fromDate value</param>
/// <param name="toDate">The toDate value</param>
/// <returns>The report binding source collection.</returns>
public virtual Nequeo.Model.DataSource.BindingSourceData[] InvoiceDetailFromToInvoicesDateNotPaid(DateTime?fromDate, DateTime?toDate)
{
// Assign the binding sources
Nequeo.DataAccess.NequeoCompany.DataSet.StoredProcedures dataSet = new Nequeo.DataAccess.NequeoCompany.DataSet.StoredProcedures();
System.Windows.Forms.BindingSource bindingSource = new System.Windows.Forms.BindingSource();
bindingSource.DataMember = "GetInvoiceDetailsBetweenDateNotPaid";
bindingSource.DataSource = dataSet;
// Get the data
Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetInvoiceDetailsBetweenDateNotPaidTableAdapter tableAdapter =
new Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetInvoiceDetailsBetweenDateNotPaidTableAdapter();
tableAdapter.ClearBeforeFill = true;
tableAdapter.Fill(dataSet.GetInvoiceDetailsBetweenDateNotPaid, fromDate, toDate);
// Return the data within the binding source.
return(new Model.DataSource.BindingSourceData[]
{
new Model.DataSource.BindingSourceData()
{
DataSource = bindingSource, DataSourceName = "GetInvoiceDetailsBetweenDateNotPaid",
BindingSourceParameters = new Nequeo.Model.DataSource.BindingSourceParameter[]
{
new Nequeo.Model.DataSource.BindingSourceParameter()
{
Name = "ReportTitle",
Value = Convert.ToString("Invoice Not Paid Details From: " + fromDate.Value.ToShortDateString() + " To: " + toDate.Value.ToShortDateString()),
ValueType = typeof(String)
},
}
},
});
}
/// <summary>
/// Create SuperAccount binding s ource data
/// </summary>
/// <param name="employeeID">The employeeID value</param>
/// <returns><returns>The report binding source collection.</returns></returns>
public virtual Nequeo.Model.DataSource.BindingSourceData[] SuperAccount(int?employeeID)
{
// Assign the binding sources
Nequeo.DataAccess.NequeoCompany.DataSet.StoredProcedures dataSet = new Nequeo.DataAccess.NequeoCompany.DataSet.StoredProcedures();
System.Windows.Forms.BindingSource bindingSource = new System.Windows.Forms.BindingSource();
bindingSource.DataMember = "GetSelectedEmployeeSuperAccount";
bindingSource.DataSource = dataSet;
// Get the data
Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetSelectedEmployeeSuperAccountTableAdapter tableAdapter =
new Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetSelectedEmployeeSuperAccountTableAdapter();
tableAdapter.ClearBeforeFill = true;
tableAdapter.Fill(dataSet.GetSelectedEmployeeSuperAccount, employeeID);
// Return the data within the binding source.
return(new Model.DataSource.BindingSourceData[]
{
new Model.DataSource.BindingSourceData()
{
DataSource = bindingSource, DataSourceName = "GetSelectedEmployeeSuperAccount",
BindingSourceParameters = new Nequeo.Model.DataSource.BindingSourceParameter[]
{
new Nequeo.Model.DataSource.BindingSourceParameter()
{
Name = "ReportTitle",
Value = "Employee Super Account",
ValueType = typeof(String)
},
}
},
});
}
/// <summary>
/// Create SuperFromToDateSummary binding s ource data
/// </summary>
/// <param name="fromDate">The fromDate value</param>
/// <param name="toDate">The toDate value</param>
/// <returns><returns>The report binding source collection.</returns></returns>
public virtual Nequeo.Model.DataSource.BindingSourceData[] SuperFromToDateSummary(DateTime?fromDate, DateTime?toDate)
{
// Assign the binding sources
Nequeo.DataAccess.NequeoCompany.DataSet.StoredProcedures dataSet = new Nequeo.DataAccess.NequeoCompany.DataSet.StoredProcedures();
System.Windows.Forms.BindingSource bindingSource = new System.Windows.Forms.BindingSource();
bindingSource.DataMember = "GetEmployeeSuperBetweenDate";
bindingSource.DataSource = dataSet;
// Get the data
Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetEmployeeSuperBetweenDateTableAdapter tableAdapter =
new Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetEmployeeSuperBetweenDateTableAdapter();
tableAdapter.ClearBeforeFill = true;
tableAdapter.Fill(dataSet.GetEmployeeSuperBetweenDate, fromDate, toDate);
// Return the data within the binding source.
return(new Model.DataSource.BindingSourceData[]
{
new Model.DataSource.BindingSourceData()
{
DataSource = bindingSource, DataSourceName = "GetEmployeeSuperBetweenDate",
BindingSourceParameters = new Nequeo.Model.DataSource.BindingSourceParameter[]
{
new Nequeo.Model.DataSource.BindingSourceParameter()
{
Name = "ReportTitle",
Value = "Employee Superannuation From :" + fromDate.Value.ToShortDateString() + " To : " + toDate.Value.ToShortDateString(),
ValueType = typeof(String)
},
}
},
});
}
/// <summary>
/// Create TransactionFromToDataMemberDateID binding s ource data
/// </summary>
/// <param name="fromDate">The fromDate value</param>
/// <param name="toDate">The toDate value</param>
/// <param name="dataMember">The dataMember value</param>
/// <param name="dataMemberID">The dataMemberID value</param>
/// <returns><returns>The report binding source collection.</returns></returns>
public virtual Nequeo.Model.DataSource.BindingSourceData[] TransactionFromToDataMemberDateID(DateTime?fromDate, DateTime?toDate, string dataMember, int?dataMemberID)
{
// Assign the binding sources
Nequeo.DataAccess.NequeoCompany.DataSet.StoredProcedures dataSet = new Nequeo.DataAccess.NequeoCompany.DataSet.StoredProcedures();
System.Windows.Forms.BindingSource bindingSource = new System.Windows.Forms.BindingSource();
bindingSource.DataMember = "GetAccountTransactionsMemberFromToDateByID";
bindingSource.DataSource = dataSet;
System.Windows.Forms.BindingSource bindingSource1 = new System.Windows.Forms.BindingSource();
bindingSource1.DataMember = "GetAccountTransactionCreditsMemberFromToDateByID";
bindingSource1.DataSource = new Nequeo.DataAccess.NequeoCompany.Data.Extension.AccountTransactions().GetAccountTransactionCreditsMemberFromToDateByID(fromDate, toDate, dataMember, dataMemberID);
System.Windows.Forms.BindingSource bindingSource2 = new System.Windows.Forms.BindingSource();
bindingSource2.DataMember = "GetAccountTransactionDebitsMemberFromToDateByID";
bindingSource2.DataSource = new Nequeo.DataAccess.NequeoCompany.Data.Extension.AccountTransactions().GetAccountTransactionDebitsMemberFromToDateByID(fromDate, toDate, dataMember, dataMemberID);
// Get the data
Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetAccountTransactionsMemberFromToDateByIDTableAdapter tableAdapter =
new Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetAccountTransactionsMemberFromToDateByIDTableAdapter();
tableAdapter.ClearBeforeFill = true;
tableAdapter.Fill(dataSet.GetAccountTransactionsMemberFromToDateByID, fromDate, toDate, dataMember, dataMemberID);
// Return the data within the binding source.
return(new Model.DataSource.BindingSourceData[]
{
new Model.DataSource.BindingSourceData()
{
DataSource = bindingSource, DataSourceName = "GetAccountTransactionsMemberFromToDateByID",
BindingSourceParameters = new Nequeo.Model.DataSource.BindingSourceParameter[]
{
new Nequeo.Model.DataSource.BindingSourceParameter()
{
Name = "ReportTitle",
Value = "Account Transaction Payment " + dataMember + ", Member ID " + dataMemberID.ToString(),
ValueType = typeof(String)
},
}
},
new Model.DataSource.BindingSourceData()
{
DataSource = bindingSource1, DataSourceName = "GetAccountTransactionCreditsMemberFromToDateByID"
},
new Model.DataSource.BindingSourceData()
{
DataSource = bindingSource2, DataSourceName = "GetAccountTransactionDebitsMemberFromToDateByID"
},
});
}
/// <summary>
/// Create IncomeFromToDateID binding s ource data
/// </summary>
/// <param name="fromDate">The fromDate value</param>
/// <param name="toDate">The toDate value</param>
/// <param name="customerID">The customerID value</param>
/// <returns>The report binding source collection.</returns>
public virtual Nequeo.Model.DataSource.BindingSourceData[] IncomeFromToDateID(DateTime?fromDate, DateTime?toDate, int?customerID)
{
// Assign the binding sources
Nequeo.DataAccess.NequeoCompany.DataSet.StoredProcedures dataSet = new Nequeo.DataAccess.NequeoCompany.DataSet.StoredProcedures();
System.Windows.Forms.BindingSource bindingSource = new System.Windows.Forms.BindingSource();
bindingSource.DataMember = "GetSelectedCustomerIncomeInvoiceDetailsBetweenDate";
bindingSource.DataSource = dataSet;
System.Windows.Forms.BindingSource bindingSource1 = new System.Windows.Forms.BindingSource();
bindingSource1.DataMember = "GetSelectedCustomerIncomeInvoiceProductsBetweenDate";
bindingSource1.DataSource = dataSet;
// Get the data
Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetSelectedCustomerIncomeInvoiceDetailsBetweenDateTableAdapter tableAdapter =
new Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetSelectedCustomerIncomeInvoiceDetailsBetweenDateTableAdapter();
tableAdapter.ClearBeforeFill = true;
tableAdapter.Fill(dataSet.GetSelectedCustomerIncomeInvoiceDetailsBetweenDate, fromDate, toDate, customerID);
Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetSelectedCustomerIncomeInvoiceProductsBetweenDateTableAdapter tableAdapter1 =
new Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetSelectedCustomerIncomeInvoiceProductsBetweenDateTableAdapter();
tableAdapter1.ClearBeforeFill = true;
tableAdapter1.Fill(dataSet.GetSelectedCustomerIncomeInvoiceProductsBetweenDate, fromDate, toDate, customerID);
// Return the data within the binding source.
return(new Model.DataSource.BindingSourceData[]
{
new Model.DataSource.BindingSourceData()
{
DataSource = bindingSource, DataSourceName = "GetSelectedCustomerIncomeInvoiceDetailsBetweenDate",
BindingSourceParameters = new Nequeo.Model.DataSource.BindingSourceParameter[]
{
new Nequeo.Model.DataSource.BindingSourceParameter()
{
Name = "ReportTitle",
Value = Convert.ToString("Customer Income From: " + fromDate.Value.ToShortDateString() + " To: " + toDate.Value.ToShortDateString()),
ValueType = typeof(String)
},
}
},
new Model.DataSource.BindingSourceData()
{
DataSource = bindingSource1, DataSourceName = "GetSelectedCustomerIncomeInvoiceProductsBetweenDate"
},
});
}
/// <summary>
/// Create TransactionFromToDatePaidToByAndID binding s ource data
/// </summary>
/// <param name="fromDate">The fromDate value</param>
/// <param name="toDate">The toDate value</param>
/// <param name="accountID">The accountID value</param>
/// <param name="dataMember">The dataMember value</param>
/// <param name="dataMemberID">The dataMemberID value</param>
/// <returns><returns>The report binding source collection.</returns></returns>
public virtual Nequeo.Model.DataSource.BindingSourceData[] TransactionFromToDatePaidToByAndID(DateTime?fromDate, DateTime?toDate, int?accountID, string dataMember, int?dataMemberID)
{
// Assign the binding sources
Nequeo.DataAccess.NequeoCompany.DataSet.StoredProcedures dataSet = new Nequeo.DataAccess.NequeoCompany.DataSet.StoredProcedures();
System.Windows.Forms.BindingSource bindingSource = new System.Windows.Forms.BindingSource();
bindingSource.DataMember = "GetAccountTransactionsFromToDatePaidToByAndID";
bindingSource.DataSource = dataSet;
System.Windows.Forms.BindingSource bindingSource1 = new System.Windows.Forms.BindingSource();
bindingSource1.DataMember = "GetAccountTransactionCreditsFromToDatePaidToByAndID";
bindingSource1.DataSource = new Nequeo.DataAccess.NequeoCompany.Data.Extension.AccountTransactions().GetAccountTransactionCreditsFromToDatePaidToByAndID(fromDate, toDate, accountID, dataMember, dataMemberID);
System.Windows.Forms.BindingSource bindingSource2 = new System.Windows.Forms.BindingSource();
bindingSource2.DataMember = "GetAccountTransactionDebitsFromToDatePaidToByAndID";
bindingSource2.DataSource = new Nequeo.DataAccess.NequeoCompany.Data.Extension.AccountTransactions().GetAccountTransactionDebitsFromToDatePaidToByAndID(fromDate, toDate, accountID, dataMember, dataMemberID);
// Get the data
Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetAccountTransactionsFromToDatePaidToByAndIDTableAdapter tableAdapter =
new Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetAccountTransactionsFromToDatePaidToByAndIDTableAdapter();
tableAdapter.ClearBeforeFill = true;
tableAdapter.Fill(dataSet.GetAccountTransactionsFromToDatePaidToByAndID, fromDate, toDate, accountID, dataMember, dataMemberID);
// Return the data within the binding source.
return(new Model.DataSource.BindingSourceData[]
{
new Model.DataSource.BindingSourceData()
{
DataSource = bindingSource, DataSourceName = "GetAccountTransactionsFromToDatePaidToByAndID"
},
new Model.DataSource.BindingSourceData()
{
DataSource = bindingSource1, DataSourceName = "GetAccountTransactionCreditsFromToDatePaidToByAndID"
},
new Model.DataSource.BindingSourceData()
{
DataSource = bindingSource2, DataSourceName = "GetAccountTransactionDebitsFromToDatePaidToByAndID"
},
});
}
/// <summary>
/// Create InvoiceDetailTaxInvoice binding s ource data
/// </summary>
/// <param name="invoiceID">The invoiceID value</param>
/// <param name="companyID">The companyID value</param>
/// <param name="accountID">The accountID value</param>
/// <returns>The report binding source collection.</returns>
public virtual Nequeo.Model.DataSource.BindingSourceData[] InvoiceDetailTaxInvoice(int?invoiceID, int?companyID, int?accountID)
{
// Assign the binding sources
Nequeo.DataAccess.NequeoCompany.DataSet.StoredProcedures dataSet = new Nequeo.DataAccess.NequeoCompany.DataSet.StoredProcedures();
System.Windows.Forms.BindingSource bindingSource = new System.Windows.Forms.BindingSource();
bindingSource.DataMember = "GetSelectedInvoiceDetails";
bindingSource.DataSource = dataSet;
// Get the data
Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetSelectedInvoiceDetailsTableAdapter tableAdapter =
new Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetSelectedInvoiceDetailsTableAdapter();
tableAdapter.ClearBeforeFill = true;
tableAdapter.Fill(dataSet.GetSelectedInvoiceDetails, invoiceID, companyID, accountID);
// Return the data within the binding source.
return(new Model.DataSource.BindingSourceData[]
{
new Model.DataSource.BindingSourceData()
{
DataSource = bindingSource, DataSourceName = "GetSelectedInvoiceDetails"
},
});
}
/// <summary>
/// Create SuperFromToDateSuperID binding s ource data
/// </summary>
/// <param name="fromDate">The fromDate value</param>
/// <param name="toDate">The toDate value</param>
/// <param name="employeeID">The employeeID value</param>
/// <param name="superFundID">The superFundID value</param>
/// <returns><returns>The report binding source collection.</returns></returns>
public virtual Nequeo.Model.DataSource.BindingSourceData[] SuperFromToDateSuperID(DateTime?fromDate, DateTime?toDate, int?employeeID, int?superFundID)
{
// Assign the binding sources
Nequeo.DataAccess.NequeoCompany.DataSet.StoredProcedures dataSet = new Nequeo.DataAccess.NequeoCompany.DataSet.StoredProcedures();
System.Windows.Forms.BindingSource bindingSource = new System.Windows.Forms.BindingSource();
bindingSource.DataMember = "GetSelectedEmployeeFundSuperBetweenDate";
bindingSource.DataSource = dataSet;
// Get the data
Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetSelectedEmployeeFundSuperBetweenDateTableAdapter tableAdapter =
new Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetSelectedEmployeeFundSuperBetweenDateTableAdapter();
tableAdapter.ClearBeforeFill = true;
tableAdapter.Fill(dataSet.GetSelectedEmployeeFundSuperBetweenDate, fromDate, toDate, employeeID, superFundID);
// Return the data within the binding source.
return(new Model.DataSource.BindingSourceData[]
{
new Model.DataSource.BindingSourceData()
{
DataSource = bindingSource, DataSourceName = "GetSelectedEmployeeFundSuperBetweenDate"
}
});
}
/// <summary>
/// Create PaySlipFromToYear binding s ource data
/// </summary>
/// <param name="fromDate">The fromDate value</param>
/// <param name="toDate">The toDate value</param>
/// <param name="employeeID">The employeeID value</param>
/// <param name="companyID">The companyID value</param>
/// <param name="payPeriodFromDate">The payPeriodFromDate value</param>
/// <param name="payPeriodToDate">The payPeriodToDate value</param>
/// <returns><returns>The report binding source collection.</returns></returns>
public virtual Nequeo.Model.DataSource.BindingSourceData[] PaySlipFromToYear(
DateTime?fromDate, DateTime?toDate, int?employeeID, int?companyID, DateTime?payPeriodFromDate, DateTime?payPeriodToDate)
{
// Assign the binding sources
Nequeo.DataAccess.NequeoCompany.DataSet.StoredProcedures dataSet = new Nequeo.DataAccess.NequeoCompany.DataSet.StoredProcedures();
System.Windows.Forms.BindingSource bindingSource = new System.Windows.Forms.BindingSource();
bindingSource.DataMember = "GetSelectedEmployeePAYGPaymentSlipBetweenYear";
bindingSource.DataSource = dataSet;
System.Windows.Forms.BindingSource bindingSource1 = new System.Windows.Forms.BindingSource();
bindingSource1.DataMember = "GetSelectedEmployeeSuperPaymentSlipBetweenYear";
bindingSource1.DataSource = dataSet;
System.Windows.Forms.BindingSource bindingSource2 = new System.Windows.Forms.BindingSource();
bindingSource2.DataMember = "GetSelectedEmployeeWagesPaymentSlipBetweenYear";
bindingSource2.DataSource = dataSet;
System.Windows.Forms.BindingSource bindingSource3 = new System.Windows.Forms.BindingSource();
bindingSource3.DataMember = "Employees";
bindingSource3.DataSource = new Nequeo.DataAccess.NequeoCompany.Data.Extension.Employees().GetEmployee((int)employeeID);
System.Windows.Forms.BindingSource bindingSource4 = new System.Windows.Forms.BindingSource();
bindingSource4.DataMember = "Companies";
bindingSource4.DataSource = new Nequeo.DataAccess.NequeoCompany.Data.Extension.Companies().GetCompany((int)companyID);
System.Windows.Forms.BindingSource bindingSource5 = new System.Windows.Forms.BindingSource();
bindingSource5.DataMember = "GetSelectedEmployeeWagesPaymentSlipBetweenDate";
bindingSource5.DataSource = dataSet;
System.Windows.Forms.BindingSource bindingSource6 = new System.Windows.Forms.BindingSource();
bindingSource6.DataMember = "GetSelectedEmployeeSuperPaymentSlipBetweenDate";
bindingSource6.DataSource = dataSet;
System.Windows.Forms.BindingSource bindingSource7 = new System.Windows.Forms.BindingSource();
bindingSource7.DataMember = "GetSelectedEmployeePAYGPaymentSlipBetweenDate";
bindingSource7.DataSource = dataSet;
System.Windows.Forms.BindingSource bindingSource8 = new System.Windows.Forms.BindingSource();
bindingSource8.DataMember = "GetSelectedEmployeeWagesPaymentSlipBetweenDateALL";
bindingSource8.DataSource = dataSet;
System.Windows.Forms.BindingSource bindingSource9 = new System.Windows.Forms.BindingSource();
bindingSource9.DataMember = "GetSelectedEmployeeSuperPaymentSlipBetweenDateALL";
bindingSource9.DataSource = dataSet;
System.Windows.Forms.BindingSource bindingSource10 = new System.Windows.Forms.BindingSource();
bindingSource10.DataMember = "GetSelectedEmployeePAYGPaymentSlipBetweenDateALL";
bindingSource10.DataSource = dataSet;
// Get the data
Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetSelectedEmployeePAYGPaymentSlipBetweenYearTableAdapter tableAdapter =
new Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetSelectedEmployeePAYGPaymentSlipBetweenYearTableAdapter();
tableAdapter.ClearBeforeFill = true;
tableAdapter.Fill(dataSet.GetSelectedEmployeePAYGPaymentSlipBetweenYear, fromDate, toDate, employeeID, companyID);
// Get the data
Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetSelectedEmployeeSuperPaymentSlipBetweenYearTableAdapter tableAdapter1 =
new Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetSelectedEmployeeSuperPaymentSlipBetweenYearTableAdapter();
tableAdapter1.ClearBeforeFill = true;
tableAdapter1.Fill(dataSet.GetSelectedEmployeeSuperPaymentSlipBetweenYear, fromDate, toDate, employeeID, companyID);
// Get the data
Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetSelectedEmployeeWagesPaymentSlipBetweenYearTableAdapter tableAdapter2 =
new Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetSelectedEmployeeWagesPaymentSlipBetweenYearTableAdapter();
tableAdapter2.ClearBeforeFill = true;
tableAdapter2.Fill(dataSet.GetSelectedEmployeeWagesPaymentSlipBetweenYear, fromDate, toDate, employeeID, companyID);
// Get the data
Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetSelectedEmployeeWagesPaymentSlipBetweenDateTableAdapter tableAdapter3 =
new Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetSelectedEmployeeWagesPaymentSlipBetweenDateTableAdapter();
tableAdapter3.ClearBeforeFill = true;
tableAdapter3.Fill(dataSet.GetSelectedEmployeeWagesPaymentSlipBetweenDate, payPeriodFromDate, payPeriodToDate, employeeID, companyID);
// Get the data
Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetSelectedEmployeeSuperPaymentSlipBetweenDateTableAdapter tableAdapter4 =
new Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetSelectedEmployeeSuperPaymentSlipBetweenDateTableAdapter();
tableAdapter4.ClearBeforeFill = true;
tableAdapter4.Fill(dataSet.GetSelectedEmployeeSuperPaymentSlipBetweenDate, payPeriodFromDate, payPeriodToDate, employeeID, companyID);
// Get the data
Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetSelectedEmployeePAYGPaymentSlipBetweenDateTableAdapter tableAdapter5 =
new Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetSelectedEmployeePAYGPaymentSlipBetweenDateTableAdapter();
tableAdapter5.ClearBeforeFill = true;
tableAdapter5.Fill(dataSet.GetSelectedEmployeePAYGPaymentSlipBetweenDate, payPeriodFromDate, payPeriodToDate, employeeID, companyID);
// Get the data
Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetSelectedEmployeeWagesPaymentSlipBetweenDateALLTableAdapter tableAdapter6 =
new Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetSelectedEmployeeWagesPaymentSlipBetweenDateALLTableAdapter();
tableAdapter6.ClearBeforeFill = true;
tableAdapter6.Fill(dataSet.GetSelectedEmployeeWagesPaymentSlipBetweenDateALL, payPeriodFromDate, payPeriodToDate, employeeID, companyID);
// Get the data
Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetSelectedEmployeeSuperPaymentSlipBetweenDateALLTableAdapter tableAdapter7 =
new Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetSelectedEmployeeSuperPaymentSlipBetweenDateALLTableAdapter();
tableAdapter7.ClearBeforeFill = true;
tableAdapter7.Fill(dataSet.GetSelectedEmployeeSuperPaymentSlipBetweenDateALL, payPeriodFromDate, payPeriodToDate, employeeID, companyID);
// Get the data
Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetSelectedEmployeePAYGPaymentSlipBetweenDateALLTableAdapter tableAdapter8 =
new Nequeo.DataAccess.NequeoCompany.DataSet.StoredProceduresTableAdapters.GetSelectedEmployeePAYGPaymentSlipBetweenDateALLTableAdapter();
tableAdapter8.ClearBeforeFill = true;
tableAdapter8.Fill(dataSet.GetSelectedEmployeePAYGPaymentSlipBetweenDateALL, payPeriodFromDate, payPeriodToDate, employeeID, companyID);
// Return the data within the binding source.
return(new Model.DataSource.BindingSourceData[]
{
new Model.DataSource.BindingSourceData()
{
DataSource = bindingSource, DataSourceName = "GetSelectedEmployeePAYGPaymentSlipBetweenYear"
},
new Model.DataSource.BindingSourceData()
{
DataSource = bindingSource1, DataSourceName = "GetSelectedEmployeeSuperPaymentSlipBetweenYear"
},
new Model.DataSource.BindingSourceData()
{
DataSource = bindingSource2, DataSourceName = "GetSelectedEmployeeWagesPaymentSlipBetweenYear"
},
new Model.DataSource.BindingSourceData()
{
DataSource = bindingSource3, DataSourceName = "GetEmployee",
BindingSourceParameters = new Nequeo.Model.DataSource.BindingSourceParameter[]
{
new Nequeo.Model.DataSource.BindingSourceParameter()
{
Name = "PayPeriodEnding",
Value = Convert.ToString(payPeriodToDate.Value.ToShortDateString()),
ValueType = typeof(String)
},
new Nequeo.Model.DataSource.BindingSourceParameter()
{
Name = "ReportFooterTitle",
Value = "Pay Period To : " + Convert.ToString(payPeriodToDate.Value.ToShortDateString()),
ValueType = typeof(String)
},
}
},
new Model.DataSource.BindingSourceData()
{
DataSource = bindingSource4, DataSourceName = "GetCompany"
},
new Model.DataSource.BindingSourceData()
{
DataSource = bindingSource5, DataSourceName = "GetSelectedEmployeeWagesPaymentSlipBetweenDate"
},
new Model.DataSource.BindingSourceData()
{
DataSource = bindingSource6, DataSourceName = "GetSelectedEmployeeSuperPaymentSlipBetweenDate"
},
new Model.DataSource.BindingSourceData()
{
DataSource = bindingSource7, DataSourceName = "GetSelectedEmployeePAYGPaymentSlipBetweenDate"
},
new Model.DataSource.BindingSourceData()
{
DataSource = bindingSource8, DataSourceName = "GetSelectedEmployeeWagesPaymentSlipBetweenDateALL"
},
new Model.DataSource.BindingSourceData()
{
DataSource = bindingSource9, DataSourceName = "GetSelectedEmployeeSuperPaymentSlipBetweenDateALL"
},
new Model.DataSource.BindingSourceData()
{
DataSource = bindingSource10, DataSourceName = "GetSelectedEmployeePAYGPaymentSlipBetweenDateALL"
},
});
}
