/// <summary>
/// The main entry point of the application - initializes database drivers, checks access rights, detects the current page type and does more setting accordingly.
/// </summary>
protected void Page_Init(object sender, EventArgs e)
{
DbServer = (DbServer)Enum.Parse(typeof(DbServer), System.Configuration.ConfigurationManager.AppSettings["ServerType"] as string);
bool isFirstRun = System.Configuration.ConfigurationManager.AppSettings["FirstRun"] as string == "True";
// detect the site type based on the beginning of the URL
string lp = Request.Url.LocalPath;
if (lp.StartsWith("/architect")){
Common.Environment.GlobalState = GlobalState.Architect;
}
else if (lp.StartsWith("/admin")) {
Common.Environment.GlobalState = GlobalState.Administer;
}
else if(lp == "/sys/users"){
Common.Environment.GlobalState = GlobalState.UsersManagement;
}
else if(lp == "/sys/projects"){
Common.Environment.GlobalState = GlobalState.ProjectsManagement;
}
else if(lp.StartsWith("/account")){
Common.Environment.GlobalState = GlobalState.Account;
}
else if(lp.StartsWith("/FirstRun")){
Common.Environment.GlobalState = GlobalState.FirstRun;
}
else
Common.Environment.GlobalState = GlobalState.Error;
bool firstRunMono = System.Configuration.ConfigurationManager.AppSettings["FirstRunMono"] == "True";
if(isFirstRun && Common.Environment.GlobalState != GlobalState.FirstRun && !firstRunMono)
{
Response.Redirect("~/FirstRun/FirstRun.aspx");
}
if(!isFirstRun && Common.Environment.GlobalState == GlobalState.FirstRun)
{
Response.RedirectToRoute("DefaultRoute");
}
// set the warning only for logged in users
System.Configuration.ConfigurationManager.AppSettings["SessionWarning"] =
(user is MembershipUser) ? (Session.Timeout - 5).ToString() : "-1";
if (isFirstRun)
{
return;
}
user = Membership.GetUser();
// session expiry means logout, even if the provider would keep the user logged in
if ((Session.IsNewSession || user == null)
&& CE.GlobalState != GlobalState.Account && CE.GlobalState != GlobalState.Error)
{
FormsAuthentication.SignOut();
Response.RedirectToRoute("LockoutRoute", new { message = 7 });
}
IBaseDriver systemBaseDriver = null;
// initialize the system driver based on the server type read from the configuration
switch (DbServer)
{
case DbServer.MySql:
systemBaseDriver = new BaseDriverMySql(ConfigurationManager.ConnectionStrings["MySqlServer"].ConnectionString);
break;
case DbServer.MsSql:
systemBaseDriver = new BaseDriverMsSql(ConfigurationManager.ConnectionStrings["MsSqlServer"].ConnectionString);
break;
default:
break;
}
SysDriver = new SystemDriver(systemBaseDriver);
if (firstRunMono && CE.GlobalState != GlobalState.FirstRun)
{
Response.Redirect("~/FirstRun/FirstRunMono.aspx");
}
if (!firstRunMono && CE.GlobalState == GlobalState.FirstRun)
{
Response.RedirectToRoute("DefaultRoute");
}
if (firstRunMono)
{
return;
}
// global service
// is there a need for a reload of the project architecture?
bool NewProjectLoad = false;
// get current project and init drivers and architect
if (Page.RouteData.Values.ContainsKey("projectName"))
{
ProjectName = Page.RouteData.Values["projectName"] as string;
CE.Project actProject = SysDriver.GetProject(ProjectName);
if (CE.project == null || actProject.Id != CE.project.Id || actProject.Version != CE.project.Version)
{
Session.Clear(); // may not be neccessary in all cases, but better be safe
NewProjectLoad = true;
}
CE.project = SysDriver.GetProject(ProjectName);
IBaseDriver statsBaseDriver = null;
IBaseDriver webBaseDriver = null;
switch (CE.project.ServerType)
{
case DbServer.MySql:
statsBaseDriver = new BaseDriverMySql(CE.project.ConnstringIS);
Stats = new StatsMySql((BaseDriverMySql)statsBaseDriver, CE.project.WebDbName);
webBaseDriver = new BaseDriverMySql(CE._project.ConnstringWeb);
break;
case DbServer.MsSql:
statsBaseDriver = new BaseDriverMsSql(CE.project.ConnstringIS);
Stats = new StatsMsSql((BaseDriverMsSql)statsBaseDriver);
webBaseDriver = new BaseDriverMsSql(CE._project.ConnstringWeb);
break;
default:
break;
}
WebDriver = new WebDriver(webBaseDriver);
Architect = new _min.Models.Architect(SysDriver, Stats);
if ((!Page.IsPostBack || NewProjectLoad) && CE.GlobalState != GlobalState.Error)
// new version or differnet page ~ othervise access must have remained
// at least "allowable", if not allowed
{
LockingAccess(); // just check
}
// check whether there is something to load at all
if (Page.RouteData.Route != RouteTable.Routes["ArchitectInitRoute"])
{
if (!SysDriver.ProposalExists())
{
if (CE.GlobalState == GlobalState.Architect)
{
Response.RedirectToRoute("ArchitectInitRoute", new { projectName = Page.RouteData.Values["projectName"] });
Response.End();
}
else
{
// change to some kind of "Not found" page
Response.RedirectToRoute("DefaultRoute", new { projectName = Page.RouteData.Values["projectName"] });
Response.End();
}
}
// get the current architecture - either extract from Session or directry from the DB, if project version has changed
int actVersion = CE.project.Version;
if (Session[CC.SESSION_ARCHITECTURE] is _min.Models.Panel
&& Session[CC.SESSION_ARCHITECTURE_VERSION] is int
&& (int)Session[CC.SESSION_ARCHITECTURE_VERSION] == actVersion)
{
SysDriver.SetArchitecture((MPanel)Session[CC.SESSION_ARCHITECTURE]);
}
else
{
SysDriver.FullProjectLoad();
Session[CC.SESSION_ARCHITECTURE] = SysDriver.MainPanel;
Session[CC.SESSION_ARCHITECTURE_VERSION] = CE.project.Version;
}
}
}
// local issues
if (!Page.IsPostBack)
{
if (user != null)
{
List<string> adminOf;
List<string> architectOf;
List<CE.Project> allProjects = SysDriver.GetProjectObjects();
List<string> allNames = (from CE.Project p in allProjects select p.Name).ToList<string>();
object userId = user.ProviderUserKey;
int globalRights = SysDriver.GetUserRights(userId, null);
// by default, fetch only the sites to which the access rights are set explicitly,
// if global rights are sufficient, replace them with the complete lists
SysDriver.UserMenuOptions(userId, out adminOf, out architectOf);
if (globalRights % 100 >= 10) adminOf = allNames;
if (globalRights % 1000 >= 100) architectOf = allNames;
// decide on the upper menu content
MenuItem administerItem = new MenuItem("Administer", "admin");
foreach (string site in adminOf)
{
administerItem.ChildItems.Add(new MenuItem(site, site, null, "/admin/" + site));
}
if (adminOf.Count > 0)
NavigationMenu.Items.AddAt(0, administerItem);
// architect menu
MenuItem architectItem = new MenuItem("Architect", "architect");
foreach (string site in architectOf)
{
architectItem.ChildItems.Add(new MenuItem(site, site, null, "/architect/show/" + Server.UrlEncode(site)));
}
if (architectOf.Count > 0)
NavigationMenu.Items.AddAt(1, architectItem);
// user & projects management
NavigationMenu.Items.Add(new MenuItem("Manage users", "users", null, "/sys/users"));
if (globalRights >= 10000) // this is the one and only project manager for this application instance
NavigationMenu.Items.Add(new MenuItem("Manage projects", "projects", null, "/sys/projects"));
// account settings for logged in users
MenuItem accountItem = new MenuItem("Account", "account");
accountItem.ChildItems.Add(new MenuItem("Change password", null, null, "/account/change-password"));
accountItem.ChildItems.Add(new MenuItem("Logout", null, null, "/account/logout"));
NavigationMenu.Items.Add(accountItem);
}
else {
MenuItem accountItem = new MenuItem("Account", "account");
accountItem.ChildItems.Add(new MenuItem("Login", null, null, "/account/login"));
accountItem.ChildItems.Add(new MenuItem("Register", null, null, "/account/register"));
NavigationMenu.Items.Add(accountItem);
}
NavigationMenu.RenderingMode = MenuRenderingMode.Table;
}
}
/// <summary>
/// The main entry point of the application - initializes database drivers, checks access rights, detects the current page type and does more setting accordingly.
/// </summary>
protected void Page_Init(object sender, EventArgs e)
{
DbServer = (DbServer)Enum.Parse(typeof(DbServer), System.Configuration.ConfigurationManager.AppSettings["ServerType"] as string);
bool isFirstRun = System.Configuration.ConfigurationManager.AppSettings["FirstRun"] as string == "True";
// detect the site type based on the beginning of the URL
string lp = Request.Url.LocalPath;
if (lp.StartsWith("/architect"))
{
Common.Environment.GlobalState = GlobalState.Architect;
}
else if (lp.StartsWith("/admin"))
{
Common.Environment.GlobalState = GlobalState.Administer;
}
else if (lp == "/sys/users")
{
Common.Environment.GlobalState = GlobalState.UsersManagement;
}
else if (lp == "/sys/projects")
{
Common.Environment.GlobalState = GlobalState.ProjectsManagement;
}
else if (lp.StartsWith("/account"))
{
Common.Environment.GlobalState = GlobalState.Account;
}
else if (lp.StartsWith("/FirstRun"))
{
Common.Environment.GlobalState = GlobalState.FirstRun;
}
else
{
Common.Environment.GlobalState = GlobalState.Error;
}
bool firstRunMono = System.Configuration.ConfigurationManager.AppSettings["FirstRunMono"] == "True";
if (isFirstRun && Common.Environment.GlobalState != GlobalState.FirstRun && !firstRunMono)
{
Response.Redirect("~/FirstRun/FirstRun.aspx");
}
if (!isFirstRun && Common.Environment.GlobalState == GlobalState.FirstRun)
{
Response.RedirectToRoute("DefaultRoute");
}
// set the warning only for logged in users
System.Configuration.ConfigurationManager.AppSettings["SessionWarning"] =
(user is MembershipUser) ? (Session.Timeout - 5).ToString() : "-1";
if (isFirstRun)
{
return;
}
user = Membership.GetUser();
// session expiry means logout, even if the provider would keep the user logged in
if ((Session.IsNewSession || user == null) &&
CE.GlobalState != GlobalState.Account && CE.GlobalState != GlobalState.Error)
{
FormsAuthentication.SignOut();
Response.RedirectToRoute("LockoutRoute", new { message = 7 });
}
IBaseDriver systemBaseDriver = null;
// initialize the system driver based on the server type read from the configuration
switch (DbServer)
{
case DbServer.MySql:
systemBaseDriver = new BaseDriverMySql(ConfigurationManager.ConnectionStrings["MySqlServer"].ConnectionString);
break;
case DbServer.MsSql:
systemBaseDriver = new BaseDriverMsSql(ConfigurationManager.ConnectionStrings["MsSqlServer"].ConnectionString);
break;
default:
break;
}
SysDriver = new SystemDriver(systemBaseDriver);
if (firstRunMono && CE.GlobalState != GlobalState.FirstRun)
{
Response.Redirect("~/FirstRun/FirstRunMono.aspx");
}
if (!firstRunMono && CE.GlobalState == GlobalState.FirstRun)
{
Response.RedirectToRoute("DefaultRoute");
}
if (firstRunMono)
{
return;
}
// global service
// is there a need for a reload of the project architecture?
bool NewProjectLoad = false;
// get current project and init drivers and architect
if (Page.RouteData.Values.ContainsKey("projectName"))
{
ProjectName = Page.RouteData.Values["projectName"] as string;
CE.Project actProject = SysDriver.GetProject(ProjectName);
if (CE.project == null || actProject.Id != CE.project.Id || actProject.Version != CE.project.Version)
{
Session.Clear(); // may not be neccessary in all cases, but better be safe
NewProjectLoad = true;
}
CE.project = SysDriver.GetProject(ProjectName);
IBaseDriver statsBaseDriver = null;
IBaseDriver webBaseDriver = null;
switch (CE.project.ServerType)
{
case DbServer.MySql:
statsBaseDriver = new BaseDriverMySql(CE.project.ConnstringIS);
Stats = new StatsMySql((BaseDriverMySql)statsBaseDriver, CE.project.WebDbName);
webBaseDriver = new BaseDriverMySql(CE._project.ConnstringWeb);
break;
case DbServer.MsSql:
statsBaseDriver = new BaseDriverMsSql(CE.project.ConnstringIS);
Stats = new StatsMsSql((BaseDriverMsSql)statsBaseDriver);
webBaseDriver = new BaseDriverMsSql(CE._project.ConnstringWeb);
break;
default:
break;
}
WebDriver = new WebDriver(webBaseDriver);
Architect = new _min.Models.Architect(SysDriver, Stats);
if ((!Page.IsPostBack || NewProjectLoad) && CE.GlobalState != GlobalState.Error)
// new version or differnet page ~ othervise access must have remained
// at least "allowable", if not allowed
{
LockingAccess(); // just check
}
// check whether there is something to load at all
if (Page.RouteData.Route != RouteTable.Routes["ArchitectInitRoute"])
{
if (!SysDriver.ProposalExists())
{
if (CE.GlobalState == GlobalState.Architect)
{
Response.RedirectToRoute("ArchitectInitRoute", new { projectName = Page.RouteData.Values["projectName"] });
Response.End();
}
else
{
// change to some kind of "Not found" page
Response.RedirectToRoute("DefaultRoute", new { projectName = Page.RouteData.Values["projectName"] });
Response.End();
}
}
// get the current architecture - either extract from Session or directry from the DB, if project version has changed
int actVersion = CE.project.Version;
if (Session[CC.SESSION_ARCHITECTURE] is _min.Models.Panel &&
Session[CC.SESSION_ARCHITECTURE_VERSION] is int &&
(int)Session[CC.SESSION_ARCHITECTURE_VERSION] == actVersion)
{
SysDriver.SetArchitecture((MPanel)Session[CC.SESSION_ARCHITECTURE]);
}
else
{
SysDriver.FullProjectLoad();
Session[CC.SESSION_ARCHITECTURE] = SysDriver.MainPanel;
Session[CC.SESSION_ARCHITECTURE_VERSION] = CE.project.Version;
}
}
}
// local issues
if (!Page.IsPostBack)
{
if (user != null)
{
List <string> adminOf;
List <string> architectOf;
List <CE.Project> allProjects = SysDriver.GetProjectObjects();
List <string> allNames = (from CE.Project p in allProjects select p.Name).ToList <string>();
object userId = user.ProviderUserKey;
int globalRights = SysDriver.GetUserRights(userId, null);
// by default, fetch only the sites to which the access rights are set explicitly,
// if global rights are sufficient, replace them with the complete lists
SysDriver.UserMenuOptions(userId, out adminOf, out architectOf);
if (globalRights % 100 >= 10)
{
adminOf = allNames;
}
if (globalRights % 1000 >= 100)
{
architectOf = allNames;
}
// decide on the upper menu content
MenuItem administerItem = new MenuItem("Administer", "admin");
foreach (string site in adminOf)
{
administerItem.ChildItems.Add(new MenuItem(site, site, null, "/admin/" + site));
}
if (adminOf.Count > 0)
{
NavigationMenu.Items.AddAt(0, administerItem);
}
// architect menu
MenuItem architectItem = new MenuItem("Architect", "architect");
foreach (string site in architectOf)
{
architectItem.ChildItems.Add(new MenuItem(site, site, null, "/architect/show/" + Server.UrlEncode(site)));
}
if (architectOf.Count > 0)
{
NavigationMenu.Items.AddAt(1, architectItem);
}
// user & projects management
NavigationMenu.Items.Add(new MenuItem("Manage users", "users", null, "/sys/users"));
if (globalRights >= 10000) // this is the one and only project manager for this application instance
{
NavigationMenu.Items.Add(new MenuItem("Manage projects", "projects", null, "/sys/projects"));
}
// account settings for logged in users
MenuItem accountItem = new MenuItem("Account", "account");
accountItem.ChildItems.Add(new MenuItem("Change password", null, null, "/account/change-password"));
accountItem.ChildItems.Add(new MenuItem("Logout", null, null, "/account/logout"));
NavigationMenu.Items.Add(accountItem);
}
else
{
MenuItem accountItem = new MenuItem("Account", "account");
accountItem.ChildItems.Add(new MenuItem("Login", null, null, "/account/login"));
accountItem.ChildItems.Add(new MenuItem("Register", null, null, "/account/register"));
NavigationMenu.Items.Add(accountItem);
}
NavigationMenu.RenderingMode = MenuRenderingMode.Table;
}
}
private void button1_Click(object sender, RoutedEventArgs e)
{
/*
string connstring = "Server=109.74.158.75;Uid=dotnet;Pwd=dotnet;Database=ks;pooling=false";
DataTable log = new DataTable();
log.Columns.Add(new DataColumn("query", typeof(string)));
log.Columns.Add(new DataColumn("time", typeof(int)));
BaseDriverMySql driver = new BaseDriverMySql(connstring, log);
DateTime actDate = DateTime.Now;
int[] inlist = { 18, 28, 38, 39 };
DataTable table = driver.fetchAll("SELECT DATEDIFF(DATE(", actDate, "), `date`)", " FROM `users` WHERE `id` IN ", inlist);
label1.Content = table.Rows.Count.ToString();
Field f1 = new Field(1, "col", 1, "type", 1);
//label1.Content += f1.column + " " + f1.typeName;
//f1.typeName = "dddd";
DataTable tree = new DataTable("tree");
tree.Columns.Add("id", typeof(int));
tree.Columns.Add("parent", typeof(int));
tree.Rows.Add(1, null);
tree.Rows.Add(2, 1);
tree.Rows.Add(3, 1);
tree.Rows.Add(4, 2);
DataSet ds = new DataSet();
ds.Tables.Add(tree);
ds.Relations.Add(new DataRelation("r", tree.Columns[0], tree.Columns[1]));
DataRow[] children = ds.Tables["tree"].Rows[0].GetChildRows("r");
foreach (DataRow r in children) {
label1.Content += " ch " + r[0];
}
*/
MySqlConnection conn = new MySqlConnection("Server=109.74.158.75;Uid=django;Pwd=heslo;Database=django;pooling=false");
//MySqlCommand cmd = new MySqlCommand("SELECT * FROM users LIMIT 1", conn);
conn.Open();
//MySqlDataAdapter adap = new MySqlDataAdapter("SELECT * FROM users LIMIT 1", conn);
label1.Content = conn.State.ToString();
DataTable tab = new DataTable();
conn.Close();
/*
adap.Fill(tab);
textBox2.VerticalScrollBarVisibility = ScrollBarVisibility.Visible;
foreach (DataColumn col in tab.Columns) {
textBox2.Text += col.ColumnName + Environment.NewLine;
foreach (var prop in col.GetType().GetProperties())
{
textBox2.Text += prop.Name + " = " + prop.GetValue(col, null) + Environment.NewLine;
}
}
*/
textBox2.Text += "Creating basic objects" + Environment.NewLine;
string dbName = "naborycz";
stats = new StatsMySql(
dbName, "Server=109.74.158.75;Uid=dotnet;Pwd=dotnet;Database=information_schema;pooling=true");
sysDriver = new SystemDriverMySql(
"Server=109.74.158.75;Uid=dotnet;Pwd=dotnet;Database=deskmin;pooling=true");
CE.project = sysDriver.getProject(1);
webDriver = new WebDriverMySql(
"Server=109.74.158.75;Uid=dotnet;Pwd=dotnet;Database=" + dbName + ";pooling=false");
architect = new Architect(sysDriver, stats);
architect.Notice += new ArchitectNotice(Architect_Notice);
this.AdditionalArchitectNotice += new ArchitectNotice(Architect_Notice);
architect.Question += new ArchitectQuestion(Architect_Question);
architect.Error += new ArchitectureError(Architect_Error);
architect.Warning += new ArchitectWarning(Architect_Warning);
//AsyncProposeCaller caller = new AsyncProposeCaller(architect.propose);
//AsyncCallback callback = new AsyncCallback(ProposalReady);
Task<IPanel> proposalTask = new Task<IPanel>(()=>
{
return architect.propose();
}
);
proposalTask.ContinueWith((taskResult) => ProposalReady(taskResult));
proposalTask.Start();
/*
Task<string> task = new Task<string>((obj) =>
{
return Work(data);
}, state);
if (callBack != null)
{
task.ContinueWith((tsk) => callBack(tsk));
}
*/
//IAsyncResult asyncResult = caller.BeginInvoke(callback, proposal);
//IPanel proposal = architect.propose();
//IPanel proposal = caller.EndInvoke(asyncResult);
/*
DataRow row = tab.Rows[0];
foreach(DataColumn col in row.Table.Columns){
label1.Content += Environment.NewLine + col.ColumnName + " "
+ row[col.ColumnName];
}
conn.Close();
*/
}