Esempio n. 1
0
    //-------------------------------------------------------------------------------------------
    private void ConfigureDatabase()
    {
        using (WeavverEntityContainer data = new WeavverEntityContainer())
          {
               // Run SQL Deploy script
               string connectionString = ConfigurationManager.ConnectionStrings["WeavverEntityContainer"].ConnectionString;
               var entityBuilder = new System.Data.EntityClient.EntityConnectionStringBuilder(connectionString);
               SqlConnection connection = new SqlConnection(entityBuilder.ProviderConnectionString);
               connection.Open();

               string script = System.IO.File.ReadAllText(Server.MapPath(@"\bin\Database.sql")); //data.CreateDatabaseScript();
               script = script.Replace("%dalpath%", Server.MapPath(@"\bin\Weavver.DAL.dll"));
               script = script.Replace("%databasename%", connection.Database);
               string[] blocks = System.Text.RegularExpressions.Regex.Split(script, "\nGO");
               foreach (string block in blocks)
               {
                    if (block.Trim() != String.Empty)
                    {
                         SqlCommand createDb = new SqlCommand(block, connection);
                         try
                         {
                              createDb.ExecuteNonQuery();
                         }
                         catch (Exception ex)
                         {
                              throw new Exception("Block: " + block, ex);
                         }

                    }
               }

               // CREATE INITIAL DATA
               Guid orgId = Guid.NewGuid();
               Session["SelectedOrganizationId"] = orgId;

               // deploy first org
               Weavver.Data.Logistics_Organizations org = new Weavver.Data.Logistics_Organizations();
               org.Id = orgId;
               org.OrganizationId = org.Id; // THIS IS OVERRIDDEN ANYWAY BY AUDITUTILITY AS A SECURITY PRECAUTION
               org.OrganizationType = "Personal";
               org.Name = Organization.Text;
               org.VanityURL = "default";
               org.EIN = "";
               org.Founded = DateTime.UtcNow;
               org.Bio = "This is a sample organization.";
               org.CreatedAt = DateTime.UtcNow;
               org.CreatedBy = Guid.Empty;
               org.UpdatedAt = DateTime.UtcNow;
               org.UpdatedBy = Guid.Empty;
               data.Logistics_Organizations.AddObject(org);
               data.SaveChanges();

               Weavver.Data.System_Users user = new Weavver.Data.System_Users();
               user.Id = orgId;
               user.OrganizationId = org.Id; // THIS IS OVERRIDDEN ANYWAY BY AUDITUTILITY AS A SECURITY PRECAUTION
               user.FirstName = "Enlightened";
               user.LastName = "User";
               user.Activated = true;
               user.Locked = false;
               user.Username = Username.Text;
               user.Password = Password.Text;
               user.CreatedAt = DateTime.UtcNow;
               user.CreatedBy = Guid.Empty;
               user.UpdatedAt = DateTime.UtcNow;
               user.UpdatedBy = Guid.Empty;
               data.System_Users.AddObject(user);
               data.SaveChanges();

               Roles.ApplicationName = orgId.ToString();
               string adminuser = user.Username;
               Roles.CreateRole("Administrators");
               Roles.AddUsersToRoles(new string[] { adminuser }, new string[] { "Administrators" });
               Roles.CreateRole("Accountants");
               Roles.AddUsersToRoles(new string[] { adminuser }, new string[] { "Accountants" });

               if (data.SaveChanges() > 0)
                    Response.Redirect("~/install/step2");
          }
    }
Esempio n. 2
0
        //-------------------------------------------------------------------------------------------
        /// <summary>
        /// 
        /// </summary>
        /// <param name="organizationId"></param>
        /// <returns>This returns the PayeeId on the server.</returns>
        public string CreatePayeeData(Logistics_Organizations payee)
        {
            Billpayment paymentData = GetOFXBillPaymentObject();

               PayeeDetail item = new PayeeDetail();
               //item.Id = "1234";

               item.Account = payee.Id.ToString().Replace("-", "");
               item.Name = "John Doe";
               item.Addr1 = "Line 1b";
               item.Addr2 = "Line 2b";
               item.Addr3 = "Line 3";
               item.City = "Weavverville";
               item.State = "CA";
               item.PostalCode = "92832";
               item.Country = "USA";
               item.Phone = "7148531212";

               paymentData.Payee = item;

               paymentData.AddPayee();
               return item.ListId;
        }
Esempio n. 3
0
//-------------------------------------------------------------------------------------------
    private void ConfigureDatabase()
    {
        using (WeavverEntityContainer data = new WeavverEntityContainer())
        {
            // Run SQL Deploy script
            string        connectionString = ConfigurationManager.ConnectionStrings["WeavverEntityContainer"].ConnectionString;
            var           entityBuilder    = new System.Data.EntityClient.EntityConnectionStringBuilder(connectionString);
            SqlConnection connection       = new SqlConnection(entityBuilder.ProviderConnectionString);
            connection.Open();

            string script = System.IO.File.ReadAllText(Server.MapPath(@"\bin\Database.sql"));    //data.CreateDatabaseScript();
            script = script.Replace("%dalpath%", Server.MapPath(@"\bin\Weavver.DAL.dll"));
            script = script.Replace("%databasename%", connection.Database);
            string[] blocks = System.Text.RegularExpressions.Regex.Split(script, "\nGO");
            foreach (string block in blocks)
            {
                if (block.Trim() != String.Empty)
                {
                    SqlCommand createDb = new SqlCommand(block, connection);
                    try
                    {
                        createDb.ExecuteNonQuery();
                    }
                    catch (Exception ex)
                    {
                        throw new Exception("Block: " + block, ex);
                    }
                }
            }

            // CREATE INITIAL DATA
            Guid orgId = Guid.NewGuid();
            Session["SelectedOrganizationId"] = orgId;

            // deploy first org
            Weavver.Data.Logistics_Organizations org = new Weavver.Data.Logistics_Organizations();
            org.Id               = orgId;
            org.OrganizationId   = org.Id;  // THIS IS OVERRIDDEN ANYWAY BY AUDITUTILITY AS A SECURITY PRECAUTION
            org.OrganizationType = "Personal";
            org.Name             = Organization.Text;
            org.VanityURL        = "default";
            org.EIN              = "";
            org.Founded          = DateTime.UtcNow;
            org.Bio              = "This is a sample organization.";
            org.CreatedAt        = DateTime.UtcNow;
            org.CreatedBy        = Guid.Empty;
            org.UpdatedAt        = DateTime.UtcNow;
            org.UpdatedBy        = Guid.Empty;
            data.Logistics_Organizations.AddObject(org);
            data.SaveChanges();

            Weavver.Data.System_Users user = new Weavver.Data.System_Users();
            user.Id             = orgId;
            user.OrganizationId = org.Id;    // THIS IS OVERRIDDEN ANYWAY BY AUDITUTILITY AS A SECURITY PRECAUTION
            user.FirstName      = "Enlightened";
            user.LastName       = "User";
            user.Activated      = true;
            user.Locked         = false;
            user.Username       = Username.Text;
            user.Password       = Password.Text;
            user.CreatedAt      = DateTime.UtcNow;
            user.CreatedBy      = Guid.Empty;
            user.UpdatedAt      = DateTime.UtcNow;
            user.UpdatedBy      = Guid.Empty;
            data.System_Users.AddObject(user);
            data.SaveChanges();

            Roles.ApplicationName = orgId.ToString();
            string adminuser = user.Username;
            Roles.CreateRole("Administrators");
            Roles.AddUsersToRoles(new string[] { adminuser }, new string[] { "Administrators" });
            Roles.CreateRole("Accountants");
            Roles.AddUsersToRoles(new string[] { adminuser }, new string[] { "Accountants" });

            if (data.SaveChanges() > 0)
            {
                Response.Redirect("~/install/step2");
            }
        }
    }