public void Update_MenuItem(MenuItem item) { using (var context = new LeieveContext()) { context.Entry(item).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } }
public void Add_MenuItem(MenuItem item) { using (var context = new LeieveContext()) { context.MenuItems.Add(item); context.SaveChanges(); } }
public List <MenuItem> MenuItems_List() { using (var context = new LeieveContext()) { var res = context.MenuItems; return(res.ToList()); } }
public List <ShoppingCartItemPOCO> List_ItemsForShoppingCart(int employeeid) { using (var context = new LeieveContext()) { var results = (from x in context.ShoppingCarts where x.EmployeeID.Equals(employeeid) select x).FirstOrDefault(); } return }
public void Delete_MenuItem(MenuItem item) { using (var context = new LeieveContext()) { var existing = context.MenuItems.Find(item.MenuItemID); context.MenuItems.Remove(existing); context.SaveChanges(); } }
public List <CategoryDTO> MenuByCategory_list() { using (var context = new LeieveContext()) { var resualt = from x in context.Categories orderby x.Description select new CategoryDTO { Description = x.Description, MenuItems = from y in x.MenuItems orderby y.Description select new MenuItemPOCO { Itemid = y.MenuItemID, ItemDescription = y.Description, Price = y.SellingPrice } }; return(resualt.ToList()); } }
public void AddDefaultUsers() { using (var context = new LeieveContext()) { // Add a web master user //Users accesses all the records on the AspNetUsers table //UserName is the user logon user id (dwelch) if (!Users.Any(u => u.UserName.Equals(STR_WEBMASTER_USERNAME))) { var webMasterAccount = new ApplicationUser() { //create a new instance that will be used as the data to // add a new record to the AspNetUsers table //dynamically fill two attributes of the instance UserName = STR_WEBMASTER_USERNAME, Email = string.Format(STR_EMAIL_FORMAT, STR_WEBMASTER_USERNAME) }; //place the webmaster account on the AspNetUsers table this.Create(webMasterAccount, STR_DEFAULT_PASSWORD); //place an account role record on the AspNetUserRoles table //.Id comes from the webmasterAccount and is the pkey of the Users table //role will comes from the Entities.Security.SecurityRoles this.AddToRole(webMasterAccount.Id, SecurityRoles.WebsiteAdmins); } //get all current employees //linq query will not execute as yet //return datatype will be IQueryable<EmployeeListPOCO> var currentEmployees = from x in context.Employees select new EmployeeListPOCO { EmployeeId = x.EmployeeID, FirstName = x.FirstName, LastName = x.LastName }; //get all employees who have an user account //Users needs to be in memory therfore use .ToList() //POCO EmployeeID is an int //the Users Employee id is an int? //since we will only be retrieving // Users that are employees (ID is not null) // we need to convert the nullable int into // a require int //the results of this query will be in memory var UserEmployees = from x in Users.ToList() where x.EmployeeID.HasValue select new RegisteredEmployeePOCO { UserName = x.UserName, EmployeeId = int.Parse(x.EmployeeID.ToString()) }; //loop to see if auto generation of new employee //Users record is needed //the foreach cause the delayed execution of the //linq above foreach (var employee in currentEmployees) { //does the employee NOT have a logon (no User record) if (!UserEmployees.Any(us => us.EmployeeId == employee.EmployeeId)) { //create a suggested employee UserName //firstname initial + LastName: dwelch var newUserName = employee.FirstName.Substring(0, 1) + employee.LastName; //create a new User ApplicationUser instance var userAccount = new ApplicationUser() { UserName = newUserName, Email = string.Format(STR_EMAIL_FORMAT, newUserName), EmailConfirmed = true }; userAccount.EmployeeID = employee.EmployeeId; //create the Users record IdentityResult result = this.Create(userAccount, STR_DEFAULT_PASSWORD); //result hold the return value of the creation attempt //if true, account was created, //if false, an account already exists with that username if (!result.Succeeded) { //name already in use //get a UserName that is not in use newUserName = VerifyNewUserName(newUserName); userAccount.UserName = newUserName; this.Create(userAccount, STR_DEFAULT_PASSWORD); } //create the staff role in UserRoles this.AddToRole(userAccount.Id, SecurityRoles.Staff); } } } }