private void Loading()
{
data = new MysqlMessage();
Messages = data.MysqlAllMessages();
diagram = new Diagram();
diagram.yachts = new List <List <int> >();
diagram.devices = new List <List <int> >();
Diagrams(0);
}
private void Loading()
{
data = new MysqlMessage();
if (!Globals.User.login.admin)
{
Messages = data.MysqlUserMessages();
}
else
{
Messages = data.MysqlAllMessages();
}
diagram = new Diagram();
diagram.yachts = new List <List <int> >();
diagram.devices = new List <List <int> >();
diagram.oszlopC = 7;
diagram.oszlopX = (416.5 / 7) - 7;
diagram.oszlopY = new double[7];
diagram.sorN = new string[7];
diagram.yachts.Clear();
diagram.devices.Clear();
for (int i = 0; i < 7; i++)
{
days days = (days)i;
diagram.sorN[i] = days.ToString();
string day = diagram.sorN[i].ToUpper();
if (Globals.User.login.admin)
{
diagram.oszlopY[i] = Messages.Count(x => string.Format("{0:yyyy,MMMM,dddd}", x.keletkezett).ToUpper() == (string.Format("{0:yyyy,MMMM}", DateTime.Now).ToUpper()) + "," +
day && x.elfogadvabl);
diagram.yachts.Add(Messages.Where(x => string.Format("{0:yyyy,MMMM,dddd}", x.keletkezett).ToUpper() == (string.Format("{0:yyyy,MMMM}", DateTime.Now).ToUpper()) + "," +
day && x.yacht_id != 0 && x.elfogadvabl).Select(x => x.yacht_id).ToList());
diagram.devices.Add(Messages.Where(x => string.Format("{0:yyyy,MMMM,dddd}", x.keletkezett).ToUpper() == (string.Format("{0:yyyy,MMMM}", DateTime.Now).ToUpper()) + "," +
day && x.device_id != 0 && x.elfogadvabl).Select(x => x.device_id).ToList());
}
else
{
diagram.oszlopY[i] = Messages.Count(x => string.Format("{0:yyyy,MMMM,dddd}", x.keletkezett).ToUpper() == (string.Format("{0:yyyy,MMMM}", DateTime.Now).ToUpper()) + "," +
day && x.elfogadvabl && x.cimzett_id == Globals.User.member_id);
diagram.yachts.Add(Messages.Where(x => string.Format("{0:yyyy,MMMM,dddd}", x.keletkezett).ToUpper() == (string.Format("{0:yyyy,MMMM}", DateTime.Now).ToUpper()) + "," +
day && x.yacht_id != 0 && x.elfogadvabl && x.cimzett_id == Globals.User.member_id).Select(x => x.yacht_id).ToList());
diagram.devices.Add(Messages.Where(x => string.Format("{0:yyyy,MMMM,dddd}", x.keletkezett).ToUpper() == (string.Format("{0:yyyy,MMMM}", DateTime.Now).ToUpper()) + "," +
day && x.device_id != 0 && x.elfogadvabl && x.cimzett_id == Globals.User.member_id).Select(x => x.device_id).ToList());
}
}
berles();
}
