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