/// <summary>
/// Creates a new instance of the sol_ExpenseTypes class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sol_ExpenseType MakeSol_ExpenseType(SqlDataReader dataReader)
{
Sol_ExpenseType sol_ExpenseType = new Sol_ExpenseType();
sol_ExpenseType.ExpenseTypeID = SqlClientUtility.GetInt32(dataReader, "ExpenseTypeID", 0);
sol_ExpenseType.Description = SqlClientUtility.GetString(dataReader, "Description", String.Empty);
return(sol_ExpenseType);
}
/// <summary>
/// Saves a record to the sol_ExpenseTypes table.
/// </summary>
public virtual void Insert(Sol_ExpenseType sol_ExpenseType)
{
ValidationUtility.ValidateArgument("sol_ExpenseType", sol_ExpenseType);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@Description", sol_ExpenseType.Description)
};
sol_ExpenseType.ExpenseTypeID = (int)SqlClientUtility.ExecuteScalar(connectionStringName, CommandType.StoredProcedure, "sol_ExpenseTypes_Insert", parameters);
}
/// <summary>
/// Updates a record in the sol_ExpenseTypes table.
/// </summary>
public virtual void Update(Sol_ExpenseType sol_ExpenseType)
{
ValidationUtility.ValidateArgument("sol_ExpenseType", sol_ExpenseType);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@ExpenseTypeID", sol_ExpenseType.ExpenseTypeID),
new SqlParameter("@Description", sol_ExpenseType.Description)
};
SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "sol_ExpenseTypes_Update", parameters);
}
/// <summary>
/// Selects all records from the sol_ExpenseTypes table.
/// </summary>
public virtual List <Sol_ExpenseType> SelectAll()
{
using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "sol_ExpenseTypes_SelectAll"))
{
List <Sol_ExpenseType> sol_ExpenseTypeList = new List <Sol_ExpenseType>();
while (dataReader.Read())
{
Sol_ExpenseType sol_ExpenseType = MakeSol_ExpenseType(dataReader);
sol_ExpenseTypeList.Add(sol_ExpenseType);
}
return(sol_ExpenseTypeList);
}
}
