public DataSet PaymentSearchGet()
{
DataSet dsPayment = new DataSet();
using (SqlConnection Connection = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["WebApplication"]))
{
using (SqlCommand Command = new SqlCommand("BonusPlan.PaymentSearchGet", Connection))
{
Command.CommandType = CommandType.StoredProcedure;
Command.CommandTimeout = 600;
Command.Parameters.Add("@EmployeeFirstName", SqlDbType.VarChar);
Command.Parameters["@EmployeeFirstName"].Value = SearchEmployeeFirstName.NullIfEmpty();
Command.Parameters.Add("@EmployeeLastName", SqlDbType.VarChar);
Command.Parameters["@EmployeeLastName"].Value = SearchEmployeeLastName.NullIfEmpty();
Command.Parameters.Add("@ADP_EmployeeID", SqlDbType.VarChar);
Command.Parameters["@ADP_EmployeeID"].Value = SearchEmployeeID.NullIfEmpty();
Command.Parameters.Add("@CustomerID", SqlDbType.Int);
Command.Parameters["@CustomerID"].Value = SearchCustomerID.NullIfEmpty();
Command.Parameters.Add("@ResidentFirstName", SqlDbType.VarChar);
Command.Parameters["@ResidentFirstName"].Value = SearchResidentFirstName.NullIfEmpty();
Command.Parameters.Add("@ResidentLastName", SqlDbType.VarChar);
Command.Parameters["@ResidentLastName"].Value = SearchResidentLastName.NullIfEmpty();
Command.Parameters.Add("@CommunityID", SqlDbType.VarChar);
Command.Parameters["@CommunityID"].Value = SearchCommunityID.NullIfEmpty();
Command.Parameters.Add("@PaymentFromDate", SqlDbType.DateTime);
Command.Parameters["@PaymentFromDate"].Value = SearchPaymentFromDt.NullIfEmpty();
Command.Parameters.Add("@PaymentToDate", SqlDbType.DateTime);
Command.Parameters["@PaymentToDate"].Value = SearchPaymentToDt.NullIfEmpty();
Command.Parameters.Add("@PayrollFromDate", SqlDbType.DateTime);
Command.Parameters["@PayrollFromDate"].Value = SearchPayrollFromDt.NullIfEmpty();
Command.Parameters.Add("@PayrollToDate", SqlDbType.DateTime);
Command.Parameters["@PayrollToDate"].Value = SearchPayrollToDt.NullIfEmpty();
Command.Parameters.Add("@MoveInFromDate", SqlDbType.DateTime);
Command.Parameters["@MoveInFromDate"].Value = SearchMoveInFromDt.NullIfEmpty();
Command.Parameters.Add("@MoveInToDate", SqlDbType.DateTime);
Command.Parameters["@MoveInToDate"].Value = SearchMoveInToDt.NullIfEmpty();
using (SqlDataAdapter DataAdapter = new SqlDataAdapter(Command))
{
DataAdapter.Fill(dsPayment);
}
}
}
return(dsPayment);
}
public DataSet MoveInRevenueSearchGet()
{
DataSet dsRevenue = new DataSet();
using (SqlConnection Connection = new SqlConnection(ConfigurationManager.AppSettings["WebApplication"]))
{
using (SqlCommand Command = new SqlCommand("BonusPlan.MoveInRevenueSearchGet", Connection))
{
Command.CommandType = CommandType.StoredProcedure;
Command.Parameters.Add("@CustomerID", SqlDbType.Int);
Command.Parameters["@CustomerID"].Value = SearchCustomerID.NullIfEmpty();
Command.Parameters.Add("@FirstName", SqlDbType.VarChar);
Command.Parameters["@FirstName"].Value = SearchFirstName.NullIfEmpty();
Command.Parameters.Add("@LastName", SqlDbType.VarChar);
Command.Parameters["@LastName"].Value = SearchLastName.NullIfEmpty();
Command.Parameters.Add("@CommunityNumber", SqlDbType.VarChar);
Command.Parameters["@CommunityNumber"].Value = SearchCommunityNumber.NullIfEmpty();
Command.Parameters.Add("@BeginEffectiveDt", SqlDbType.DateTime);
Command.Parameters["@BeginEffectiveDt"].Value = SearchBeginEffectiveDt.NullIfEmpty();
Command.Parameters.Add("@EndEffectiveDt", SqlDbType.DateTime);
Command.Parameters["@EndEffectiveDt"].Value = SearchEndEffectiveDt.NullIfEmpty();
using (SqlDataAdapter DataAdapter = new SqlDataAdapter(Command))
{
DataAdapter.Fill(dsRevenue);
}
}
}
return(dsRevenue);
}
