Esempio n. 1
0
        public List <MenuItem> VulDrankenKaart(Catagorie c, Dagdeel d)
        {
            md = new MenuitemDAO();
            List <MenuItem> menuKaart = md.GetMenuItems(c, d);

            return(menuKaart);
        }
Esempio n. 2
0
        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);
        }
Esempio n. 3
0
        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"));
        }
Esempio n. 5
0
        private void btn_Drank_Click(object sender, EventArgs e)
        {
            Catagorie c = new Catagorie();

            c = Catagorie.dranken;
            Dagdeel d = new Dagdeel();

            VulMenuKaart(c, d);
        }
Esempio n. 6
0
        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));
        }
Esempio n. 8
0
 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));
        }
Esempio n. 11
0
        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);
        }
Esempio n. 12
0
        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);
            }
        }
Esempio n. 13
0
        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);
        }
Esempio n. 14
0
        private void btn_Drank_Click(object sender, EventArgs e)
        {
            c = Catagorie.dranken;

            VulMenuKaart(c);
        }
Esempio n. 15
0
        private void btn_Nagerecht_Click(object sender, EventArgs e)
        {
            c = Catagorie.nagerecht;

            VulMenuKaart(c);
        }
Esempio n. 16
0
        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);
        }