public static List<LegaGladio.Entities.Positional> listPositional()
{
LegaGladioDSTableAdapters.positionalTableAdapter pta = new LegaGladioDSTableAdapters.positionalTableAdapter();
LegaGladioDSTableAdapters.positional_skillTableAdapter psta = new LegaGladioDSTableAdapters.positional_skillTableAdapter();
List<LegaGladio.Entities.Positional> positionalList = new List<LegaGladio.Entities.Positional>();
LegaGladioDS.positionalDataTable pdt = pta.GetData();
foreach (LegaGladioDS.positionalRow pr in pdt.Rows)
{
LegaGladio.Entities.Positional positional = Positional.getPositional((int)pr.id);
positionalList.Add(positional);
}
return positionalList;
}
public static LegaGladio.Entities.Positional getPositional(int id)
{
LegaGladioDSTableAdapters.positionalTableAdapter pta = null;
LegaGladioDSTableAdapters.positional_skillTableAdapter psta = null;
LegaGladioDS.positionalDataTable pdt = null;
LegaGladioDS.positionalRow pr = null;
LegaGladio.Entities.Positional positional = null;
try
{
pta = new LegaGladioDSTableAdapters.positionalTableAdapter();
pdt = pta.GetDataById(id);
if (pdt.Rows.Count > 1)
{
throw new Exception("Troppi positional trovati per l'ID " + id);
}
pr = (LegaGladioDS.positionalRow)pdt.Rows[0];
positional = new LegaGladio.Entities.Positional();
positional.Ma = pr.ma;
positional.St = pr.st;
positional.Ag = pr.ag;
positional.Av = pr.av;
positional.Cost = pr.cost;
positional.Qty = pr.qty;
positional.Title = pr.title;
psta = new LegaGladioDSTableAdapters.positional_skillTableAdapter();
LegaGladioDS.positional_skillDataTable psdt = psta.GetDataByPositionalId((int)pr.id);
foreach (LegaGladioDS.positional_skillRow psr in psdt.Rows)
{
LegaGladio.Entities.Skill skill = Skill.getSkill((int)psr.skillID);
switch (skill.SkillType)
{
case LegaGladio.Entities.SkillType.AGILITY:
positional.Agility.Add(skill);
break;
case LegaGladio.Entities.SkillType.EXTRAORDINARY:
positional.Extraordinary.Add(skill);
break;
case LegaGladio.Entities.SkillType.GENERAL:
positional.General.Add(skill);
break;
case LegaGladio.Entities.SkillType.MUTATION:
positional.Mutation.Add(skill);
break;
case LegaGladio.Entities.SkillType.PASSING:
positional.Passing.Add(skill);
break;
case LegaGladio.Entities.SkillType.STRENGTH:
positional.Strength.Add(skill);
break;
}
}
}
catch (Exception ex)
{
throw ex;
}
return positional;
}
public static Boolean deletePositional(int id)
{
LegaGladioDSTableAdapters.positionalTableAdapter pta = new LegaGladioDSTableAdapters.positionalTableAdapter();
LegaGladioDSTableAdapters.positional_skillTableAdapter psta = new LegaGladioDSTableAdapters.positional_skillTableAdapter();
Boolean works = true;
LegaGladio.Entities.Positional positional = Positional.getPositional(id);
works &= Skill.deleteSkills(positional.Agility);
works &= Skill.deleteSkills(positional.General);
works &= Skill.deleteSkills(positional.Strength);
works &= Skill.deleteSkills(positional.Passing);
works &= Skill.deleteSkills(positional.Mutation);
works &= Skill.deleteSkills(positional.Extraordinary);
int rowNum = pta.Delete(id);
return rowNum == 1 && works;
}
public static Boolean updatePositional(LegaGladio.Entities.Positional positional, int oldID)
{
LegaGladioDSTableAdapters.positionalTableAdapter pta = new LegaGladioDSTableAdapters.positionalTableAdapter();
LegaGladioDSTableAdapters.positional_skillTableAdapter psta = new LegaGladioDSTableAdapters.positional_skillTableAdapter();
int rowNum = pta.Update(positional.Qty, positional.Title, (Decimal)positional.Cost, positional.Ma, positional.St, positional.Ag, positional.Av, oldID);
LegaGladioDS.positional_skillDataTable psdt = psta.GetDataByPositionalId(positional.Id);
List<LegaGladio.Entities.Skill> agilityList = new List<LegaGladio.Entities.Skill>();
List<LegaGladio.Entities.Skill> generalList = new List<LegaGladio.Entities.Skill>();
List<LegaGladio.Entities.Skill> strengthList = new List<LegaGladio.Entities.Skill>();
List<LegaGladio.Entities.Skill> passingList = new List<LegaGladio.Entities.Skill>();
List<LegaGladio.Entities.Skill> mutationList = new List<LegaGladio.Entities.Skill>();
List<LegaGladio.Entities.Skill> extraordinaryList = new List<LegaGladio.Entities.Skill>();
foreach (LegaGladioDS.positional_skillRow psRow in psdt)
{
LegaGladio.Entities.Skill skill = Skill.getSkill((int)psRow.skillID);
switch (skill.SkillType)
{
case LegaGladio.Entities.SkillType.AGILITY:
agilityList.Add(skill);
break;
case LegaGladio.Entities.SkillType.GENERAL:
generalList.Add(skill);
break;
case LegaGladio.Entities.SkillType.STRENGTH:
strengthList.Add(skill);
break;
case LegaGladio.Entities.SkillType.PASSING:
passingList.Add(skill);
break;
case LegaGladio.Entities.SkillType.MUTATION:
mutationList.Add(skill);
break;
case LegaGladio.Entities.SkillType.EXTRAORDINARY:
extraordinaryList.Add(skill);
break;
}
}
List<LegaGladio.Entities.Skill> listaAggiunte = new List<LegaGladio.Entities.Skill>();
List<LegaGladio.Entities.Skill> listaRimozioni = new List<LegaGladio.Entities.Skill>();
listaAggiunte.AddRange((List<LegaGladio.Entities.Skill>)positional.Agility.Except(agilityList));
listaAggiunte.AddRange((List<LegaGladio.Entities.Skill>)positional.General.Except(generalList));
listaAggiunte.AddRange((List<LegaGladio.Entities.Skill>)positional.Strength.Except(strengthList));
listaAggiunte.AddRange((List<LegaGladio.Entities.Skill>)positional.Passing.Except(passingList));
listaAggiunte.AddRange((List<LegaGladio.Entities.Skill>)positional.Mutation.Except(mutationList));
listaAggiunte.AddRange((List<LegaGladio.Entities.Skill>)positional.Extraordinary.Except(extraordinaryList));
listaRimozioni.AddRange((List<LegaGladio.Entities.Skill>)agilityList.Except(positional.Agility));
listaRimozioni.AddRange((List<LegaGladio.Entities.Skill>)generalList.Except(positional.General));
listaRimozioni.AddRange((List<LegaGladio.Entities.Skill>)strengthList.Except(positional.Strength));
listaRimozioni.AddRange((List<LegaGladio.Entities.Skill>)passingList.Except(positional.Passing));
listaRimozioni.AddRange((List<LegaGladio.Entities.Skill>)mutationList.Except(positional.Mutation));
listaRimozioni.AddRange((List<LegaGladio.Entities.Skill>)extraordinaryList.Except(positional.Extraordinary));
Skill.newSkills(listaAggiunte);
Skill.deleteSkills(listaRimozioni);
return rowNum == 1;
}
public static Boolean newPositional(LegaGladio.Entities.Positional positional)
{
LegaGladioDSTableAdapters.positionalTableAdapter pta = new LegaGladioDSTableAdapters.positionalTableAdapter();
LegaGladioDSTableAdapters.positional_skillTableAdapter psta = new LegaGladioDSTableAdapters.positional_skillTableAdapter();
//g, a, s, p, m, e
int id = (int)pta.InsertPositional(positional.Qty, positional.Title, (Decimal)positional.Cost, positional.Ma, positional.St, positional.Ag, positional.Av);
foreach (LegaGladio.Entities.Skill skill in positional.Agility)
{
psta.InsertPositionalSkill(id, skill.Id);
}
foreach (LegaGladio.Entities.Skill skill in positional.General)
{
psta.InsertPositionalSkill(id, skill.Id);
}
foreach (LegaGladio.Entities.Skill skill in positional.Strength)
{
psta.InsertPositionalSkill(id, skill.Id);
}
foreach (LegaGladio.Entities.Skill skill in positional.Passing)
{
psta.InsertPositionalSkill(id, skill.Id);
}
foreach (LegaGladio.Entities.Skill skill in positional.Mutation)
{
psta.InsertPositionalSkill(id, skill.Id);
}
foreach (LegaGladio.Entities.Skill skill in positional.Extraordinary)
{
psta.InsertPositionalSkill(id, skill.Id);
}
return id > -1;
}
