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