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);
}
