/// <summary>
/// Prepare table partial view
/// </summary>
/// <returns></returns>
public IActionResult Table()
{
WebTest wt = new WebTest();
while (Driver._requests != 0)
{
}
//Get the webtests info
tests = wt.GetUserTests(HomeController._username, Driver._batch, HomeController._database);
PageSpeedAPI psa = new PageSpeedAPI();
GoogleTest gt = new GoogleTest();
//Loop through the number of general tests and create a corresponding google test
for (int i = 0; i < tests.Count; i++)
{
int seconds = tests[i].loadtime.Seconds;
//Using the page speed API, insert into database and then add to the table view
psa.InsertPageSpeed(tests[i].url, tests[i].loadtime.Seconds, tests[i].guid);
//Find the matching google test
GoogleTest test = gt.GetGoogleUserTests(tests[i].guid, HomeController._database);
tests[i].googleTest = test;
}
return(PartialView(tests));
}
public async Task dicescraping(string set)
{
await ReplyAsync("started");
string sheet = set;
sheet = sheet.ToUpper();
string sheetref = sheet + "!";
GoogleTest.Main(sheetref);
var test = GoogleTest._values;
foreach (var row in test)
{
CName = (string)row[1];
CRarity = (string)row[5];
CUrl = (string)row[9];
if (CRarity == "Common")
{
imagesaver(CUrl, set);
}
}
await ReplyAsync("Done");
}
void Awake()
{
Instantiate(googleAnalytics);
googleAnalytics.StartSession();
if (instance == null)
{
instance = this;
}
else if (instance != this)
{
Destroy(gameObject);
}
}
/// <summary>
/// Grabs the page speed and inserts into database
/// </summary>
/// <param name="website"></param>
/// <param name="seconds"></param>
/// <param name="guid"></param>
public void InsertPageSpeed(string website, int seconds, Guid guid)
{
HttpClient httpClient = new HttpClient();
httpClient.DefaultRequestHeaders.Add("X-API-Key", _APIkey);
string url = String.Format(_url, website, _APIkey);
HttpResponseMessage msg = null;
try
{
msg = httpClient.GetAsync(url).Result;
} catch (AggregateException)
{
Debug.WriteLine("API (Page Speed): Cannot get speed results.");
}
if (msg != null)
{
using (msg)
{
if (msg.IsSuccessStatusCode)
{
var data = msg.Content.ReadAsStringAsync().Result;
var json = JsonConvert.DeserializeObject <PageSpeed>(data);
if (json != null)
{
GoogleTest pst = new GoogleTest();
WebTest wt = new WebTest();
decimal webspeed = (decimal)((json.stats.bytes / seconds) * .000008);
pst.CreateGoogleTest(guid, json.ruleGroups.speed.score, json.experience.category, json.stats.numResources,
json.stats.numHosts, json.stats.bytes, json.stats.htmlBytes, json.stats.cssBytes, json.stats.imageBytes,
webspeed, HomeController._database);
}
}
}
}
}
/// <summary>
/// Load detailed table partial view
/// </summary>
/// <param name="city"></param>
/// <param name="state"></param>
/// <param name="browser"></param>
/// <param name="website"></param>
/// <param name="order"></param>
/// <returns></returns>
public IActionResult DetailedTable(string city, string state, string browser, string website, bool order)
{
GoogleTest gt = new GoogleTest();
List <GoogleTest> tests;
//Check if a specific city was entered, else assume all
if (!String.IsNullOrEmpty(city))
{
string temp = city;
city = city.ToLower();
if (String.IsNullOrEmpty(state))
{
County county = new County();
state = county.GetState(temp, HomeController._database);
}
}
//Get the default array
string[] defArr = GetDefault(browser, website);
tests = gt.GetGoogleTests(city, state, defArr[0], defArr[1], order, HomeController._database);
return(PartialView(tests));
}
public async Task combiner2(string dice, string text)
{
if ((dice.ToLower() != "dice") && (dice.ToLower() != "die") && (dice.ToLower() != "nodice") && (dice.ToLower() != "nodie"))
{
await Error("dice", dice);
}
else
{
string[] promonames = new string[]
{
"AVXOP", "BFFOP", "BFFPR", "D2016", "DC2016", "D2017", "JLOP", "M2015", "M2016", "M2017", "UXMOP", "UXMOP2", "WKO16D", "WKO16M"
};
string[] promoset = new string[10];
string teamname = text.Substring(text.IndexOf("&name=") + 6);
teamname = teamname.Replace("%20", " ");
teamname = teamname.Replace("%26", "&");
teamname = teamname.Replace("%27", "'");
text = text.Substring(text.IndexOf("cards=") + 6);
if (text.Contains("&name="))
{
text = text.Substring(0, text.IndexOf("&name="));
}
else
{
teamname = "Unnamed";
}
text = text.ToLower();
List <string> list = text.Split(';').ToList(); //Creates a list
string holder1;
string holder2;
int number;
if (list.Count < 10)
{
int toappend = 10 - list.Count;
for (int i = 0; i < toappend; i++)
{
list.Add("1xblank1");
}
}
await Context.Channel.SendMessageAsync("Compiling images");
List <string> list2 = new List <string>();
for (int i = 0; i < list.Count; i++) //Turn the list into readable indexes
{
bool contains = false;
list2.Add(list[i].Substring(0, list[i].IndexOf("x")));
list[i] = list[i].Substring(list[i].IndexOf("x") + 1);
holder1 = Regex.Match(list[i], @"\d+").Value;
holder2 = Regex.Replace(list[i], @"^[\d-]*\s*", string.Empty);
for (int k = 0; k < promonames.Length; k++)
{
if (holder2.ToUpper().Contains(promonames[k]))
{
contains = true;
}
}
number = Convert.ToInt32(holder1);
if (number < 10)
{
holder1 = "00" + holder1;
}
else if ((number >= 10) && (number < 100))
{
holder1 = "0" + holder1;
}
//holder2 = new String(list[i].Where(Char.IsLetter).ToArray());
if (holder2 == "imw")
{
holder2 = "Imw";
}
else if (holder2 == "smc")
{
holder2 = "smc";
}
else if (holder2 == "sww")
{
holder2 = "sww";
}
else if (contains == true)
{
promoset[i] = holder2;
holder2 = "PROMO";
}
//else if ((holder2 == "dc") || (holder2 == "m") || (holder2 == "bffop"))
//{
// holder1 = "001";
// holder2 = "blank";
//}
if (contains != true)
{
list[i] = holder2 + holder1;
}
else
{
list[i] = holder2 + "#" + holder1;
}
}
string sheet;
string card;
using (WebClient wc = new WebClient())
{
for (int j = 0; j < list.Count; j++)
{
sheet = new String(list[j].Where(Char.IsLetter).ToArray());
if (list[j].Contains("PROMO"))
{
list[j] = list[j].Replace("PROMO", promoset[j]);
}
card = list[j].ToUpper();
string sheetref = sheet + "!";
GoogleTest.Main(sheetref);
var test = GoogleTest._values;
foreach (var row in test)
{
//Check for named cell
if ((string)row[0] == card)
{
//Assign the cells to varibales
url = (string)row[9];
}
}
using (Stream s = wc.OpenRead(url))
{
using (Bitmap bmp = new Bitmap(s))
{
bmp.Save("images/test" + j + ".jpg");
bmp.Dispose();
}
}
}
}
await Context.Channel.SendMessageAsync("Scaling images");
for (int k = 0; k < 10; k++)
{
Resize_Picture("images/test" + k + ".jpg", "images/testmod" + k + ".jpg", 0, 800, 10);
}
System.Drawing.Image source1 = System.Drawing.Image.FromFile("images/testmod0.jpg");
System.Drawing.Image source2 = System.Drawing.Image.FromFile("images/testmod1.jpg");
System.Drawing.Image source3 = System.Drawing.Image.FromFile("images/testmod2.jpg");
System.Drawing.Image source4 = System.Drawing.Image.FromFile("images/testmod3.jpg");
System.Drawing.Image source5 = System.Drawing.Image.FromFile("images/testmod4.jpg");
System.Drawing.Image source6 = System.Drawing.Image.FromFile("images/testmod5.jpg");
System.Drawing.Image source7 = System.Drawing.Image.FromFile("images/testmod6.jpg");
System.Drawing.Image source8 = System.Drawing.Image.FromFile("images/testmod7.jpg");
System.Drawing.Image source9 = System.Drawing.Image.FromFile("images/testmod8.jpg");
System.Drawing.Image source10 = System.Drawing.Image.FromFile("images/testmod9.jpg");
System.Drawing.Image overlay1 = System.Drawing.Image.FromFile(ovelay(list2[0]));
System.Drawing.Image overlay2 = System.Drawing.Image.FromFile(ovelay(list2[1]));
System.Drawing.Image overlay3 = System.Drawing.Image.FromFile(ovelay(list2[2]));
System.Drawing.Image overlay4 = System.Drawing.Image.FromFile(ovelay(list2[3]));
System.Drawing.Image overlay5 = System.Drawing.Image.FromFile(ovelay(list2[4]));
System.Drawing.Image overlay6 = System.Drawing.Image.FromFile(ovelay(list2[5]));
System.Drawing.Image overlay7 = System.Drawing.Image.FromFile(ovelay(list2[6]));
System.Drawing.Image overlay8 = System.Drawing.Image.FromFile(ovelay(list2[7]));
System.Drawing.Image overlay9 = System.Drawing.Image.FromFile(ovelay(list2[8]));
System.Drawing.Image overlay10 = System.Drawing.Image.FromFile(ovelay(list2[9]));
if ((dice.ToLower() == "dice") || (dice.ToLower() == "die"))
{
int toplevel = source1.Width;
int bottomlevel = source4.Width;
if ((source1.Width >= source2.Width) && (source1.Width >= source3.Width) && (source1.Width >= source4.Width))
{
toplevel = source1.Width;
}
else if ((source2.Width >= source1.Width) && (source2.Width >= source3.Width) && (source2.Width >= source4.Width))
{
toplevel = source2.Width;
}
else if ((source3.Width >= source1.Width) && (source3.Width >= source2.Width) && (source3.Width >= source4.Width))
{
toplevel = source3.Width;
}
else if ((source4.Width >= source1.Width) && (source4.Width >= source2.Width) && (source4.Width >= source3.Width))
{
toplevel = source4.Width;
}
if ((source5.Width >= source6.Width) && (source5.Width >= source7.Width) && (source5.Width >= source8.Width))
{
bottomlevel = source5.Width;
}
else if ((source6.Width >= source5.Width) && (source6.Width >= source7.Width) && (source6.Width >= source8.Width))
{
bottomlevel = source6.Width;
}
else if ((source7.Width >= source5.Width) && (source7.Width >= source6.Width) && (source3.Width >= source8.Width))
{
bottomlevel = source7.Width;
}
else if ((source8.Width >= source5.Width) && (source8.Width >= source6.Width) && (source8.Width >= source7.Width))
{
bottomlevel = source8.Width;
}
int picked = 0;
if (toplevel > bottomlevel)
{
picked = toplevel;
}
else if (toplevel < bottomlevel)
{
picked = bottomlevel;
}
else if (toplevel == bottomlevel)
{
picked = bottomlevel;
}
Bitmap bitmap = new Bitmap(picked,
source1.Height);
using (Graphics g = Graphics.FromImage(bitmap))
{
g.DrawImage(source1, 0, 0);
g.DrawImage(overlay1, (source1.Width / 2) - (overlay1.Width / 2), (source1.Height / 2) - (overlay1.Height / 2));
bitmap.Save("images/new0.jpg");
g.DrawImage(source2, 0, 0);
g.DrawImage(overlay2, (source1.Width / 2) - (overlay1.Width / 2), (source1.Height / 2) - (overlay1.Height / 2));
bitmap.Save("images/new1.jpg");
g.DrawImage(source3, 0, 0);
g.DrawImage(overlay3, (source1.Width / 2) - (overlay1.Width / 2), (source1.Height / 2) - (overlay1.Height / 2));
bitmap.Save("images/new2.jpg");
g.DrawImage(source4, 0, 0);
g.DrawImage(overlay4, (source1.Width / 2) - (overlay1.Width / 2), (source1.Height / 2) - (overlay1.Height / 2));
bitmap.Save("images/new3.jpg");
g.DrawImage(source5, 0, 0);
g.DrawImage(overlay5, (source1.Width / 2) - (overlay1.Width / 2), (source1.Height / 2) - (overlay1.Height / 2));
bitmap.Save("images/new4.jpg");
g.DrawImage(source6, 0, 0);
g.DrawImage(overlay6, (source1.Width / 2) - (overlay1.Width / 2), (source1.Height / 2) - (overlay1.Height / 2));
bitmap.Save("images/new5.jpg");
g.DrawImage(source7, 0, 0);
g.DrawImage(overlay7, (source1.Width / 2) - (overlay1.Width / 2), (source1.Height / 2) - (overlay1.Height / 2));
bitmap.Save("images/new6.jpg");
g.DrawImage(source8, 0, 0);
g.DrawImage(overlay8, (source1.Width / 2) - (overlay1.Width / 2), (source1.Height / 2) - (overlay1.Height / 2));
bitmap.Save("images/new7.jpg");
g.DrawImage(source9, 0, 0);
g.DrawImage(overlay9, (source1.Width / 2) - (overlay1.Width / 2), (source1.Height / 2) - (overlay1.Height / 2));
bitmap.Save("images/new8.jpg");
g.DrawImage(source10, 0, 0);
g.DrawImage(overlay10, (source1.Width / 2) - (overlay1.Width / 2), (source1.Height / 2) - (overlay1.Height / 2));
bitmap.Save("images/new9.jpg");
}
await Context.Channel.SendMessageAsync("Combining images");
//using (MagickImageCollection collection = new MagickImageCollection())
//{
// collection.Add(new MagickImage("images/new0.jpg"));
// collection[0].AnimationDelay = 500;
// collection.Add(new MagickImage("images/new1.jpg"));
// collection[1].AnimationDelay = 500;
// collection.Add(new MagickImage("images/new2.jpg"));
// collection[2].AnimationDelay = 500;
// collection.Add(new MagickImage("images/new3.jpg"));
// collection[3].AnimationDelay = 500;
// collection.Add(new MagickImage("images/new4.jpg"));
// collection[4].AnimationDelay = 500;
// collection.Add(new MagickImage("images/new5.jpg"));
// collection[5].AnimationDelay = 500;
// collection.Add(new MagickImage("images/new6.jpg"));
// collection[6].AnimationDelay = 500;
// collection.Add(new MagickImage("images/new7.jpg"));
// collection[7].AnimationDelay = 500;
// collection.Add(new MagickImage("images/new8.jpg"));
// collection[8].AnimationDelay = 500;
// collection.Add(new MagickImage("images/new9.jpg"));
// collection[9].AnimationDelay = 500;
// collection.Write("images/combinedgif.gif");
//}
}
else if ((dice.ToLower() == "nodice") || (dice.ToLower() == "nodie"))
{
await Context.Channel.SendMessageAsync("Combining images");
//using (MagickImageCollection collection = new MagickImageCollection())
//{
// collection.Add(new MagickImage("images/testmod0.jpg"));
// collection[0].AnimationDelay = 500;
// collection.Add(new MagickImage("images/testmod1.jpg"));
// collection[1].AnimationDelay = 500;
// collection.Add(new MagickImage("images/testmod2.jpg"));
// collection[2].AnimationDelay = 500;
// collection.Add(new MagickImage("images/testmod3.jpg"));
// collection[3].AnimationDelay = 500;
// collection.Add(new MagickImage("images/testmod4.jpg"));
// collection[4].AnimationDelay = 500;
// collection.Add(new MagickImage("images/testmod5.jpg"));
// collection[5].AnimationDelay = 500;
// collection.Add(new MagickImage("images/testmod6.jpg"));
// collection[6].AnimationDelay = 500;
// collection.Add(new MagickImage("images/testmod7.jpg"));
// collection[7].AnimationDelay = 500;
// collection.Add(new MagickImage("images/testmod8.jpg"));
// collection[8].AnimationDelay = 500;
// collection.Add(new MagickImage("images/testmod9.jpg"));
// collection[9].AnimationDelay = 500;
// collection.Write("images/combinedgif.gif");
//}
}
await Context.Channel.SendMessageAsync("**" + teamname + "**");
await Context.Channel.SendFileAsync("images/combinedgif.gif");
}
}
public async Task combinernonum(string text)
{
string[] promonames = new string[]
{
"AVXOP", "BFFOP", "BFFPR", "D2016", "DC2016", "DC2017", "D2017", "JLOP", "M2015", "M2016", "M2017", "UXMOP", "UXMOP2", "WKO16D", "WKO16M", "M2019", "WD2018"
};
string[] promoset = new string[10];
string teamname = text.Substring(text.IndexOf("&name=") + 6);
teamname = teamname.Replace("%20", " ");
teamname = teamname.Replace("%26", "&");
teamname = teamname.Replace("%27", "'");
text = text.Substring(text.IndexOf("cards=") + 6);
if (text.Contains("&name="))
{
text = text.Substring(0, text.IndexOf("&name="));
}
else
{
teamname = "Unnamed";
}
text = text.ToLower();
List <string> list = text.Split(';').ToList(); //Creates a list
string holder1;
string holder2;
int number;
if (list.Count < 10)
{
int toappend = 10 - list.Count;
for (int i = 0; i < toappend; i++)
{
list.Add("1xblank1");
}
}
await Context.Channel.SendMessageAsync("Compiling images");
List <string> list2 = new List <string>();
for (int i = 0; i < list.Count; i++) //Turn the list into readable indexes
{
bool contains = false;
list2.Add(list[i].Substring(0, list[i].IndexOf("x")));
list[i] = list[i].Substring(list[i].IndexOf("x") + 1);
holder1 = Regex.Match(list[i], @"\d+").Value;
holder2 = Regex.Replace(list[i], @"^[\d-]*\s*", string.Empty);
for (int k = 0; k < promonames.Length; k++)
{
if (holder2.ToUpper().Contains(promonames[k]))
{
contains = true;
}
}
number = Convert.ToInt32(holder1);
if (number < 10)
{
holder1 = "00" + holder1;
}
else if ((number >= 10) && (number < 100))
{
holder1 = "0" + holder1;
}
//holder2 = new String(list[i].Where(Char.IsLetter).ToArray());
if (holder2 == "imw")
{
holder2 = "Imw";
}
else if (holder2 == "smc")
{
holder2 = "smc";
}
else if (holder2 == "sww")
{
holder2 = "sww";
}
else if (contains == true)
{
promoset[i] = holder2;
holder2 = "PROMO";
}
//else if ((holder2 == "dc") || (holder2 == "m") || (holder2 == "bffop"))
//{
// holder1 = "001";
// holder2 = "blank";
//}
if (contains != true)
{
list[i] = holder2 + holder1;
}
else
{
list[i] = holder2 + "#" + holder1;
}
}
string sheet;
string card;
using (WebClient wc = new WebClient())
{
for (int j = 0; j < list.Count; j++)
{
sheet = new String(list[j].Where(Char.IsLetter).ToArray());
if (list[j].Contains("PROMO"))
{
list[j] = list[j].Replace("PROMO", promoset[j]);
}
card = list[j].ToUpper();
string sheetref = sheet + "!";
GoogleTest.Main(sheetref);
var test = GoogleTest._values;
foreach (var row in test)
{
//Check for named cell
if ((string)row[0] == card)
{
//Assign the cells to varibales
url = (string)row[9];
}
}
using (Stream s = wc.OpenRead(url))
{
using (Bitmap bmp = new Bitmap(s))
{
bmp.Save("images/test" + j + ".jpg");
bmp.Dispose();
}
}
}
}
await Context.Channel.SendMessageAsync("Scaling images");
for (int k = 0; k < 10; k++)
{
Resize_Picture("images/test" + k + ".jpg", "images/testmod" + k + ".jpg", 0, 800, 10);
}
System.Drawing.Image source1 = System.Drawing.Image.FromFile("images/testmod0.jpg");
System.Drawing.Image source2 = System.Drawing.Image.FromFile("images/testmod1.jpg");
System.Drawing.Image source3 = System.Drawing.Image.FromFile("images/testmod2.jpg");
System.Drawing.Image source4 = System.Drawing.Image.FromFile("images/testmod3.jpg");
System.Drawing.Image source5 = System.Drawing.Image.FromFile("images/testmod4.jpg");
System.Drawing.Image source6 = System.Drawing.Image.FromFile("images/testmod5.jpg");
System.Drawing.Image source7 = System.Drawing.Image.FromFile("images/testmod6.jpg");
System.Drawing.Image source8 = System.Drawing.Image.FromFile("images/testmod7.jpg");
System.Drawing.Image source9 = System.Drawing.Image.FromFile("images/testmod8.jpg");
System.Drawing.Image source10 = System.Drawing.Image.FromFile("images/testmod9.jpg");
int toplevel = source1.Width + source2.Width + source3.Width + source4.Width;
int bottomlevel = source4.Width + source5.Width + source6.Width + source7.Width;
int picked = 0;
if (toplevel > bottomlevel)
{
picked = toplevel;
}
else if (toplevel < bottomlevel)
{
picked = bottomlevel;
}
else if (toplevel == bottomlevel)
{
picked = bottomlevel;
}
Bitmap bitmap = new Bitmap(picked,
source1.Height + source2.Height + source3.Height);
await Context.Channel.SendMessageAsync("Combining images");
using (Graphics g = Graphics.FromImage(bitmap))
{
g.DrawImage(source1, 0, 0);
g.DrawImage(source2, source1.Width, 0);
g.DrawImage(source3, source1.Width + source2.Width, 0);;
g.DrawImage(source4, source1.Width + source2.Width + source3.Width, 0);
g.DrawImage(source5, 0, source1.Height);
g.DrawImage(source6, source1.Width, source2.Height);
g.DrawImage(source7, source1.Width + source2.Width, source3.Height);
g.DrawImage(source8, source1.Width + source2.Width + source3.Width, source4.Height);
g.DrawImage(source9, source1.Width, source2.Height + source6.Height);
g.DrawImage(source10, source1.Width + source2.Width, source3.Height + source7.Height);
bitmap.Save("images/combine2.jpg");
}
FileInfo fi = new FileInfo("images/combine2.jpg");
var size = fi.Length;
if (fi.Length > 8388608)
{
await Context.Channel.SendMessageAsync("Image too large. Compressing.");
//using (MagickImage image = new MagickImage("images/combine2.jpg"))
//{
// image.Scale(new Percentage(100));
// image.Write("images/combine2.jpg");
//}
}
await Context.Channel.SendMessageAsync("**" + teamname + "**");
await Context.Channel.SendFileAsync("images/combine2.jpg");
}
