public StatisicsWindow1(ListData listData)
{
listDataGlobal = listData;
BoatRentalsDao boatRentalsDao = new BoatRentalsDaoImpl();
InitializeComponent();
int j = 0;
for (int i = 2015; i < 2019; i++)
{
towerChart(115 + j * 25, 100 - boatRentalsDao.GetHowManyBoatRentalsByYearAndBoat(i, Convert.ToInt32(listData.id)) * 3, boatRentalsDao.GetHowManyBoatRentalsByYearAndBoat(i, Convert.ToInt32(listData.id)) * 3, ref YearlyIncomeCanvas, 20, i);
j++;
}
for (int i = 0; i < 12; i++)
{
towerChart(30 + i * 25, 100 - boatRentalsDao.GetHowManyBoatRentalsByMonthAndBoat(i, Convert.ToInt32(listData.id)) * 10, boatRentalsDao.GetHowManyBoatRentalsByMonthAndBoat(i, Convert.ToInt32(listData.id)) * 10, ref MonthlyIncomeCanvas, 20, i);
}
for (int i = 0; i < 52; i++)
{
towerChart(20 + i * 25, 100 - boatRentalsDao.GetHowManyBoatRentalsByWeekAndBoat(i, Convert.ToInt32(listData.id)) * 10, boatRentalsDao.GetHowManyBoatRentalsByWeekAndBoat(i, Convert.ToInt32(listData.id)) * 10, ref WeeklyIncomeCanvas, 10, i);
}
MouseDown += Window_MouseDown; //az ablak mozgatásához kell
}
private void GenerateDatabase()
{
var dbContext = AliveContext.Context;
dbContext.Database.Create();
//fill the database with temporarily data
MembersDao mem = new MembersDaoImpl();
List <MembersEntity> mems = mem.GetTemplateMembers();
for (int i = 0; i < mems.Count; i++)
{
dbContext.Members.Add(mems[i]);
}
dbContext.SaveChanges();
BoatsDao boat = new BoatsDaoImpl();
List <BoatsEntity> boats = boat.GetTemplateBoats();
for (int i = 0; i < boats.Count; i++)
{
dbContext.Boats.Add(boats.SingleOrDefault(b => b.BoatId == i));
}
dbContext.SaveChanges();
TransportDevicesDao device = new TransportDevicesDaoImpl();
List <TransportDevicesEntity> devices = device.GetTemplateTransportDevices();
for (int i = 0; i < devices.Count; i++)
{
dbContext.TransportDevices.Add(devices.SingleOrDefault(d => d.TransportDeviceId == i));
}
dbContext.SaveChanges();
RentRequestsDao rent = new RentRequestsDaoImpl();
List <RentRequestsEntity> rents = rent.GetTemplateRentRequests();
for (int i = 0; i < rents.Count; i++)
{
dbContext.RentRequests.Add(rents[i]);
}
dbContext.SaveChanges();
BoatRentalsDao boatRent = new BoatRentalsDaoImpl();
List <BoatRentalsEntity> boatRents = boatRent.GetTemplateBoatRents();
for (int i = 0; i < boatRents.Count; i++)
{
dbContext.BoatRentals.Add(boatRents[i]);
}
dbContext.SaveChanges();
}
public StatisticsWindow2(ListData listData, string timeSpan)
{
listDataGlobal = listData;
BoatRentalsDao boatRentalsDao = new BoatRentalsDaoImpl();
InitializeComponent();
if (timeSpan == "yearly")
{
var gridView = new GridView();
this.lwIncome.View = gridView;
gridView.Columns.Add(new GridViewColumn
{
Header = "Id",
DisplayMemberBinding = new Binding("Id")
});
gridView.Columns.Add(new GridViewColumn
{
Header = "Bevétel",
DisplayMemberBinding = new Binding("Income")
});
gridView.Columns[1].Width = 150;
int j = 0;
for (int i = 2015; i < 2019; i++)
{
this.lwIncome.Items.Add(new StatisticsListItem {
Id = i.ToString(), Income = Convert.ToString(boatRentalsDao.GetIncomeBoatRentalsByYearAndBoat(i, Convert.ToInt32(listData.id))) + " FT"
});
j++;
}
}
if (timeSpan == "monthly")
{
var gridView = new GridView();
this.lwIncome.View = gridView;
gridView.Columns.Add(new GridViewColumn
{
Header = "Id",
DisplayMemberBinding = new Binding("Id")
});
gridView.Columns.Add(new GridViewColumn
{
Header = "Bevétel",
DisplayMemberBinding = new Binding("Income")
});
gridView.Columns[1].Width = 150;
System.Globalization.DateTimeFormatInfo mfi = new
System.Globalization.DateTimeFormatInfo();
for (int i = 0; i < 12; i++)
{
this.lwIncome.Items.Add(new StatisticsListItem {
Id = mfi.GetMonthName(i + 1), Income = Convert.ToString(boatRentalsDao.GetIncomeBoatRentalsByMonthAndBoat(i, Convert.ToInt32(listData.id))) + " FT"
});
}
}
if (timeSpan == "weekly")
{
var gridView = new GridView();
this.lwIncome.View = gridView;
gridView.Columns.Add(new GridViewColumn
{
Header = "Hét",
DisplayMemberBinding = new Binding("Id")
});
gridView.Columns.Add(new GridViewColumn
{
Header = "Bevétel",
DisplayMemberBinding = new Binding("Income")
});
gridView.Columns[1].Width = 150;
for (int i = 0; i < 52; i++)
{
this.lwIncome.Items.Add(new StatisticsListItem {
Id = (i + 1).ToString() + ".", Income = Convert.ToString(boatRentalsDao.GetIncomeBoatRentalsByWeekAndBoat(i, Convert.ToInt32(listData.id))) + " FT"
});
}
}
if (timeSpan == "dayly")
{
var gridView = new GridView();
this.lwIncome.View = gridView;
gridView.Columns.Add(new GridViewColumn
{
Header = "Nap",
DisplayMemberBinding = new Binding("Id")
});
gridView.Columns[0].Width = 100;
gridView.Columns.Add(new GridViewColumn
{
Header = "Bevétel",
DisplayMemberBinding = new Binding("Income")
});
gridView.Columns[1].Width = 150;
System.Globalization.DateTimeFormatInfo mfi = new
System.Globalization.DateTimeFormatInfo();
for (int k = 0; k < 12; k++)
{
for (int i = 0; i < DateTime.DaysInMonth(2018, k + 1); i++)/*szökőév nincs számolva*/
{
this.lwIncome.Items.Add(new StatisticsListItem {
Id = mfi.GetMonthName(k + 1) + " " + (i + 1).ToString() + ".", Income = Convert.ToString(boatRentalsDao.GetIncomeBoatRentalsByDayAndBoat(i, k, Convert.ToInt32(listData.id))) + " FT"
});
}
}
}
MouseDown += Window_MouseDown; //az ablak mozgatásához kell
}
