public CRUDController()
{
customersList = new List <ICustomer>();
daf = new DataAccessFacade();
sc = new SerializeController();
cf = new CustomerFacade();
}
public BookingController(PaymentController paymentController, CustomerController customerController)
{
dataAccessFacade = DataAccessFacade.GetInstance();
bookingCollection = new BookingCollection(dataAccessFacade);
this.paymentController = paymentController;
this.customerController = customerController;
}
static void Main(string[] args)
{
DataAccessResponse Response = null;
List <TransactionParameter> TransactionParameters = new List <TransactionParameter>();
TransactionParameters.Add(new TransactionParameter()
{
DataType = DataTypeEnum.STRING, Value = "Vinod"
});
TransactionParameters.Add(new TransactionParameter()
{
DataType = DataTypeEnum.STRING, Value = "Kumar"
});
TransactionParameters.Add(new TransactionParameter()
{
DataType = DataTypeEnum.STRING, Value = "Gupta"
});
DataAccessRequest Request = new DataAccessRequest()
{
SecurityParameter = new SecurityParameter()
{
UserID = "VGupta",
OperationCode = OperationCodeEnum.GET_USER
},
TransactionParameters = TransactionParameters,
};
using (DataAccessFacade facade = new DataAccessFacade())
{
Response = facade.Exceute(Request);
}
}
public List <EmployeeDTO> getEmployees()
{
var employees = new List <EmployeeDTO>();
var data = new DataAccessFacade().executeRequest(1,
ConfigurationManager.AppSettings["Method"],
new List <Parameter>(),
ConfigurationManager.AppSettings["ApiUrl"]);
var roleAdapter = AdapterCreator.getInstance().getFactory("Role");
Adapter employeeAdapter;
for (var i = 0; i < data.Count(); i++)
{
var role = (RoleDTO)roleAdapter.create(data, i);
if (data.getDato(i).getStringField("contractTypeName") == "HourlySalaryEmployee")
{
employeeAdapter = AdapterCreator.getInstance().getFactory("HourlyEmployee");
}
else
{
employeeAdapter = AdapterCreator.getInstance().getFactory("MonthlyEmployee");
}
var employee = (EmployeeDTO)employeeAdapter.create(data, i);
employee.role = role;
employees.Add(employee);
}
return(employees);
}
public void DataAccessTest_GetDataSet()
{
DataSet dataset = null;
Task task = Task.Factory.StartNew(async()
=>
{
using (IDataAccessFacade facade = new DataAccessFacade(DatabaseType.SqlServer))
{
dataset = await facade.ExecuteDataSet(CreateDataAccessRequest());
}
});
task.Wait();
Assert.IsFalse(null == dataset, "Failed");
Trace.WriteLine($"Data={dataset.GetXml()}");
}
internal static DataAccessFacade CreateFacade(DatabaseType databaseType)
{
switch (databaseType)
{
case DatabaseType.SqlServer:
if (null == facade)
{
facade = new SqlDataAccessFacade();
}
else
if (!(facade.GetType() == typeof(SqlDataAccessFacade)))
{
facade = new SqlDataAccessFacade();
}
break;
default:
facade = null;
break;
}
return(facade);
}
public void DataAccessTest_GetDataReader()
{
IDataReader reader = null;
Task task = Task.Factory.StartNew(async()
=>
{
using (IDataAccessFacade facade = new DataAccessFacade(DatabaseType.SqlServer))
{
reader = await facade.ExecuteReader(CreateDataAccessRequest());
}
});
task.Wait();
Assert.IsFalse(null == reader, "Failed");
int recordCount = 0;
while (reader.Read())
{
recordCount++;
}
Trace.WriteLine($"Record Count={recordCount}, Field Count={reader.FieldCount}");
}
public static void UpdateLeagueStatus(int LeagueId, string LeagueStatus)
{
DataAccessFacade.UpdateLeagueStatus(LeagueId, LeagueStatus);
}
public static int SaveLeague(League newLeague)
{
return(DataAccessFacade.SaveLeague(newLeague));
}
public static void DeleteLeague(League chosenLeague)
{
DataAccessFacade.DeleteLeague(chosenLeague);
}
public static Player GetPlayerById(int playerId)
{
return(DataAccessFacade.GetPlayerById(playerId));
}
public static void UpdatePlayer(Player ChosenPlayer)
{
DataAccessFacade.UpdatePlayer(ChosenPlayer);
}
public static void DeletePlayer(Player ChosenPlayer)
{
DataAccessFacade.DeletePlayer(ChosenPlayer);
}
public static void UpdateTeam(Team ChosenTeam)
{
DataAccessFacade.UpdateTeam(ChosenTeam);
}
public static void SaveTeam(Team newTeam, int leagueId)
{
DataAccessFacade.SaveTeam(newTeam, leagueId);
}
public PaymentController()
{
dataAccessFacade = DataAccessFacade.GetInstance();
paymentCollection = new PaymentCollection(dataAccessFacade);
}
public static int SavePlayer(Player newPlayer)
{
return(DataAccessFacade.SavePlayer(newPlayer));
}
public CustomerController()
{
dataAccessFacade = DataAccessFacade.GetInstance();
customerCollection = new CustomerCollection(dataAccessFacade);
}
public static ObservableCollection <Player> GetPlayerData()
{
return(DataAccessFacade.GetPlayerData());
}
public static ObservableCollection <League> GetLeagueData()
{
return(DataAccessFacade.GetLeagueData());
}
public ObservableCollection <Round> CreateMatches(ObservableCollection <Team> TeamsInLeague, ObservableCollection <Round> RoundsInLeague)
{
ObservableCollection <Round> result = new ObservableCollection <Round>();
//listen af hold blandes
TeamsInLeague = ShuffleTeams(TeamsInLeague);
// antal af kampe der skal være i en runde er = antallet af hold delt med 2
int numberOfMatchesInARound = TeamsInLeague.Count / 2;
List <Team> teams = new List <Team>();
//tager listen af hold og springer halvdelen over og tilføjer den sidste halvdel til listen Teams
teams.AddRange(TeamsInLeague.Skip(numberOfMatchesInARound).Take(numberOfMatchesInARound));
//springer det første hold over og tilføjer holdende derfra og optil halvvejen -1,
//ligger dem ind i et array derefter vender arrayet rundt og tilføjer arrayet til listen Team
teams.AddRange(TeamsInLeague.Skip(1).Take(numberOfMatchesInARound - 1).ToArray().Reverse());
var numberOfTeams = teams.Count;
// kører for hvert antal af runde objekter i listen af RoundsInLeague
for (var roundNumber = 0; roundNumber < RoundsInLeague.Count; roundNumber++)
{
var teamIdx = roundNumber % numberOfTeams;
Match newMatch = new Match();
//newMatch indeholder en liste af hold
//tager det hold som er på tallet TeamIdx i teams listen
//og tilføjer det til listen TeamsInMatch
newMatch.TeamsInMatch.Add(teams[teamIdx]);
//tager derefter det hold som ligger først i listen TeamsInLeague
//som vi sprang over før og tilføjer det til listen TeamsInMatch
newMatch.TeamsInMatch.Add(TeamsInLeague[0]);
//Gemmer den Match som lige er blevet lavet til databasen
DataAccessFacade.SaveMatch(newMatch, RoundsInLeague[roundNumber].RoundId);
//tilføjer den Match der lige er blevet lavet
//til listen af kampe i en given runde
RoundsInLeague[roundNumber].MatchesInRound.Add(newMatch);
//kører for hver Match der skal være i Round
for (var idx = 1; idx < numberOfMatchesInARound; idx++)
{
//en variabel der holder på et nummer der skal endikere
//det første hold den tager i en match
var firstTeamIndex = (roundNumber + idx) % numberOfTeams;
//en variabel der endikere det andet hold der skal der skal i en match
var secondTeamIndex = (roundNumber + numberOfTeams - idx) % numberOfTeams;
Match newMatch2 = new Match();
//tilføjer det første hold til en match
newMatch2.TeamsInMatch.Add(teams[firstTeamIndex]);
//endikere det andet hold der skal i en match
newMatch2.TeamsInMatch.Add(teams[secondTeamIndex]);
//gemmer match info på database
DataAccessFacade.SaveMatch(newMatch2, RoundsInLeague[roundNumber].RoundId);
//gemmer match til listen af matches på en specifik round
RoundsInLeague[roundNumber].MatchesInRound.Add(newMatch2);
}
// tilføjer runden til en liste af runder
result.Add(RoundsInLeague[roundNumber]);
}
//returnere listen af runder
return(result);
}
/// <summary>
/// Initializes a new MusicSystem instance, and instantiates a new DataAccessFacade and
/// ArtistCollection.
/// </summary>
public MusicSystem()
{
dataAccessFacade = new DataAccessFacade();
artistCollection = new ArtistCollection(dataAccessFacade);
}
public static void SaveRound(Round newRound, int leagueId)
{
DataAccessFacade.SaveRound(newRound, leagueId);
}
public SupplierController()
{
dataAccessFacade = DataAccessFacade.GetInstance();
supplierCollection = new SupplierCollection(dataAccessFacade);
}
