public static tblChampionMetaData searchDB(string searchName)//searched table for object with name equal to passed string
{
using (localdbChampionModel context = new localdbChampionModel())
{
tblChampionMetaData championObj = context.tblChampionMetaDatas.FirstOrDefault(r => r.name == searchName);
return(championObj);
}
}
public static List <tblChampionMetaData> championList()
{
using (localdbChampionModel champs = new localdbChampionModel())
{
var champList = champs.tblChampionMetaDatas;
var db = champList.ToList();//creates list of every champion in database as an object into the variable 'db'
//db.Find(c => c.name == "Lissandra");
return(champList.ToList());
}
}
public static void deleteRecord(string passed_name)
{
using (localdbChampionModel context = new localdbChampionModel())
{
tblChampionMetaData champion = new tblChampionMetaData {
name = passed_name
};
var champtest = updatedb.searchDB(passed_name);
context.tblChampionMetaDatas.Attach(champtest);
context.tblChampionMetaDatas.Remove(champtest);
context.SaveChanges();
}
}
public static void selectDBtest()
{
//using (ChampionsModel context = new ChampionsModel())
using (localdbChampionModel context = new localdbChampionModel())
{
tblChampionMetaData champion = context.tblChampionMetaDatas.FirstOrDefault(r => r.name == "Lissandra" && r.passive == "corki");
var result = context.tblChampionMetaDatas.Where(r => r.name == "Lissandra" && r.passive == "corki");
var mylist = championList();
//tblTest champion = context.tblTests.FirstOrDefault(r => r.name == "Xayah");
Console.WriteLine("You chose " + champion.name);
Console.WriteLine("Their passive is " + champion.passive);
Console.WriteLine("Base AD is " + champion.basead);
Console.WriteLine("Image link is " + champion.imageLink);
//Console.ReadLine();
}
}
public static void editRecord(string name, int hp, int hpregen, int mana, int manaregen, int range, int ad, float attackspeed, int armour, int mr, int speed, int bluePrice, int rpPrice, string Q, string W, string E, string R, string passive, string imageLink)
{
using (localdbChampionModel db = new localdbChampionModel())
{
tblChampionMetaData champion = new tblChampionMetaData
{
//name = inName, passive = inPassive, basead = inBasead
//name = "Xayah", basead=64, passive="Clean Cuts"
name = name.TrimEnd(),
basehp = hp,
hpregen = hpregen,
basemana = mana,
basemanaregen = manaregen,
range = range,
basead = ad,
baseattackspeed = attackspeed,
basearmour = armour,
basemr = mr,
basespeed = speed,
bluePrice = bluePrice,
rpPrice = rpPrice,
Q = Q.TrimEnd(),
W = W.TrimEnd(),
E = E.TrimEnd(),
R = R.TrimEnd(),
passive = passive.TrimEnd(),
imageLink = imageLink.TrimEnd()
};
var original = db.tblChampionMetaDatas.Find(champion.name);
if (original != null)
{
db.Entry(original).CurrentValues.SetValues(champion);
var test = champion.passive;
db.SaveChanges();
}
}
}
public static void pushDB(string name, int hp, int hpregen, int mana, int manaregen, int range, int ad, float attackspeed, int armour, int mr, int speed, int bluePrice, int rpPrice, string Q, string W, string E, string R, string passive, string imageLink)
{
using (localdbChampionModel context = new localdbChampionModel())
{
tblChampionMetaData champion = new tblChampionMetaData
{
//name = "Xayah", basead=64, passive="Clean Cuts"
//name = name, basehp = hp, hpregen = hpregen, basemana = mana, basemanaregen=manaregen, range = range, basead = ad,
//baseattackspeed = attackspeed, basearmour = armour, basemr = mr, basespeed = speed, bluePrice = bluePrice, rpPrice = rpPrice, Q = Q, W = W, E = E, R = R, passive = passive, imageLink = imageLink
name = name.Trim(),
basehp = hp,
hpregen = hpregen,
basemana = mana,
basemanaregen = manaregen,
range = range,
basead = ad,
baseattackspeed = attackspeed,
basearmour = armour,
basemr = mr,
basespeed = speed,
bluePrice = bluePrice,
rpPrice = rpPrice,
Q = Q.Trim(),
W = W.Trim(),
E = E.Trim(),
R = R.Trim(),
passive = passive.Trim(),
imageLink = imageLink.Trim()
};
try
{
context.tblChampionMetaDatas.Add(champion);
}
catch { }
context.SaveChanges();
}
}