// GET: Users/Delete/5
public ActionResult Delete(int id)
{
using (TeamEVotingDBEntities teamEVotingDBEntities = new TeamEVotingDBEntities())
{
return(View(teamEVotingDBEntities.UserSet.Where(x => x.User_Id == id).FirstOrDefault()));
}
}
public void CreateFactionTest()
{
driver.Url = "https://teamevotingwebsite.azurewebsites.net/";
driver.FindElement(By.XPath("//a[@href='/Factions/Index']")).Click();
driver.FindElement(By.XPath("//a[@href='/Factions/Create']")).Click();
IWebElement firstName = driver.FindElement(By.Id("Faction_Name"));
firstName.SendKeys("TestFaction");
driver.FindElement(By.CssSelector(".btn.btn-default")).Click(); // create a new faction
using (TeamEVotingDBEntities teamEVotingDBEntities = new TeamEVotingDBEntities()) // check if creation was successful
{
List <FactionSet> factions = teamEVotingDBEntities.FactionSet.ToList();
FactionSet fs = factions.Last();
StringAssert.Contains("TestFaction", fs.Faction_Name);
}
IList <IWebElement> deleteButtons = driver.FindElements(By.CssSelector("[href^='/Factions/Delete/']"));
deleteButtons.Last().Click();
driver.FindElement(By.CssSelector(".btn.btn-default")).Click(); // delete the created faction
using (TeamEVotingDBEntities teamEVotingDBEntities = new TeamEVotingDBEntities()) // check if deletion was successful
{
List <FactionSet> factions = teamEVotingDBEntities.FactionSet.ToList();
FactionSet fs = factions.Last();
StringAssert.DoesNotContain("TestFaction", fs.Faction_Name);
}
}
// GET: Factions
public ActionResult Index()
{
using (TeamEVotingDBEntities teamEVotingDBEntities = new TeamEVotingDBEntities())
{
factionsList = teamEVotingDBEntities.FactionSet.ToList();
}
return(View(factionsList));
}
// GET: Users
public ActionResult Index()
{
using (TeamEVotingDBEntities teamEVotingDBEntities = new TeamEVotingDBEntities())
{
usersList = teamEVotingDBEntities.UserSet.ToList();
}
return(View(usersList));
}
// GET: RawSql
public ActionResult Index()
{
using (TeamEVotingDBEntities teamEVotingDBEntities = new TeamEVotingDBEntities())
{
//regionsList = teamEVotingDBEntities.RegionSet.ToList();
regionsList = teamEVotingDBEntities.RegionSet.SqlQuery("select * from RegionSet").ToList();
}
return(View(regionsList));
}
public void CreateCandidateTest()
{
driver.Url = "https://teamevotingwebsite.azurewebsites.net/";
driver.FindElement(By.XPath("//a[@href='/Candidates/Index']")).Click();
driver.FindElement(By.XPath("//a[@href='/Candidates/Create']")).Click();
IWebElement firstName = driver.FindElement(By.Id("Candidate_FirstName"));
firstName.SendKeys("TestFirstName");
IWebElement lastName = driver.FindElement(By.Id("Candidate_LastName"));
lastName.SendKeys("TestLastName");
IWebElement age = driver.FindElement(By.Id("Candidate_Age"));
age.Clear();
age.SendKeys("30");
SelectElement region = new SelectElement(driver.FindElement(By.Id("Region_Id")));
region.SelectByIndex(1);
SelectElement faction = new SelectElement(driver.FindElement(By.Id("Faction_Id")));
faction.SelectByIndex(1);
driver.FindElement(By.CssSelector(".btn.btn-default")).Click(); // create a new candidate
using (TeamEVotingDBEntities teamEVotingDBEntities = new TeamEVotingDBEntities()) // check if creation was successful
{
List <CandidateSet> candidates = teamEVotingDBEntities.CandidateSet.ToList();
CandidateSet cs = candidates.Last();
StringAssert.Contains("TestFirstName", cs.Candidate_FirstName);
StringAssert.Contains("TestLastName", cs.Candidate_LastName);
Assert.AreEqual(30, cs.Candidate_Age);
}
IList <IWebElement> deleteButtons = driver.FindElements(By.CssSelector("[href^='/Candidates/Delete/']"));
deleteButtons.Last().Click();
driver.FindElement(By.CssSelector(".btn.btn-default")).Click(); // delete the created candidate
using (TeamEVotingDBEntities teamEVotingDBEntities = new TeamEVotingDBEntities()) // check if deletion was successful
{
List <CandidateSet> candidates = teamEVotingDBEntities.CandidateSet.ToList();
CandidateSet cs = candidates.Last();
StringAssert.DoesNotContain("TestFirstName", cs.Candidate_FirstName);
StringAssert.DoesNotContain("TestLastName", cs.Candidate_LastName);
Assert.AreNotEqual(30, cs.Candidate_Age);
}
}
public ActionResult Delete(int id, FormCollection collection)
{
using (TeamEVotingDBEntities teamEVotingDBEntities = new TeamEVotingDBEntities())
{
RegionSet regionSet = teamEVotingDBEntities.RegionSet.Where(x => x.Region_Id == id).FirstOrDefault();
teamEVotingDBEntities.RegionSet.Remove(regionSet);
teamEVotingDBEntities.SaveChanges();
}
return(RedirectToAction("Index"));
}
// GET: Candidates/Create
public ActionResult Create()
{
CandidateSet candidates = new CandidateSet();
using (TeamEVotingDBEntities teamEVotingDB = new TeamEVotingDBEntities())
{
candidates.regions = teamEVotingDB.RegionSet.ToList();
candidates.factions = teamEVotingDB.FactionSet.ToList();
}
return(View(candidates));
}
public ActionResult GroupCandidates()
{
CandidateSet candidate = new CandidateSet();
using (TeamEVotingDBEntities teamEVotingDBEntities = new TeamEVotingDBEntities())
{
//kasutab Count, Sum, Min, Max, Average käske, LINQ = SQL
var candidatesCount = teamEVotingDBEntities.CandidateSet.Count();
var factionsCount = teamEVotingDBEntities.FactionSet.Count();
var regionsCount = teamEVotingDBEntities.RegionSet.Count();
var sumCandidates = teamEVotingDBEntities.CandidateSet.Sum(x => x.Candidate_Age);
var youngestCandidate = teamEVotingDBEntities.CandidateSet.Min(x => x.Candidate_Age);
var oldestCandidate = teamEVotingDBEntities.CandidateSet.Max(x => x.Candidate_Age);
var averageCandidateAge = teamEVotingDBEntities.CandidateSet.Average(x => x.Candidate_Age);
ViewBag.candidatesCount = candidatesCount;
ViewBag.factionsCount = factionsCount;
ViewBag.regionsCount = regionsCount;
ViewBag.sumCandidates = sumCandidates;
ViewBag.youngestCandidate = youngestCandidate;
ViewBag.oldestCandidate = oldestCandidate;
ViewBag.averageCandidateAge = averageCandidateAge;
var popularBrowser = teamEVotingDBEntities.VisitorInfo.GroupBy(x => x.VisitorBrowser).OrderByDescending(gp => gp.Count()).Take(1).Select(g => g.Key).ToList();
foreach (var item in popularBrowser)
{
ViewBag.popularBrowser = item;
}
var popularVisitingTime = teamEVotingDBEntities.VisitorInfo.GroupBy(t => t.Visited_DateTime).OrderByDescending(gp => gp.Count()).Take(1).Select(g => g.Key).ToList();
foreach (var item in popularVisitingTime)
{
var dateTime = item.Value;
var hour = dateTime.Hour;
var minute = dateTime.Minute;
if (minute < 10)
{
ViewBag.popularTime = hour + ":0" + minute;
}
else
{
ViewBag.popularTime = hour + ":" + minute;
}
}
}
return(View());
}
public ActionResult Create(FactionSet factionSet)
{
using (TeamEVotingDBEntities teamEVotingDB = new TeamEVotingDBEntities())
{
if (ModelState.IsValid)
{
teamEVotingDB.FactionSet.Add(factionSet);
teamEVotingDB.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
public ActionResult Create(RegionSet region)
{
using (TeamEVotingDBEntities teamEVotingDBEntities = new TeamEVotingDBEntities())
{
if (ModelState.IsValid)
{
teamEVotingDBEntities.RegionSet.Add(region);
teamEVotingDBEntities.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
public ActionResult Create(CandidateSet candidates)
{
using (TeamEVotingDBEntities teamEVotingDB = new TeamEVotingDBEntities())
{
//Faction member + 1, sest üks member on juures nüüd
var selectedFaction = candidates.Faction_Id;
var addMember = teamEVotingDB.FactionSet.Single(addMembers => addMembers.Faction_Id == selectedFaction);
addMember.NumberOfMembers++;
teamEVotingDB.CandidateSet.Add(candidates);
candidates.NumberOfVotes = 0;
teamEVotingDB.SaveChanges();
}
return(RedirectToAction("Index"));
}
// GET: Users/Create
public ActionResult Create()
{
UserSet user = new UserSet();
CandidateSet candidateSet = new CandidateSet();
using (TeamEVotingDBEntities teamEVotingDB = new TeamEVotingDBEntities())
{
//kandidaatide lisamine listi, pärast näitab neid dropdownlistis
user.candidates = teamEVotingDB.CandidateSet.ToList();
//var fullName = candidateSet.Candidate_FirstName + candidateSet.Candidate_LastName;
//user.candidates =
}
return(View(user));
}
public ActionResult WelcomePage()
{
ViewBag.Message = "Our team welcome page.";
var viewPath = this.ControllerContext.RouteData.Values["action"].ToString();
ViewBag.viewPath = viewPath;
HttpRequest req = System.Web.HttpContext.Current.Request;
string browserName = req.Browser.Browser;
ViewBag.browser = browserName;
//string userIpAddress = HttpContext.Request.UserHostAddress;
//ViewBag.ip = userIpAddress;
string ipAddress = string.Empty;
if (HttpContext.Request.ServerVariables["HTTP_X__FORWARDER_FOR"] != null)
{
ipAddress = HttpContext.Request.ServerVariables["HTTP_X__FORWARDER_FOR"].ToString();
}
else if (HttpContext.Request.UserHostAddress.Length != 0)
{
ipAddress = HttpContext.Request.UserHostAddress;
}
ViewBag.ip = ipAddress;
using (TeamEVotingDBEntities teamEVotingDBEntities = new TeamEVotingDBEntities())
{
VisitorInfo visitorInfo = new VisitorInfo();
List <object> list = new List <object>();
list.Add(visitorInfo.Visited_DateTime = DateTime.Now);
list.Add(visitorInfo.VisitorIP = ipAddress);
list.Add(visitorInfo.VisitorBrowser = browserName);
list.Add(visitorInfo.VisitorLandingPage = viewPath);
list.Add(visitorInfo.User_Id = null);
if (visitorInfo.VisitorIP != "::1")
{
object[] allitems = list.ToArray();
teamEVotingDBEntities.Database.ExecuteSqlCommand("INSERT INTO VisitorInfo(Visited_DateTime, VisitorIP, VisitorBrowser, VisitorLandingPage, User_Id) values (@p0,@p1,@p2,@p3,@p4)", allitems);
}
else
{
}
}
return(View());
}
public ActionResult CreateWithSql(RegionSet region)
{
try
{
using (TeamEVotingDBEntities teamEVotingDBEntities = new TeamEVotingDBEntities())
{
//teamEVotingDBEntities.Database.ExecuteSqlCommand("INSERT into RegionSet (Region_Name) VALUES (@Region_Name)");
//teamEVotingDBEntities.SaveChanges();
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Delete(int id, FormCollection collection)
{
try
{
using (TeamEVotingDBEntities teamEVotingDBEntities = new TeamEVotingDBEntities())
{
UserSet userSet = teamEVotingDBEntities.UserSet.Where(x => x.User_Id == id).FirstOrDefault();
teamEVotingDBEntities.UserSet.Remove(userSet);
teamEVotingDBEntities.SaveChanges();
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Create(RegionSet region)
{
try
{
using (TeamEVotingDBEntities teamEVotingDBEntities = new TeamEVotingDBEntities())
{
List <object> list = new List <object>();
list.Add(region.Region_Name);
object[] allitems = list.ToArray();
int output = teamEVotingDBEntities.Database.ExecuteSqlCommand("INSERT into RegionSet(Region_Name) values (@p0)", allitems);
}
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
return(View(ex));
}
}
//Show region on map
public ActionResult ShowRegionOnMap(int id)
{
//string location = "Tartumaa";
//käib läbi regionite ja siis valib valitud regioni, annab edasi ViewBagina Google mapsi ja siis kuvab seda mapsis.
using (TeamEVotingDBEntities teamEVotingDBEntities = new TeamEVotingDBEntities())
{
regionSets = teamEVotingDBEntities.RegionSet.ToList();
foreach (RegionSet region in regionSets)
{
if (region.Region_Id == id)
{
string location = region.Region_Name;
ViewBag.location = location;
}
}
return(View());
}
}
public ActionResult SeeVotedCandidates()
{
using (TeamEVotingDBEntities teamEVotingDBEntities = new TeamEVotingDBEntities())
{
var result = (from u in teamEVotingDBEntities.UserSet
join c in teamEVotingDBEntities.CandidateSet on u.Candidate_Id equals c.Candidate_Id
select new UserVotedCandidatesVM
{
User_Id = u.User_Id,
User_FirstName = u.User_FirstName,
User_LastName = u.User_LastName,
Candidate_Id = c.Candidate_Id,
Candidate_FirstName = c.Candidate_FirstName,
Candidate_LastName = c.Candidate_LastName,
Candidate_Age = c.Candidate_Age
}).ToList();
return(View(result));
}
}
public ActionResult Create(UserSet user)
{
try
{
// TODO: Add insert logic here
using (TeamEVotingDBEntities teamEVotingDBEntities = new TeamEVotingDBEntities())
{
var selectedCandidate = user.Candidate_Id;
var addVotes = teamEVotingDBEntities.CandidateSet.Single(addVote => addVote.Candidate_Id == selectedCandidate);
addVotes.NumberOfVotes++;
teamEVotingDBEntities.UserSet.Add(user);
teamEVotingDBEntities.SaveChanges();
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
// GET: Candidates
public ActionResult Index()
{
using (TeamEVotingDBEntities teamEVotingDBEntities = new TeamEVotingDBEntities())
{
var result = (from c in teamEVotingDBEntities.CandidateSet
join r in teamEVotingDBEntities.RegionSet on c.Region_Id equals r.Region_Id
join f in teamEVotingDBEntities.FactionSet on c.Faction_Id equals f.Faction_Id
select new CreateCandidateVM
{
Faction_Id = f.Faction_Id,
Region_Id = r.Region_Id,
Candidate_Id = c.Candidate_Id,
Candidate_Age = c.Candidate_Age,
Candidate_FirstName = c.Candidate_FirstName,
Candidate_LastName = c.Candidate_LastName,
Faction_Name = f.Faction_Name,
NumberOfVotes = c.NumberOfVotes,
Region_Name = r.Region_Name
}).ToList();
return(View(result));
}
}
public void CreateUserTest()
{
int startVotes = 0;
int endVotes = 0;
using (TeamEVotingDBEntities teamEVotingDBEntities = new TeamEVotingDBEntities()) // find the amount of votes before voting
{
CandidateSet cs = teamEVotingDBEntities.CandidateSet.Where(x => x.Candidate_Id == 7).FirstOrDefault();
startVotes = (int)cs.NumberOfVotes;
}
driver.Url = "https://teamevotingwebsite.azurewebsites.net/";
driver.FindElement(By.XPath("//a[@href='/Users/Create']")).Click();
IWebElement firstName = driver.FindElement(By.Id("User_FirstName"));
firstName.SendKeys("TestFirstName");
IWebElement lastName = driver.FindElement(By.Id("User_LastName"));
lastName.SendKeys("TestLastName");
SelectElement candidate = new SelectElement(driver.FindElement(By.Id("Candidate_Id")));
candidate.SelectByText("test test");
driver.FindElement(By.CssSelector(".btn.btn-default")).Click(); // vote for test candidate
using (TeamEVotingDBEntities teamEVotingDBEntities = new TeamEVotingDBEntities()) // find the amount of votes after voting
{
CandidateSet cs = teamEVotingDBEntities.CandidateSet.Where(x => x.Candidate_Id == 7).FirstOrDefault();
endVotes = (int)cs.NumberOfVotes;
}
Assert.Greater(endVotes, startVotes); // check if voting was successful
}
