public Statistic getOneUserStatistics(int userId)
{
Statistic stat;
Words word;
Setup setup;
User user;
List<Statistic> statsList = new List<Statistic>();
var stats = tabadapStat.GetStatisticByUserId(userId);
stat = new Statistic();
for (int i = 0; i < stats.Count(); i++)
{
word = new Words();
setup = new Setup();
user = new User();
stat.WordList = new List<Words>();
stat.UserList = new List<User>();
stat.SetupList = new List<Setup>();
for (int j = 0; j < stats.Rows[i].ItemArray.Count(); j++)
{
user.Id = (int)stats.Rows[i].ItemArray[5];
user.Pseudo = (string)stats.Rows[i].ItemArray[6];
word.Id = (int)stats.Rows[i].ItemArray[7];
word.Name = (string)stats.Rows[i].ItemArray[8];
setup.Id = (int)stats.Rows[i].ItemArray[9];
setup.MaxTry = (int)stats.Rows[i].ItemArray[10];
/*stat.id = (int)stats.Rows[i].ItemArray[1];
stat.UserId = (int)stats.Rows[i].ItemArray[2];
stat.WordId = (int)stats.Rows[i].ItemArray[3];
stat.SetupId = (int)stats.Rows[i].ItemArray[4];
stat.NbTry = (int)stats.Rows[i].ItemArray[5];*/
stat.WordList.Add(word);
stat.SetupList.Add(setup);
stat.UserList.Add(user);
}
}
return stat;
}
public Statistic DeleteStatistic(Statistic statistic)
{
throw new NotImplementedException();
}
private List<Statistic> GetListStatisticFromTableAdapter(HiddenWordDAL.DataModel.DsHiddenWord.statisticDataTable source)
{
Statistic stats = new Statistic();
List<Statistic> listStats = new List<Statistic>();
foreach (var row in source)
{
stats.Id = row.id;
stats.UserId = row.UserId;
stats.SetupId = row.SetupId;
stats.NbTry = row.NbTry;
listStats.Add(stats);
}
return listStats;
}
public Statistic DeleteStatistic(Statistic statistic)
{
return DALAccess.DeleteStatistic(statistic);
}
public List<Statistic> getUsersStatistics()
{
//var tabadap = new usersTableAdapter();
//var tabadapStat = new statisticTableAdapter();
var users = tabadapUser.GetUsers();
Statistic stat;
Words word;
Setup setup;
List<User> userList = new List<User>();
List<Statistic> statsList = new List<Statistic>();
foreach (var row in users)
{
var stats = tabadapStat.GetStatisticByUserId(row.id);
stat = new Statistic();
stat.User.Id = row.id;
stat.User.Pseudo = row.Pseudo;
foreach (var rowStat in stats)
{
word = new Words();
setup = new Setup();
word.Id = rowStat.wordsRow.id;
word.Name = rowStat.wordsRow.Name;
setup.Id = rowStat.setupsRow.id;
setup.MaxTry = rowStat.setupsRow.MaxTry;
stat.WordList.Add(word);
stat.SetupList.Add(setup);
}
statsList.Add(stat);
}
return statsList;
}
public Statistic UpdateStatistic(Statistic statistic)
{
return DALAccess.UpdateStatistic(statistic);
}
public Statistic DeleteStatistic(Statistic statistic)
{
return genericMethode.deleteXmlData<Statistic>("XStatistic", statistic.Id.ToString());
}
private List<Statistic> bindXmlObjectToStatistic(List<XStatistic> xmlOjectList )
{
List<Statistic> listStatistic = new List<Statistic>();
foreach (XStatistic result in xmlOjectList)
{
Statistic statisticTmp = new Statistic();
statisticTmp.Id = result.ID;
statisticTmp.NbTry = result.nbtry;
statisticTmp.SetupId = result.setupid;
statisticTmp.WordId = result.wordid;
statisticTmp.UserId = result.userid;
listStatistic.Add(statisticTmp);
}
return listStatistic;
}
public Statistic UpdateStatistic(Statistic statistic)
{
Dictionary<string, string> param = new Dictionary<string, string>();
param["ID"] = statistic.Id.ToString();
param["nbtry"] = statistic.NbTry.ToString();
param["setupid"] = statistic.SetupId.ToString();
param["wordid"] = statistic.WordId.ToString();
param["userid"] = statistic.UserId.ToString();
return genericMethode.updateXmlData<Statistic>("XStatistic", param);
}
public Statistic insertStatistic(int userId, int wordId, int nbTry, int setupId)
{
XStatistic statistic = new XStatistic();
statistic.ID = genericMethode.autoIncrementXmlDataPrimaryKey("XStatistic", "ID");
statistic.userid = userId;
statistic.wordid = wordId;
statistic.setupid = setupId;
statistic.nbtry = nbTry;
HiddenWord hiddenWord = new HiddenWord();
hiddenWord.Item = statistic;
List<XStatistic> paramList = new List<XStatistic>();
paramList.Add(genericMethode.saveXmlData<XStatistic>(hiddenWord, "XStatistic", statistic.ID.ToString()));
List<Statistic> statisticList = bindXmlObjectToStatistic(paramList);
Statistic result = new Statistic();
if (statisticList.Count != 0)
{
result = statisticList[0];
}
return result;
}
