public static string Run(ModelType modelType, OperationType operationType, params object[] args) { //Reloads the context, to not get errors from entity tracking context = new GolfContext(); if (operationType == OperationType.FindTotal) { return(FindTotal(int.Parse(args[0].ToString()))); } else if (operationType == OperationType.FindAverage) { return(FindAverage()); } if (modelType == ModelType.Course) { return(ManageCourses(operationType, args)); } if (modelType == ModelType.Hole) { return(ManageHoles(operationType, args)); } if (modelType == ModelType.Player) { return(ManagePlayers(operationType, args)); } return(""); }
//If want add an Admin automatically can use this. private void createRolesandUsers() { GolfContext context = new GolfContext(); var roleManager = new RoleManager <IdentityRole>(new RoleStore <IdentityRole>(context)); var UserManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(context)); //In Startup I am creating first Admin Role and creating a default Admin User if (!roleManager.RoleExists("admin")) { //first we create Admin rool var role = new Microsoft.AspNet.Identity.EntityFramework.IdentityRole(); role.Name = "admin"; roleManager.Create(role); //Here we create a Admin super user who will maintain the website var user = new ApplicationUser(); user.UserName = "******"; // Username has to match email user.Email = "*****@*****.**"; string userPWD = "TestTallaght55!"; var chkUser = UserManager.Create(user, userPWD); //Add default User to Role Admin if (chkUser.Succeeded) { var result1 = UserManager.AddToRole(user.Id, "admin"); } } }
static DBManager() { context = new GolfContext(); courseRepository = new CourseRepository(context); holeRepository = new HoleRepository(context); playerRepository = new PlayerRepository(context); finder = new DBFinder(context); }
public static int CalculateThru(long teamId) { var db = new GolfContext(); var scores = db.Scores.Where(s => s.TeamID == teamId).ToList(); if (!scores.Any()) return 0; var lastScore = scores.OrderByDescending(x => x.Hole.HoleNumber).FirstOrDefault(); return lastScore?.Hole.HoleNumber ?? 0; }
public void GetMembersByIdTest() { using (IDataContextAsync context = new GolfContext()) using (IUnitOfWorkAsync unitOfWork = new UnitOfWork(context)) { IRepositoryAsync <Member> memberRepository = new Repository <Member>(context, unitOfWork); var member = memberRepository.GetMemberById(122); TestContext.WriteLine("Members found: {0}", member.Lastname); Assert.AreEqual("Dustin Johnson", string.Format("{0} {1}", member.Firstname, member.Lastname)); } }
public void GetMemberByNameTest() { using (IDataContextAsync context = new GolfContext()) using (IUnitOfWorkAsync unitOfWork = new UnitOfWork(context)) { IRepositoryAsync <Member> memberRepository = new Repository <Member>(context, unitOfWork); var member = memberRepository.GetMemberByName("Woods", "Tiger"); Assert.AreEqual(1, member.MemberId); } }
public void RepositoryGetMemberByNameTest() { using (IDataContextAsync context = new GolfContext()) using (IUnitOfWorkAsync unitOfWork = new UnitOfWork(context)) { IRepositoryAsync <Member> memberRepository = new Repository <Member>(context, unitOfWork); IMemberService memberService = new MemberService(memberRepository); var memberByName = memberService.GetMemberByName("Aledort", "Andy"); Assert.AreEqual(1, memberByName.MemberId); } }
public void FindMemberByIdTest() { using (IDataContextAsync context = new GolfContext()) using (IUnitOfWorkAsync unitOfWork = new UnitOfWork(context)) { IRepositoryAsync <Member> memberRepository = new Repository <Member>(context, unitOfWork); IService <Member> memberService = new MemberService(memberRepository); var member = memberService.Find(5); TestContext.WriteLine("Member found: {0}", member.Lastname); Assert.AreEqual("Dave Kilminster", string.Format("{0} {1}", member.Firstname, member.Lastname)); } }
public void RepositoryGetMemberByIdTest() { using (IDataContextAsync context = new GolfContext()) using (IUnitOfWorkAsync unitOfWork = new UnitOfWork(context)) { IRepositoryAsync <Member> memberRepository = new Repository <Member>(context, unitOfWork); IMemberService memberService = new MemberService(memberRepository); var memberById = memberService.GetMemberById(4); Assert.AreEqual("James Humphries", string.Format("{0} {1}", memberById.Firstname, memberById.Lastname)); } }
public void RepositoryGetAllMembersTest() { using (IDataContextAsync context = new GolfContext()) using (IUnitOfWorkAsync unitOfWork = new UnitOfWork(context)) { IRepositoryAsync <Member> memberRepository = new Repository <Member>(context, unitOfWork); IMemberService memberService = new MemberService(memberRepository); var members = memberService.GetAllMembers(); TestContext.WriteLine("Members found: {0}", members.Count()); Assert.AreEqual(59, members.Count()); } }
public void GetAllMembersTest() { using (IDataContextAsync context = new GolfContext()) using (IUnitOfWorkAsync unitOfWork = new UnitOfWork(context)) { IRepositoryAsync <Member> memberRepository = new Repository <Member>(context, unitOfWork); var members = memberRepository.GetAllMembers(); var enumerable = members as IList <Member> ?? members.ToList(); TestContext.WriteLine("Members found: {0}", enumerable.Count()); Assert.AreEqual(59, enumerable.Count()); } }
public ActionResult Index(HttpPostedFileBase CSVName) { string path = null; var ProductsToDisplay = new List <Product>(); try { if (CSVName.ContentLength > 0) { var fileName = Path.GetFileName(CSVName.FileName); path = AppDomain.CurrentDomain.BaseDirectory + "upload\\" + fileName; CSVName.SaveAs(path); var csv = new CsvReader(new StreamReader(path)); var db = new GolfContext(); int count = 0; while (csv.Read()) { Product product = new Product(); product.Name = csv.GetField <string>(0); product.ProductID = int.Parse(csv.GetField <string>(1)); product.Price = decimal.Parse(csv.GetField <string>(2)); product.Quantity = int.Parse(csv.GetField <string>(3)); product.SubDepartment = csv.GetField <string>(7); product.ItemCategory = csv.GetField <string>(8); ProductsToDisplay.Add(product); var exists = db.Products.Where(i => i.ProductID == product.ProductID).SingleOrDefault(); if (exists == null) { db.Products.Add(product); db.SaveChanges(); count += 1; } } ViewBag.RecordsUploaded = ProductsToDisplay.Count(); ViewBag.RecordsSaved = count; } } catch (Exception ex) { ModelState.AddModelError("", ex.Message); } return(View(ProductsToDisplay)); }
public static int CalculateScore(long teamId) { var score = 0; var par = 0; var db = new GolfContext(); var currentScores = db.Scores.Where(s => s.TeamID.Equals(teamId)).ToList(); // tally up both the total score for the team, and also the pars for the holes they've completed for (var i = 0; i < currentScores.Count(); i++) { score += currentScores[i].Strokes; var holeId = currentScores[i].HoleID; var thisHole = db.Holes.FirstOrDefault(h => h.HoleID == holeId); if (thisHole != null) { par += thisHole.Par; } } return score - par; }
public DBFinder(GolfContext context) { this.context = context; }
public HomeController() { Context = new GolfContext(); UserManager = new UserManager<ApplicationUser>(new UserStore<ApplicationUser>(Context)); }
public AccountController() { Context = new GolfContext(); }
public ScoreboardController() { Context = new GolfContext(); }
public ReservationService(GolfContext context) { _context = context; }
public RegisterViewModel() { var db = new GolfContext(); TeamList = db.Teams.ToList(); }
public CourseRepository(GolfContext context) { this.context = context; courses = context.Courses; }
public ScoresController(GolfContext context) { _context = context; }
public HoleRepository(GolfContext context) { this.context = context; holes = context.Holes; }
public PlayerRepository(GolfContext context) { this.context = context; players = context.Players; }