public List <ExtraCost> FecthAll() { List <ExtraCost> returnList = new List <ExtraCost>(); using (SqlConnection connection = new SqlConnection(ConnectionString)) { string sqlQuery = "SELECT * from dbo.EXTRA_COST "; SqlCommand command = new SqlCommand(sqlQuery, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { ExtraCost extracost = new ExtraCost(); extracost.ID = reader.GetInt32(0); extracost.Type = reader.GetString(1); extracost.Fee = reader.GetDouble(2); extracost.PackageID = reader.GetInt32(3); returnList.Add(extracost); } } } return(returnList); }
public BudgetExtraCostDefinedEvent( Guid budgetId, ExtraCost extraCost) { BudgetId = budgetId; ExtraCost = extraCost; }