public string Get()
{
using (var DBContext = new HeartstatDBDataContext())
{
for(int i = 0; i < 10; i++){
Match seedMatch = new Match
{
User = "******"+i.ToString(),
UserClass = "Druid",
SubClass = "Ramp",
OpponentClass = "Warlock",
OpponentSubClass = "Zoo",
MatchResult = false,
PlayerRank = 18,
Season = 5,
Created = DateTime.Now,
Comment = "Paska peli",
UserId = "1111-1111111-1111-111"
};
DBContext.Matches.InsertOnSubmit(seedMatch);
}
try
{
DBContext.SubmitChanges();
return "Database seed completed";
}
catch (Exception ex)
{
return ex.Message;
}
}
}
public string GetSubClasses()
{
List<string> subClasses = new List<string> { "Aggro", "Control", "Ramp", "Miracle", "Tempo", "Hybrid",
"Fatigue", "Face", "Freeze", "Midrange", "Mech", "Pirate",
"Dragon", "Zoo", "Hand", "Demon" };
using (var db = new HeartstatDBDataContext())
{
foreach (string subClass in subClasses)
{
Decktype newClass = new Decktype();
newClass.SubClass = subClass;
db.Decktypes.InsertOnSubmit(newClass);
}
try
{
db.SubmitChanges();
return "Database seed completed";
}
catch
{
return "Something went wrong";
}
}
}
public List<Decktype> GetSub()
{
using (var dbx = new HeartstatDBDataContext())
{
var subClasses = (from c in dbx.Decktypes
select c).ToList();
List<Decktype> allSubClasses = subClasses;
return allSubClasses;
}
}
public List<Class> GetMain()
{
using (var dbx = new HeartstatDBDataContext())
{
var classes = (from c in dbx.Classes
select c).ToList();
List<Class> allClasses = classes;
return allClasses;
}
}
// Get api/Games lol
public List<Match> Get(string userClass = "", string opponentClass = "")
{
List<Match> allPlayed = new List<Match>();
using (var dbx = new HeartstatDBDataContext())
{
dbx.DeferredLoadingEnabled = false;
if (userClass != "" && opponentClass != "")
{
var AllPlayed = from p in dbx.Matches
where p.OpponentClass == opponentClass && p.UserClass == userClass
select p;
allPlayed = AllPlayed.ToList();
}
else if (userClass != "")
{
var AllPlayed = from p in dbx.Matches
where p.UserClass == userClass
select p;
allPlayed = AllPlayed.ToList();
}
else if(opponentClass != "")
{
var AllPlayed = from p in dbx.Matches
where p.OpponentClass == opponentClass
select p;
allPlayed = AllPlayed.ToList();
}
else
{
var AllPlayed = from p in dbx.Matches
select p;
allPlayed = AllPlayed.ToList();
}
return allPlayed;
}
}
public string PostMatchSave(Match match)
{
string username = "******";
using (var DBContext = new HeartstatDBDataContext())
{
var User = from u in DBContext.AspNetUsers
where u.UserName == System.Web.HttpContext.Current.User.Identity.Name
select u.UserName;
if (User.FirstOrDefault() != null)
{
username = User.FirstOrDefault();
}
Match matchToBeSaved = new Match
{
User = username,
UserClass = match.UserClass,
SubClass = match.SubClass,
OpponentClass = match.OpponentClass,
OpponentSubClass = match.OpponentSubClass,
MatchResult = (bool)match.MatchResult,
PlayerRank = (int)match.PlayerRank,
Season = (int)match.Season,
Created = DateTime.Now,
Comment = match.Comment,
UserId = "112111-11111-1111-1111"
};
DBContext.Matches.InsertOnSubmit(matchToBeSaved);
try
{
DBContext.SubmitChanges();
return "Game Saved";
}
catch(Exception ex)
{
return ex.Message;
}
}
}
public string GetClasses()
{
List<string> mainClasses = new List<string> { "Druid", "Hunter", "Mage", "Paladin", "Priest", "Rogue", "Shaman", "Warlock", "Warrior" };
using (var db = new HeartstatDBDataContext())
{
foreach (string mainClass in mainClasses)
{
Class newClassAggro = new Class();
newClassAggro.MainClass = mainClass;
db.Classes.InsertOnSubmit(newClassAggro);
}
try
{
db.SubmitChanges();
return "Database seed completed";
}
catch
{
return "Something went wrong";
}
}
}
