public ActionResult Create(CreateModel model, string returnUrl) { using (var db = new IntercomContext()) { if (!WebSecurity.IsAuthenticated) { ModelState.AddModelError("", "Please Log in first"); } db.Tickets.Add(new Ticket { Assignee = 1, BuildingID = model.BuildingID, CallerName = model.CallerName, Description = model.Description, Email = model.Email, Phone = model.Phone, Status = TicketStatus.New, StatusReason = "New ticket" }); try { db.SaveChanges(); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { System.Console.WriteLine("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } } return(RedirectToAction("Index", "Home")); } }
public ActionResult Edit(EditModel model, int ObjectID) { if (WebSecurity.IsAuthenticated && Roles.GetRolesForUser(WebSecurity.CurrentUserName).Contains("Operator")) { ViewBag.id = ObjectID; using (var db = new IntercomContext()) { Ticket ticket = db.Tickets.Find(ObjectID); if (ticket == null) { return(HttpNotFound()); } else { model.ObjectID = ticket.ObjectID; model.CallerName = ticket.CallerName; model.BuildingID = ticket.BuildingID; model.Phone = ticket.Phone; model.Email = ticket.Email; model.StatusReason = ticket.StatusReason; model.Assignee = ticket.Assignee; model.Status = ticket.Status; model.Description = ticket.Description; } } return(View(model)); } return(RedirectToAction("Index", "Home")); }
public ActionResult Add(int UserID, int TicketID) { string[] roles = Roles.GetRolesForUser(WebSecurity.CurrentUserName); if (!(roles.Contains("Operator") || roles.Contains("Engineer"))) { //A potentially dangerous Request.Path value was detected from the client (:) exception appearing //return Request.UrlReferrer == null ? RedirectToAction("Index","Home") : RedirectToAction(Request.UrlReferrer.ToString()); return(RedirectToAction("Index", "Home")); } using (var db = new IntercomContext()) { Ticket ticket = db.Tickets.Find(TicketID); if (ticket == null) { return(HttpNotFound()); } else { ticket.Assignee = UserID; ticket.Status = TicketStatus.Assigned; db.SaveChanges(); return(RedirectToAction("Index", "Home")); } } }
public ActionResult Edit(EditModel model) { using (var db = new IntercomContext()) { Ticket EditedTicket = db.Tickets.Find(model.ObjectID); EditedTicket.Assignee = model.Assignee; EditedTicket.BuildingID = model.BuildingID; EditedTicket.CallerName = model.CallerName; EditedTicket.Description = model.Description; EditedTicket.Email = model.Email; EditedTicket.Phone = model.Phone; EditedTicket.Status = model.Status; EditedTicket.StatusReason = model.StatusReason; db.SaveChanges(); } return(RedirectToAction("Index", "Home")); }
public SimpleMembershipInitializer() { Database.SetInitializer <LoginContexts>(null); try { var databaseIsNew = false; using (var context = new LoginContexts()) { if (!context.Database.Exists()) { // Create the SimpleMembership database without Entity Framework migration schema context.Database.Create(); //((IObjectContextAdapter)context).ObjectContext.CreateDatabase(); databaseIsNew = true; // } } using (var context = new IntercomContext()) { if (!context.Database.Exists()) { // Create the SimpleMembership database without Entity Framework migration schema context.Database.Create(); } } WebSecurity.InitializeDatabaseConnection("DefaultConnection", "UserProfile", "UserId", "UserName", autoCreateTables: true); if (databaseIsNew) { if (!WebSecurity.UserExists("Admin")) { WebSecurity.CreateUserAndAccount("Admin", "Admin"); } if (!Roles.RoleExists("Admin")) { Roles.CreateRole("Admin"); Roles.AddUserToRole("Admin", "Admin"); } if (!Roles.RoleExists("Engineer")) { Roles.CreateRole("Engineer"); Roles.AddUserToRole("Admin", "Engineer"); } if (!Roles.RoleExists("Operator")) { Roles.CreateRole("Operator"); Roles.AddUserToRole("Admin", "Operator"); } if (!Roles.RoleExists("User")) { Roles.CreateRole("User"); Roles.AddUserToRole("Admin", "User"); } } } catch (Exception ex) { throw new InvalidOperationException("The ASP.NET Simple Membership database could not be initialized. For more information, please see http://go.microsoft.com/fwlink/?LinkId=256588", ex); } }