//Restore button
private void restoreToolStripMenuItem_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Do you really want to restore data from XML? Almost all online data will be lost.", "Restore",
MessageBoxButtons.YesNo) == DialogResult.Yes)
{
LockerFactory lockerFactory = new LockerFactory();
LockerGateway <Locker> lg = (LockerGateway <Locker>)lockerFactory.GetLocker();
TrainingFactory trainingFactory = new TrainingFactory();
TrainingGateway <Training> tg = (TrainingGateway <Training>)trainingFactory.GetTraining();
PurchaseFactory purchaseFactory = new PurchaseFactory();
PurchaseGateway <Purchase> pg = (PurchaseGateway <Purchase>)purchaseFactory.GetPurchase();
TrainerFactory trainerFactory = new TrainerFactory();
TrainerGateway <Trainer> trainerg = (TrainerGateway <Trainer>)trainerFactory.GetTrainer();
TrainerRatingFactory trainerRatingFactory = new TrainerRatingFactory();
TrainerRatingGateway <TrainerRating> tr = (TrainerRatingGateway <TrainerRating>)trainerRatingFactory.GetTrainerRating();
TicketFactory ticketFactory = new TicketFactory();
TicketGateway <Ticket> ticketg = (TicketGateway <Ticket>)ticketFactory.GetTicket();
tg.Delete();
pg.Delete();
tr.Delete();
trainerg.Delete();
lg.Delete();
ticketg.Delete();
foreach (var locker in lg.Select())
{
lg.Insert(locker);
}
foreach (var ticket in TicketXMLGateway <Ticket> .Instance.Select())
{
TicketXMLGateway <Ticket> .Instance.Insert(ticket);
}
foreach (var trainer in TrainerXMLGateway <Trainer> .Instance.Select())
{
TrainerXMLGateway <Trainer> .Instance.Insert(trainer);
}
foreach (var purchase in PurchaseXMLGateway <Purchase> .Instance.Select())
{
PurchaseXMLGateway <Purchase> .Instance.Insert(purchase);
}
foreach (var training in TrainingXMLGateway <Training> .Instance.Select())
{
TrainingXMLGateway <Training> .Instance.Insert(training);
}
foreach (var rating in TrainerRatingXMLGateway <TrainerRating> .Instance.Select())
{
TrainerRatingXMLGateway <TrainerRating> .Instance.Insert(rating);
}
MessageBox.Show("Data restored!");
}
}
public void firstInitialize()
{
ClientFactory clientFactory = new ClientFactory();
ClientGateway <Client> cg = (ClientGateway <Client>)clientFactory.GetClient();
TrainerFactory trainerFactory = new TrainerFactory();
TrainerGateway <Trainer> trainerg = (TrainerGateway <Trainer>)trainerFactory.GetTrainer();
LockerFactory lockerFactory = new LockerFactory();
LockerGateway <Locker> lg = (LockerGateway <Locker>)lockerFactory.GetLocker();
clients = cg.SelectForTrainingStartEnd(true);
trainers = trainerg.Select();
lockers = lg.Select();
Collection <string> clientNames = new Collection <string>();
foreach (Client c in clients)
{
clientNames.Add(c.ToString());
}
comboClient.DataSource = clientNames;
Collection <Locker> filteredLockers = new Collection <Locker>();
Collection <string> lockerNames = new Collection <string>();
foreach (Locker l in lockers)
{
if (l.Status != "taken")
{
filteredLockers.Add(l);
}
}
foreach (Locker l in filteredLockers)
{
lockerNames.Add(l.ToString());
}
comboLocker.DataSource = lockerNames;
Collection <string> trainerNames = new Collection <string>();
foreach (Trainer t in trainers)
{
trainerNames.Add(t.ToString());
}
comboTrainer.DataSource = trainerNames;
}
protected void RefreshData()
{
TrainingFactory trainingFactory = new TrainingFactory();
TrainingGateway <Training> tg = (TrainingGateway <Training>)trainingFactory.GetTraining();
TicketFactory ticketFactory = new TicketFactory();
TicketGateway <Ticket> ticketg = (TicketGateway <Ticket>)ticketFactory.GetTicket();
ClientFactory clientFactory = new ClientFactory();
ClientGateway <Client> cg = (ClientGateway <Client>)clientFactory.GetClient();
TrainerFactory trainerFactory = new TrainerFactory();
TrainerGateway <Trainer> trainerg = (TrainerGateway <Trainer>)trainerFactory.GetTrainer();
Collection <Training> trainings = tg.Select();
Collection <TrainGrid> trainGrid = new Collection <TrainGrid>();
foreach (Training t in trainings)
{
TrainGrid tgrid = new TrainGrid();
tgrid.LockerId = t.LockerId;
tgrid.ToGender = t.ToGender;
tgrid.Start = t.TimeFrom;
tgrid.End = t.TimeTo;
// using factory to get data
Client c = cg.Select(t.ClientId);
tgrid.ClientName = c.Name + " " + c.Surname;
int tempId;
if (t.TrainerId.HasValue)
{
tempId = t.TrainerId.Value;
Trainer tr = trainerg.Select(tempId);
tgrid.TrainerName = tr.Name + " " + tr.Surname;
}
else
{
tgrid.TrainerName = "";
}
trainGrid.Add(tgrid);
}
BindingList <TrainGrid> bindingList = new BindingList <TrainGrid>(trainGrid);
trainingsGrid.AutoGenerateColumns = false;
trainingsGrid.DataSource = bindingList;
}
protected void Page_Load(object sender, EventArgs e)
{
TrainerFactory trainerFactory = new TrainerFactory();
TrainerGateway <Trainer> trainerg = (TrainerGateway <Trainer>)trainerFactory.GetTrainer();
if (Session["ID"] == null)
{
Response.Redirect("~/Login.aspx");
}
trainers = trainerg.Select();
Collection <string> trainerNames = new Collection <string>();
foreach (Trainer tr in trainers)
{
trainerNames.Add(tr.ToString());
}
starNumbers = new Collection <string> {
"1",
"2",
"3",
"4",
"5"
};
if (!IsPostBack)
{
trainerStars.DataSource = starNumbers;
trainerStars.DataBind();
trainerDropdownId.DataSource = trainerNames;
trainerDropdownId.DataBind();
}
if (Session["rated"] != null)
{
ratedTrainerText.Attributes.Add("class", "blocked");
ratedTrainer.Style.Add("display", "inline-block");
thankRating.Style.Add("display", "inline-block");
theDiv.Style.Add("display", "none");
averageRating.Style.Add("display", "inline-block");
averageRatingText.Style.Add("display", "inline-block");
clientsRatedTop.Style.Add("display", "inline-block");
ratedTrainer.Text = Session["ratedTrainer"].ToString();
var temp = trainerg.SelectAVG(int.Parse(Session["ratedTrainerId"].ToString()));
averageRating.Text = temp[0].ToString();
clientsRated.Text = temp[1].ToString();
Session["rated"] = null;
Session["ratedTrainer"] = null;
Session["ratedTrainerId"] = null;
}
else
{
ratedTrainerText.Style.Add("display", "none");
ratedTrainer.Style.Add("display", "none");
thankRating.Style.Add("display", "none");
averageRating.Style.Add("display", "none");
averageRatingText.Style.Add("display", "none");
clientsRatedTop.Style.Add("display", "none");
}
}
private void backupToolStripMenuItem1_Click(object sender, EventArgs e)
{
LockerFactory lockerFactory = new LockerFactory();
LockerXMLGateway <Locker> lg = (LockerXMLGateway <Locker>)lockerFactory.GetLocker();
TrainingFactory trainingFactory = new TrainingFactory();
TrainingGateway <Training> tg = (TrainingGateway <Training>)trainingFactory.GetTraining();
PurchaseFactory purchaseFactory = new PurchaseFactory();
PurchaseGateway <Purchase> pg = (PurchaseGateway <Purchase>)purchaseFactory.GetPurchase();
TrainerFactory trainerFactory = new TrainerFactory();
TrainerGateway <Trainer> trainerg = (TrainerGateway <Trainer>)trainerFactory.GetTrainer();
TrainerRatingFactory trainerRatingFactory = new TrainerRatingFactory();
TrainerRatingGateway <TrainerRating> tr = (TrainerRatingGateway <TrainerRating>)trainerRatingFactory.GetTrainerRating();
TicketFactory ticketFactory = new TicketFactory();
TicketGateway <Ticket> ticketg = (TicketGateway <Ticket>)ticketFactory.GetTicket();
// Backup button
XDocument xDoc = new XDocument();
XElement xRoot = new XElement("Database");
ClientFactory clientFactory = new ClientFactory();
ClientGateway <Client> cg = (ClientGateway <Client>)clientFactory.GetClient();
Collection <Client> clients = cg.Select();
XElement xClients = new XElement("Clients");
foreach (var client in clients)
{
xClients.Add(ClientXMLGateway <Client> .Instance.Insert(client));
}
DiscountFactory discountFactory = new DiscountFactory();
DiscountGateway <DiscountCard> dg = (DiscountGateway <DiscountCard>)discountFactory.GetCard();
Collection <DiscountCard> cards = dg.Select();
XElement xCards = new XElement("Cards");
foreach (var card in cards)
{
xCards.Add(DiscountXMLGateway <DiscountCard> .Instance.Insert(card));
}
Collection <Locker> lockers = lg.Select();
XElement xLockers = new XElement("Lockers");
foreach (var locker in lockers)
{
xLockers.Add(LockerXMLGateway <Locker> .Instance.Insert(locker));
}
Collection <Purchase> purchases = pg.Select();
XElement xPurchases = new XElement("Purchases");
foreach (var purchase in purchases)
{
xPurchases.Add(PurchaseXMLGateway <Purchase> .Instance.Insert(purchase));
}
Collection <Ticket> tickets = ticketg.Select();
XElement xTickets = new XElement("Tickets");
foreach (var ticket in tickets)
{
xTickets.Add(TicketXMLGateway <Ticket> .Instance.Insert(ticket));
}
Collection <TrainerRating> ratings = tr.Select();
XElement xRatings = new XElement("TrainerRatings");
foreach (var rating in ratings)
{
xRatings.Add(TrainerRatingXMLGateway <TrainerRating> .Instance.Insert(rating));
}
Collection <Trainer> trainers = trainerg.Select();
XElement xTrainers = new XElement("Trainers");
foreach (var trainer in trainers)
{
xTrainers.Add(TrainerXMLGateway <Trainer> .Instance.Insert(trainer));
}
Collection <Training> trainings = tg.Select();
XElement xTrainings = new XElement("Trainings");
foreach (var training in trainings)
{
xTrainings.Add(TrainingXMLGateway <Training> .Instance.Insert(training));
}
xRoot.Add(xClients);
xRoot.Add(xCards);
xRoot.Add(xLockers);
xRoot.Add(xPurchases);
xRoot.Add(xTickets);
xRoot.Add(xRatings);
xRoot.Add(xTrainers);
xRoot.Add(xTrainings);
xDoc.Add(xRoot);
if (!Directory.Exists(Connective.Backup.Paths.FolderPath))
{
Directory.CreateDirectory(Connective.Backup.Paths.FolderPath);
}
using (StreamWriter sw = new StreamWriter(Connective.Backup.Paths.FilePath))
{
sw.Write(xDoc.ToString());
}
MessageBox.Show("Backed up!");
}
