/// <summary> /// Removes a gadget from database. /// </summary> /// <param name="g"></param> public static void RemoveGadget(Gadget g) { AppDataModelContainer context = new AppDataModelContainer(); context.Gadgets.Remove(g); context.SaveChanges(); }
public static Gadget AddGadget(Gadget g) { AppDataModelContainer context = new AppDataModelContainer(); g = context.Gadgets.Add(g); context.SaveChanges(); return(g); }
public static Gadget GetByName(string systemName) { Gadget gadget; using (AppDataModelContainer context = new AppDataModelContainer()) { gadget = context.Gadgets.Where <Gadget>(g => g.SystemName == systemName).First(); } return(gadget); }
public static MembershipUser RegisterUser(string username, string password, string email, string roleName = "", bool installDefaultGadgets = true, bool setDefaultSettings = true) { // Create user and set it's role var user = Membership.CreateUser(username, password, email); if (roleName != "") { if (!Roles.RoleExists(roleName)) { Roles.CreateRole(roleName); } Roles.AddUserToRole(username, roleName); } // Set default user settings //if (setDefaultSettings) { // UserManager.SetUserSetting((Guid)user.ProviderUserKey, "main", ""); //} // Install default gadgets if (installDefaultGadgets) { AppDataModelContainer context = new AppDataModelContainer(); GadgetInstance gi = new GadgetInstance(); var userManagerGadget = context.Gadgets.First(g => g.SystemName == "UserManager"); gi.Gadget = userManagerGadget; gi.UserId = (Guid)user.ProviderUserKey; context.GadgetInstances.Add(gi); context.SaveChanges(); } return(user); }
public GadgetInstanceManager(int gadgetInstanceId) { _context = EFHelper.GetContext <AppDataModelContainer>(); _giid = gadgetInstanceId; }
// // GET: /Db/ public ActionResult Index() { AppDataModelContainer ctx = new AppDataModelContainer(); #region Initialize Gadgets ctx.Gadgets.RemoveRange(ctx.Gadgets); // Load Gadgets from "Gadgets.xml" and save them into database XmlDocument xmlDoc = new XmlDocument(); xmlDoc.Load(Server.MapPath("~/App_Data/Gadgets.xml")); foreach (XmlNode xmlNode in xmlDoc.DocumentElement.ChildNodes) { Gadget g = new Gadget(); string createDateValue, lastUpdateValue; createDateValue = xmlNode.Attributes["CreateDate"].Value; lastUpdateValue = xmlNode.Attributes["LastUpdate"].Value; g.SystemName = xmlNode.Attributes["SystemName"].Value; g.PublicName = xmlNode.Attributes["PublicName"].Value; g.GadgetType = (GadgetType)Enum.Parse(typeof(GadgetType), xmlNode.Attributes["GadgetType"].Value); g.Description = xmlNode.Attributes["Description"].Value; g.Version = xmlNode.Attributes["Version"].Value; g.FolderName = xmlNode.Attributes["FolderName"].Value; //g.DefaultRowSpan = Byte.Parse(xmlNode.Attributes["DefaultRowSpan"].Value); //g.DefaultColumnSpan = Byte.Parse(xmlNode.Attributes["DefaultColSpan"].Value); g.CreateDate = (createDateValue == "Now") ? DateTime.Now : DateTime.Parse(createDateValue); g.LastUpdate = (lastUpdateValue == "Now") ? DateTime.Now : DateTime.Parse(lastUpdateValue); g.HomePageUrl = xmlNode.Attributes["HomePageUrl"].Value; g.Enabled = bool.Parse(xmlNode.Attributes["Enabled"].Value); g.Data = xmlNode.Attributes["Data"].Value; //g.MainSetting = xmlNode.Attributes["Setting"].Value; ctx.Gadgets.Add(g); } ctx.SaveChanges(); #endregion #region Initialize Users and Roles // Initialize roles if (!Roles.RoleExists("admin")) { Roles.CreateRole("admin"); } // Delete all users MembershipUserCollection users = Membership.GetAllUsers(); foreach (MembershipUser item in users) { Membership.DeleteUser(item.UserName, true); } // Create User "Admin" and initialize it var adminUser = Membership.CreateUser("Admin", "123456", "*****@*****.**"); Roles.AddUserToRole("Admin", "Admin"); // Create User "Guest" and initialize it var guestUser = Membership.CreateUser("Guest", "123456", "*****@*****.**"); var guestUserId = (Guid)guestUser.ProviderUserKey; ctx.GadgetInstances.Add(new GadgetInstance("Calandar", guestUserId, 2, 0, 2, 2)); ctx.GadgetInstances.Add(new GadgetInstance("Clock", guestUserId, 2, 2, 2, 2)); ctx.GadgetInstances.Add(new GadgetInstance("Email", guestUserId, 0, 0, 2, 4)); ctx.GadgetInstances.Add(new GadgetInstance("News", guestUserId, 0, 4, 4, 5)); UserManager guestUserManager = new UserManager(guestUserId); guestUserManager.SetSetting( key: "PanelHost", value: Newtonsoft.Json.JsonConvert.SerializeObject(new { rows = 4, cw = 100, ch = 100, cg = 10, }), publicSetting: false); ctx.SaveChanges(); #endregion return(Content("Database Initialized.")); }
public static Gadget GetById(int id) { AppDataModelContainer context = new AppDataModelContainer(); return(context.Gadgets.Where <Gadget>(g => g.Id == id).First()); }
public UserManager(Guid userId) { _userId = userId; _context = EFHelper.GetContext <AppDataModelContainer>();; }