public List <dnd_dal.DndSpell> Query_dndSpellByID(long spellId)
{
dndContext db = new dndContext();
var query =
from spell in db.DndSpell
where spell.Id == spellId
select spell;
return(query.ToList());
}
public List <dnd_dal.DndSpell> Query_dndSpellByName(string name)
{
dndContext db = new dndContext();
var query =
from spell in db.DndSpell
where spell.Name.ToLower() == name.ToLower()
select spell;
return(query.ToList());
}
public List <DndFeat> Query_dndFeatBySlug(string featSlug)
{
dndContext db = new dndContext();
var query =
from feat in db.DndFeat
where feat.Slug.ToLower() == featSlug.ToLower()
select feat;
return(query.ToList());
}
public List <DndFeatrequiresfeat> Query_dndFeatRequiredBy(long featId)
{
dndContext db = new dndContext();
var query =
from req in db.DndFeatrequiresfeat
where req.SourceFeatId == featId
select req;
return(query.ToList());
}
public List <DndSpellclasslevel> Query_GetCharacterClassSpellLevel(long characterclassId)
{
dndContext db = new dndContext();
var query =
from spellCL in db.DndSpellclasslevel
where spellCL.CharacterClassId == characterclassId
select spellCL;
return(query.ToList());
}
public List <DndFeat> Query_dndFeatByID(long featId)
{
dndContext db = new dndContext();
var query =
from feat in db.DndFeat
where feat.Id == featId
select feat;
return(query.ToList());
}
public List <DndCharacterclass> Query_GetCharacterClassBySlug(string slug)
{
dndContext db = new dndContext();
var query =
from characterclass in db.DndCharacterclass
where characterclass.Slug == slug
select characterclass;
return(query.ToList());
}
public List <DndCharacterclass> Query_GetCharacterClassByName(string name)
{
dndContext db = new dndContext();
var query =
from characterclass in db.DndCharacterclass
where characterclass.Name.ToLower() == name.ToLower()
select characterclass;
return(query.ToList());
}
public List <DndCharacterclass> Query_GetCharacterClassById(long id)
{
dndContext db = new dndContext();
var query =
from characterclass in db.DndCharacterclass
where characterclass.Id == id
select characterclass;
return(query.ToList());
}
public List <DndRulebook> Query_dndRuleBooks(List <long> ids)
{
var dndContext = new dndContext();
var query =
from rulebook in dndContext.DndRulebook
where ids.Contains(rulebook.Id)
select rulebook;
return(query.ToList());
}
public List <SpellClassLevel> Query_ClassAndLevelBySpell(long SpellId)
{
dndContext db = new dndContext();
var query =
from spellclasslevel in db.DndSpellclasslevel
join cc in db.DndCharacterclass.DefaultIfEmpty() on spellclasslevel.CharacterClassId equals cc.Id into char_class
from characterclass in char_class.DefaultIfEmpty()
where spellclasslevel.SpellId == SpellId
select new SpellClassLevel
{
SpellId = spellclasslevel.SpellId,
ClassId = spellclasslevel.CharacterClassId,
LevelForClass = spellclasslevel.Level,
ClassName = characterclass.Name
};
return(query.ToList());
}
//public List<SpellClassLevel> Query_SpellClassByName(string name)
//{
// dndContext db = new dndContext();
// var query =
// from cc in db.DndCharacterclass
// join scl in db.DndSpellclasslevel.DefaultIfEmpty() on cc.Id equals scl.CharacterClassId into spell_class_level
// from spellcl in spell_class_level.DefaultIfEmpty()
// join s in db.DndSpell.DefaultIfEmpty() on spellcl.SpellId equals s.Id into sp
// from spell in sp.DefaultIfEmpty()
// where spell.Name.ToLower() == name.ToLower()
// select new SpellClassLevel
// {
// SpellId = spell.Id,
// SpellName = spell.Name,
// ClassId = spellcl.CharacterClassId,
// ClassName = cc.Name,
// LevelForClass = spellcl.Level
// };
// return query.ToList();
//}
//public List<SpellClassLevel> Query_SpellClassById(long id)
//{
// dndContext db = new dndContext();
// var query =
// from cc in db.DndCharacterclass
// join scl in db.DndSpellclasslevel.DefaultIfEmpty() on cc.Id equals scl.CharacterClassId into spell_class_level
// from spellcl in spell_class_level.DefaultIfEmpty()
// join s in db.DndSpell.DefaultIfEmpty() on spellcl.SpellId equals s.Id into sp
// from spell in sp.DefaultIfEmpty()
// where spell.Id == id
// select new SpellClassLevel
// {
// SpellId = spell.Id,
// SpellName = spell.Name,
// ClassId = spellcl.CharacterClassId,
// ClassName = cc.Name,
// LevelForClass = spellcl.Level
// };
// return query.ToList();
//}
//public List<SpellClassLevel> Query_SpellClassBySlug(string slug)
//{
// dndContext db = new dndContext();
// var query =
// from cc in db.DndCharacterclass
// join scl in db.DndSpellclasslevel.DefaultIfEmpty() on cc.Id equals scl.CharacterClassId into spell_class_level
// from spellcl in spell_class_level.DefaultIfEmpty()
// join s in db.DndSpell.DefaultIfEmpty() on spellcl.SpellId equals s.Id into sp
// from spell in sp.DefaultIfEmpty()
// where spell.Slug.ToLower() == slug.ToLower()
// select new SpellClassLevel
// {
// SpellId = spell.Id,
// SpellName = spell.Name,
// ClassId = spellcl.CharacterClassId,
// ClassName = cc.Name,
// LevelForClass = spellcl.Level
// };
// return query.ToList();
//}
#endregion
#region SpellsByClassAndLevel
public List <SpellClassLevel> Query_SpellsByClassAndLevel(string CasterClass, long CasterLevel)
{
dndContext db = new dndContext();
var query =
from cc in db.DndCharacterclass
join scl in db.DndSpellclasslevel.DefaultIfEmpty() on cc.Id equals scl.CharacterClassId into spell_class_level
from spellcl in spell_class_level.DefaultIfEmpty()
join s in db.DndSpell.DefaultIfEmpty() on spellcl.SpellId equals s.Id into sp
from spell in sp.DefaultIfEmpty()
where cc.Slug.ToLower() == CasterClass.ToLower()
where spellcl.Level == CasterLevel
select new SpellClassLevel
{
SpellId = spell.Id,
SpellName = spell.Name,
ClassId = spellcl.CharacterClassId,
ClassName = cc.Name,
LevelForClass = spellcl.Level
};
return(query.ToList());
}
public LookupLogic(dndContext databaseContext)
{
base.db = databaseContext;
}
public ClassController(dndContext context)
{
_context = context;
}
public SpellsController(dndContext context)
{
_context = context;
//_find = new Search.Search();
}
public BaseLogic()
{
db = new dndContext();
}
