public List <MenuItem> VulDrankenKaart(Catagorie c, Dagdeel d) { md = new MenuitemDAO(); List <MenuItem> menuKaart = md.GetMenuItems(c, d); return(menuKaart); }
private void VulMenuKaart(Catagorie c) { lv_MenuKaart.Items.Clear(); //lv_MenuKaart.Columns.Clear(); MenuKaart m = new MenuKaart(); List <Model.MenuItem> menuKaart = new List <Model.MenuItem>(); menuKaart = m.VulMenuKaart(c); foreach (Model.MenuItem menuItem in menuKaart) { ListViewItem item = new ListViewItem(menuItem.Naam); item.SubItems.Add(menuItem.Prijs.ToString("0.00")); item.SubItems.Add(menuItem.Omschrijving); lv_MenuKaart.Items.Add(item); } VulTagMenuKaart(menuKaart); }
public List <MenuItem> VulMenuKaart(Catagorie c) { Dagdeel d = new Dagdeel(); if (c == Catagorie.dranken) { d = Dagdeel.altijd; } md = new MenuitemDAO(); if (d != Dagdeel.altijd) { if (DateTime.Now.Hour <= 16) { d = Dagdeel.lunch; } else { d = Dagdeel.diner; } } List <MenuItem> menuKaart = md.GetMenuItems(c, d); return(menuKaart); }
public async Task <ActionResult> DeleteConfirmed(int id) { Catagorie catagorie = await db.Catagories.FindAsync(id); db.Catagories.Remove(catagorie); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
private void btn_Drank_Click(object sender, EventArgs e) { Catagorie c = new Catagorie(); c = Catagorie.dranken; Dagdeel d = new Dagdeel(); VulMenuKaart(c, d); }
private void btn_Nagerecht_Click(object sender, EventArgs e) { Catagorie c = new Catagorie(); c = Catagorie.nagerecht; Dagdeel d = new Dagdeel(); VulMenuKaart(c, d); }
public async Task <ActionResult> Edit([Bind(Include = "ID,Name")] Catagorie catagorie) { if (ModelState.IsValid) { db.Entry(catagorie).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(catagorie)); }
public MenuItem(int id, string naam, Catagorie catagorie, Dagdeel dagdeel, bool isAlcoholisch, double prijs, int voorraad, string omschrijving) { this.id = id; this.naam = naam; this.catagorie = catagorie; this.dagdeel = dagdeel; this.isAlcoholisch = isAlcoholisch; this.prijs = prijs; this.voorraad = voorraad; this.omschrijving = omschrijving; }
public async Task <ActionResult> Create([Bind(Include = "ID,Name")] Catagorie catagorie) { if (ModelState.IsValid) { db.Catagories.Add(catagorie); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(catagorie)); }
public async Task <ActionResult> Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Catagorie catagorie = await db.Catagories.FindAsync(id); if (catagorie == null) { return(HttpNotFound()); } return(View(catagorie)); }
public List <MenuItem> VulMenuKaart(Catagorie c, Dagdeel d) { md = new MenuitemDAO(); if (DateTime.Now.Hour <= 16) { d = Dagdeel.lunch; } else { d = Dagdeel.diner; } List <MenuItem> menuKaart = md.GetMenuItems(c, d); return(menuKaart); }
public List <MenuItem> GetMenuItems(Catagorie c, Dagdeel d) { string queryString = "SELECT * FROM dbo.MenuItem WHERE Categorie = @catagorie AND Dagdeel = @dagdeel"; using (dbConnection) { SqlCommand command = new SqlCommand(queryString, dbConnection); dbConnection.Open(); SqlParameter CatagorieParam = new SqlParameter("@catagorie", System.Data.SqlDbType.NVarChar); SqlParameter DagdeelParam = new SqlParameter("@dagdeel", System.Data.SqlDbType.NVarChar); CatagorieParam.Value = c.ToString(); DagdeelParam.Value = d.ToString(); command.Parameters.Add(CatagorieParam); command.Parameters.Add(DagdeelParam); // command.Prepare(); SqlDataReader reader = command.ExecuteReader(); List <MenuItem> menuKaart = new List <MenuItem>(); while (reader.Read()) { MenuItem m = ReadMenuItem(reader); menuKaart.Add(m); } reader.Close(); dbConnection.Close(); return(menuKaart); } }
public MenuItem ReadMenuItem(SqlDataReader reader) { int id = (int)reader["MenuItem_id"]; string naam = (string)reader["Naam"]; bool alcohol = (bool)reader["Is_alcoholisch"]; double prijs = (double)reader["Prijs"]; Catagorie catagorie = (Catagorie)Enum.Parse(typeof(Catagorie), (string)reader["Categorie"]); Dagdeel dagdeel = (Dagdeel)Enum.Parse(typeof(Dagdeel), (string)reader["Dagdeel"]); int voorraad = (int)reader["Voorraad"]; string omschrijving = ""; if (reader["Omschrijving"] != DBNull.Value) { omschrijving = (string)reader["Omschrijving"]; } MenuItem m = new MenuItem(id, naam, catagorie, dagdeel, alcohol, prijs, voorraad, omschrijving); return(m); }
private void btn_Drank_Click(object sender, EventArgs e) { c = Catagorie.dranken; VulMenuKaart(c); }
private void btn_Nagerecht_Click(object sender, EventArgs e) { c = Catagorie.nagerecht; VulMenuKaart(c); }
public bool Seed(ApplicationDbContext context) { bool success = false; ApplicationRoleManager _roleManager = new ApplicationRoleManager(new RoleStore <ApplicationRole>(context)); success = this.CreateRole(_roleManager, RolesConst.ADMIN, "Global Access"); if (!success == true) { return(success); } success = this.CreateRole(_roleManager, RolesConst.CUSTOMER, "Customer"); if (!success == true) { return(success); } success = this.CreateRole(_roleManager, RolesConst.ACCOUNTANT, "Pidrahyu"); if (!success == true) { return(success); } success = this.CreateRole(_roleManager, RolesConst.PROGRAMER, "Make work"); if (!success == true) { return(success); } success = this.CreateRole(_roleManager, RolesConst.HR, "Human Resourse Management"); if (!success == true) { return(success); } success = this.CreateRole(_roleManager, RolesConst.OPERATOR, "Proceed Orders"); if (!success == true) { return(success); } success = this.CreateRole(_roleManager, RolesConst.RESOURSE_MANAGER, "Manage Resourses"); if (!success == true) { return(success); } success = this.CreateRole(_roleManager, RolesConst.Sales_MANAGER, "Sales Manager"); if (!success == true) { return(success); } success = this.CreateRole(_roleManager, RolesConst.MANAGER, "Manager"); if (!success == true) { return(success); } success = this.CreateRole(_roleManager, RolesConst.ORDER_OPERATOR, "Order Manaher"); if (!success == true) { return(success); } // Create my debug (testing) objects here ApplicationUserManager userManager = new ApplicationUserManager(new UserStore <ApplicationUser>(context)); ApplicationUser user = new ApplicationUser(); PasswordHasher passwordHasher = new PasswordHasher(); user.UserName = "******"; user.Email = "*****@*****.**"; user.RoleName = RolesConst.ADMIN; user.FistName = RolesConst.ADMIN; user.LastName = RolesConst.ADMIN; IdentityResult result = userManager.Create(user, "Pas@123"); success = this.AddUserToRole(userManager, user.Id, RolesConst.ADMIN); if (!success) { return(success); } ApplicationUser user2 = new Customer(); PasswordHasher passwordHasher2 = new PasswordHasher(); user2.UserName = "******"; user2.RoleName = RolesConst.CUSTOMER; user2.Email = "*****@*****.**"; user2.FistName = RolesConst.CUSTOMER; user2.LastName = RolesConst.CUSTOMER; IdentityResult result2 = userManager.Create(user2, "Pas@123"); success = this.AddUserToRole(userManager, user2.Id, RolesConst.CUSTOMER); if (!success) { return(success); } ApplicationUser user3 = new ApplicationUser(); PasswordHasher passwordHasher3 = new PasswordHasher(); user3.UserName = "******"; user3.Email = "*****@*****.**"; user3.RoleName = RolesConst.ACCOUNTANT; user3.FistName = RolesConst.ACCOUNTANT; user3.LastName = RolesConst.ACCOUNTANT; IdentityResult result3 = userManager.Create(user3, "Pas@123"); success = this.AddUserToRole(userManager, user3.Id, RolesConst.ACCOUNTANT); if (!success) { return(success); } ApplicationUser user4 = new ApplicationUser(); PasswordHasher passwordHasher4 = new PasswordHasher(); user4.UserName = "******"; user4.Email = "*****@*****.**"; user4.RoleName = RolesConst.PROGRAMER; user4.FistName = RolesConst.PROGRAMER; user4.LastName = RolesConst.PROGRAMER; IdentityResult result4 = userManager.Create(user4, "Pas@123"); success = this.AddUserToRole(userManager, user4.Id, RolesConst.PROGRAMER); if (!success) { return(success); } ApplicationUser user5 = new ApplicationUser(); PasswordHasher passwordHasher5 = new PasswordHasher(); user5.UserName = "******"; user5.Email = "*****@*****.**"; user5.RoleName = RolesConst.OPERATOR; user5.FistName = RolesConst.OPERATOR; user5.LastName = RolesConst.OPERATOR; IdentityResult result5 = userManager.Create(user5, "Pas@123"); success = this.AddUserToRole(userManager, user5.Id, RolesConst.OPERATOR); if (!success) { return(success); } ApplicationUser user6 = new ApplicationUser(); PasswordHasher passwordHasher6 = new PasswordHasher(); user6.UserName = "******"; user6.Email = "*****@*****.**"; user6.RoleName = RolesConst.Sales_MANAGER; user6.FistName = RolesConst.Sales_MANAGER; user6.LastName = RolesConst.Sales_MANAGER; IdentityResult result6 = userManager.Create(user6, "Pas@123"); success = this.AddUserToRole(userManager, user6.Id, RolesConst.Sales_MANAGER); if (!success) { return(success); } ApplicationUser user7 = new ApplicationUser(); PasswordHasher passwordHasher7 = new PasswordHasher(); user7.UserName = "******"; user7.Email = "*****@*****.**"; user7.RoleName = RolesConst.Sales_MANAGER; user7.FistName = RolesConst.Sales_MANAGER; user7.LastName = RolesConst.Sales_MANAGER; IdentityResult result7 = userManager.Create(user7, "Pas@123"); success = this.AddUserToRole(userManager, user7.Id, RolesConst.Sales_MANAGER); if (!success) { return(success); } ApplicationUser user8 = new ApplicationUser(); PasswordHasher passwordHasher8 = new PasswordHasher(); user8.UserName = "******"; user8.Email = "*****@*****.**"; user8.RoleName = RolesConst.CUSTOMER; user8.FistName = RolesConst.CUSTOMER; user8.LastName = RolesConst.CUSTOMER; IdentityResult result8 = userManager.Create(user8, "Pas@123"); success = this.AddUserToRole(userManager, user8.Id, RolesConst.CUSTOMER); if (!success) { return(success); } Customer user9 = new Customer(); PasswordHasher passwordHasher9 = new PasswordHasher(); user9.UserName = "******"; user9.Email = "*****@*****.**"; user9.RoleName = RolesConst.CUSTOMER; user9.FistName = RolesConst.CUSTOMER; user9.LastName = RolesConst.CUSTOMER; IdentityResult result9 = userManager.Create(user9, "Pas@123"); success = this.AddUserToRole(userManager, user9.Id, RolesConst.CUSTOMER); if (!success) { return(success); } ApplicationUser user10 = new ApplicationUser(); PasswordHasher passwordHasher10 = new PasswordHasher(); user10.UserName = "******"; user10.Email = "*****@*****.**"; user10.RoleName = RolesConst.MANAGER; user10.FistName = RolesConst.MANAGER; user10.LastName = RolesConst.MANAGER; IdentityResult result10 = userManager.Create(user10, "Pas@123"); success = this.AddUserToRole(userManager, user10.Id, RolesConst.MANAGER); if (!success) { return(success); } ApplicationUser user11 = new ApplicationUser(); PasswordHasher passwordHaser11 = new PasswordHasher(); user11.UserName = "******"; user11.Email = "*****@*****.**"; user11.RoleName = RolesConst.MANAGER; user11.FistName = RolesConst.MANAGER; user11.LastName = RolesConst.MANAGER + " II"; IdentityResult result11 = userManager.Create(user11, "Pas@123"); success = this.AddUserToRole(userManager, user11.Id, RolesConst.MANAGER); if (!success) { return(success); } if (!success) { return(success); } ApplicationUser user12 = new ApplicationUser(); PasswordHasher passwordHaser12 = new PasswordHasher(); user12.UserName = "******"; user12.Email = "*****@*****.**"; user12.RoleName = RolesConst.ORDER_OPERATOR; user12.FistName = RolesConst.ORDER_OPERATOR; user12.LastName = RolesConst.ORDER_OPERATOR; IdentityResult result12 = userManager.Create(user12, "Pas@123"); success = this.AddUserToRole(userManager, user12.Id, RolesConst.ORDER_OPERATOR); if (!success) { return(success); } Catagorie cat1 = new Catagorie() { Name = "Visitka" }; Catagorie blog = new Catagorie() { Name = "Blog" }; this.Catagories.Add(cat1); this.Catagories.Add(blog); this.SaveChanges(); ProductItem item1 = new ProductItem() { Name = "Шаблон 1", Price = 100, shortDescription = "blabla", description = "blablaballll", Categorie = TemplateSiteTypes.Shop }; ProductItem item2 = new ProductItem() { Name = "Шаблон 2", Price = 234, shortDescription = "blabla", description = "blablaballll", Categorie = TemplateSiteTypes.VisitCard }; this.ProductItems.Add(item1); this.ProductItems.Add(item2); WorkItem workItem = new WorkItem() { Name = "Шаблон 1", Description = "blabla", // hours, minutes, seconds DueDate = DateTime.Today + (new TimeSpan(12, 20, 20)), Status = TaskStatus.InProgress }; this.WorkItems.Add(workItem); WorkItem workItem1 = new WorkItem() { Name = "Шаблон 2", Description = "blablabla", // hours, minutes, seconds DueDate = DateTime.Today + (new TimeSpan(12, 20, 20)), Status = TaskStatus.InProgress }; this.WorkItems.Add(workItem); this.SaveChanges(); WorkItem workItem2 = new WorkItem() { Name = "Icon", Description = "wow", // hours, minutes, seconds DueDate = DateTime.Today + (new TimeSpan(12, 20, 20)), Status = TaskStatus.InProgress }; this.WorkItems.Add(workItem2); this.SaveChanges(); // DueDate = new DateTime(2015,05,12); Resourse r1 = new Resourse() { Name = "Reorce", Price = 20, Description = "One the rule them all " }; Resourse r2 = new Resourse() { Name = "Reorce2", Price = 40, Description = "One the rule them all " }; this.Resources.Add(r1); this.Resources.Add(r2); Order or1 = new Order() { completeDate = DateTime.Now, OrderDate = DateTime.Now, detailDescription = "mememe", orderStartus = OrderStatus.Initiating, Total = 200, customer = new Customer() { Email = "@", FistName = "A", LastName = "B", RoleName = RolesConst.CUSTOMER, UserName = "******" } }; this.Orders.Add(or1); Order or2 = new Order() { completeDate = DateTime.Now, OrderDate = DateTime.Now, detailDescription = "nyanyayna", orderStartus = OrderStatus.Processiong, Total = 150, }; Order or3 = new Order() { completeDate = DateTime.Now, OrderDate = DateTime.Now, detailDescription = "sysysy", orderStartus = OrderStatus.Initiating, Total = 600, }; this.Orders.Add(or2); this.Orders.Add(or3); Project project = new Project() { name = "MyProject", nameProjectManager = "*****@*****.**", costs = 300, projectStatus = ProjectStatus.Initial, projectManager = user10, order = or1, tasks = new List <WorkItem>() }; project.tasks.Add(workItem); project.tasks.Add(workItem1); this.Projects.Add(project); this.SaveChanges(); return(success); }