/// <summary>
/// Creates a new instance of the sol_Fees class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sol_Fee MakeSol_Fee(SqlDataReader dataReader)
{
Sol_Fee sol_Fee = new Sol_Fee();
sol_Fee.FeeID = SqlClientUtility.GetInt32(dataReader, "FeeID", 0);
sol_Fee.FeeDescription = SqlClientUtility.GetString(dataReader, "FeeDescription", String.Empty);
sol_Fee.FeeAmount = SqlClientUtility.GetDecimal(dataReader, "FeeAmount", Decimal.Zero);
sol_Fee.Percentage = SqlClientUtility.GetBoolean(dataReader, "Percentage", false);
return(sol_Fee);
}
/// <summary>
/// Saves a record to the sol_Fees table.
/// </summary>
public virtual void Insert(Sol_Fee sol_Fee)
{
ValidationUtility.ValidateArgument("sol_Fee", sol_Fee);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@FeeDescription", sol_Fee.FeeDescription),
new SqlParameter("@FeeAmount", sol_Fee.FeeAmount),
new SqlParameter("@Percentage", sol_Fee.Percentage)
};
sol_Fee.FeeID = (int)SqlClientUtility.ExecuteScalar(connectionStringName, CommandType.StoredProcedure, "sol_Fees_Insert", parameters);
}
/// <summary>
/// Selects all records from the sol_Fees table.
/// </summary>
public virtual List <Sol_Fee> SelectAll()
{
using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "sol_Fees_SelectAll"))
{
List <Sol_Fee> sol_FeeList = new List <Sol_Fee>();
while (dataReader.Read())
{
Sol_Fee sol_Fee = MakeSol_Fee(dataReader);
sol_FeeList.Add(sol_Fee);
}
return(sol_FeeList);
}
}
