3D architecture drawing

Ijust started a new job as Software Architect. I would really appreciate if somone can share their opinions regarding architecture of the following project that I can implement. I was planning to utilize MVP, DDD, TDD, IOC, Dependency Injection, Repository , StructureMap etc. I am not sure about how to achieve the portal aspect and value added services.

Technology:

• Client Web Portal
• ASP.Net /C#/SQL Server

Project Specification:

• 5 types of customers
• Template of service
• Dynamic Content Driven portal
• Modules can be activated/deactivated through management console
• Branding and customization
• Rapid deployment portals of future clients as well
• Portals will allow for customization
• Data reporting services
• Value- Add services to the clients portal
• Each Clients welcome page can be customized by client as well
• Mobile Application services
• Localization

I would really appreciate if someone can point out the following:

• Best Architecture for this project
• Patterns to use
• How the data layer should be layed out?
• How to achieve portal technology
• Value add services
• Any open source existing resources which can be utilized
• Any books which will put me in the right direction

I have an MVC3 web app that represents about a dozen different entities, but I have built a common search function so that the user can do a single search and get results from the various entities. It works fine, but as I suspected, the performance is slow because the search is occurring live and there's a lot to search. A cache would be fine even if it was a long one (daily even), but I don't know where and when to actually refresh the cache. If a person uses the search when it's been longer than the cache timeout then it will be really slow for them that one time and that's not acceptable. I'm thinking that I have to have a Windows service in place or something that builds the cache, but perhaps there's a better way that I don't know about. I can't do it entirely in the database because some of the entities don't exist in the database (one entity list is composed by searching through some files on the system for instance). Any help is appreciated.

Hi,

 

Print dialog allows you to print multiple pages per sheet using the following option:

Page Scaling: Multiple pages per sheet

 

Is the same possible while printing the document using System.Drawing.Printing namespace?

Regards,

 

---

When you learn you excel; when you learn you achieve; when you learn you succeed.

Hello everyone, I have a question regarding powershell provider architecture. I have a datastore that is both heirarchical and heterogeneous in nature. I.e. there is no single node or leaf type. I would like to navigate and manipulate this data store contextually while providing appropriate actions for each data type encountered. What is the proper way to approach this? Must I create multiple providers that work in concert with each other? Or is the proper approach to have a single provider that checks each type and alters the behavior of each cmdlet override as necessary. I hope I explained this properly. I also hope I placed this in the correct forum :) Thanks for your input.

I've read several different replication scenarios and technologies native to SQL Server (we are talking about SQL Server 2005) but have some questions.

I have a project to integrate/replicate two network-separated SQL Server 2005 databases.  Each database resides in a physically separate location at different companies.  They will not have a shared network environment and will not allow direct connection between the two databases.

We need to keep each database in sync as far as customer records.  Near real time is preferable.  There is not master.  One could add/delete/modify a customer record in one database and it needs to reflect in the other database. 

 

The closest we could get for connectivity architecture looks like this:

1.  Each database is on the separate internal networks for each company.

2.  Each organization HAS agreed to setup a DMZ on their sides specifically for this exchange.  Each respective DMZ will be able to communicate with their own internal SQL Server and have a fiber connect directly connecting each organization's dmz.

SO.... is there a good way to replicate from InternalSQL_1 - DMZ1 - DMZ2 - InternalSQL_2 near real time?

What would your recommendation be?  Pretty sure I'd setup both internal InternalSQL as Pub/Sub/Dist but I'm soliciting suggestions for transporting across the DMZ's in each direction.

 

Any help would be appreciated

Hello

 

I have created a Visio 2010 Drawing, and saved it as a web drawing to my sharepoint 2010 server.

Visio 2010 - Version: 14.0.4760.1000 (32-bit)
SharePoint 2010 - Version 14.0.4763.1000 (64-bit)

When i create a page and add a visio web access webpart and then open my web drawing i get an error which reads:

'The Server failed to process the request'

The Event Viewer shows the following error:

Failed to get Vector Diagram for visio file page Exception : The server was unable to process the request due to an internal error. For more information about the error, either turn on IncludeExceptionDetailInFaults (either from ServiceBehaviorAttribute or from the <serviceDebug> configuration behavior) on the server in order to send the exception information back to the client, or turn on tracing as per the Microsoft .NET Framework 3.0 SDK documentation and inspect the server trace logs.

I have tried google, bing and technet but cant find an answer.

I have a secure store target spplication id set up and credentials set and have added that information to the visio graphic service global settings.

Any ideas what i can do to fix this issue?

Hi !

I don't know if this is the proper forum for this question, but anyway, here is my problem:

Drawing PixelFormat.Format8bppIndexed bitmaps with transparency (using ImageAttributes.SetColorMatrix) does not work properly under Windows 7 (it works fine under XP & Vista). However it works as expected with PixelFormat.Format24bppRgb.

The sample code provided below can be used to easily reproduce the problem. All you need to do is add two 8bpp images (Image1 & Image2) in the application resources. Note that if you uncomment line "m_isSeven = (Environment.OSVersion..." the 8bpp bitmap is cloned to a 24bppRgb bitmap, and the bitmap is then drawn properly:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Drawing.Imaging;

namespace Windows7TransparencyTest
{
 public partial class Form1 : Form
 {
  private System.Windows.Forms.TrackBar trackBar1;
  private bool m_isSeven = false;

  public Form1()
  {
   InitializeComponent();

   DoubleBuffered = true;

   //m_isSeven = (Environment.OSVersion.Version.Major == 6) && (Environment.OSVersion.Version.Minor == 1);
  }

  private void InitializeComponent()
  {
   this.trackBar1 = new System.Windows.Forms.TrackBar();
   ((System.ComponentModel.ISupportInitialize)(this.trackBar1)).BeginInit();
   this.SuspendLayout();
   //
   // trackBar1
   //
   this.trackBar1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left)
      | System.Windows.Forms.AnchorStyles.Right)));
   this.trackBar1.Location = new System.Drawing.Point(1, 320);
   this.trackBar1.Maximum = 100;
   this.trackBar1.Name = "trackBar1";
   this.trackBar1.Size = new System.Drawing.Size(418, 50);
   this.trackBar1.TabIndex = 0;
   this.trackBar1.TickFrequency = 5;
   this.trackBar1.Scroll += new System.EventHandler(this.trackBar1_Scroll);
   //
   // Form1
   //
   this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
   this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
   this.BackColor = System.Drawing.Color.Black;
   this.ClientSize = new System.Drawing.Size(420, 373);
   this.Controls.Add(this.trackBar1);
   this.Name = "Form1";
   this.Text = "Form1";
   ((System.ComponentModel.ISupportInitialize)(this.trackBar1)).EndInit();
   this.ResumeLayout(false);
   this.PerformLayout();

  }

  protected override void OnPaint(PaintEventArgs e)
  {
   base.OnPaint(e);

   float[][] matrix = { new float[] {1, 0, 0, 0, 0},
                           new float[] {0, 1, 0, 0, 0},
                           new float[] {0, 0, 1, 0, 0},
                           new float[] {0, 0, 0, (float)trackBar1.Value / 100, 0},
                           new float[] {0, 0, 0, 0, 1}};

   // Create image attributes
   ImageAttributes imgAttributes = new ImageAttributes();

   // Set color matrix
   imgAttributes.SetColorMatrix(new ColorMatrix(matrix), ColorMatrixFlag.Default, ColorAdjustType.Bitmap);

   Bitmap image1 = Properties.Resources.Image1;
   Bitmap image2 = Properties.Resources.Image2;

   if (m_isSeven && (image2.PixelFormat == PixelFormat.Format8bppIndexed)) image2 = image2.Clone(new Rectangle(0, 0, image2.Width, image2.Height), P

Hi everyone, i am curious to know when should be use mvc architecture ?

Thanks,

Hello everyone. I write a new project in Asp.Net Iused Oracle Database. When I used sql server I developed my store procedure call method. And When I write procedure name and parameters store procedure execute than it show me dataTable.This is code

 protected DataTable ExecSp(string procedure)
        {
            if (_connection == null)
                _connection = new SqlConnection(_connStr);

            var cmd = new SqlCommand(procedure) {Connection = _connection, CommandType = CommandType.StoredProcedure};

            var da = new SqlDataAdapter(cmd);
            var dt = new DataTable();
            da.Fill(dt);
            CloseReader();
            return dt;
        }

        protected DataTable ExecSp(string procedure, object parameter)
        {
            if (_connection == null)
                _connection = new SqlConnection(_connStr);

            var cmd = new SqlCommand(procedure) {Connection = _connection, CommandType = CommandType.StoredProcedure};

            if (parameter != null)
            {
                PropertyInfo[] properties = parameter.GetType().GetProperties();
                for (int i = 0; i < properties.Length; i++)
                {
                    PropertyInfo p = properties[i];

                    string name = p.Name;
                    //string value = p.GetValue(parameter, null).ToString();

                    string value = string.Empty;
                    object _value = p.GetValue(parameter, null);
                    if (_value != null) value = _value.ToString();

                    var param = new SqlParameter {ParameterName = name, Value = value};

                    if (p.PropertyType == typeof (int))
                    {
                        param.SqlDbType = SqlDbType.Int;
                    }
                    else if (p.PropertyType == typeof (DateTime))
                    {
                        param.SqlDbType = SqlDbType.DateTime;
                    }

                    cmd.Parameters.Add(param);
                }
            }

            var da = new SqlDataAdapter(cmd);
            var dt = new DataTable();
            da.Fill(dt);
            return dt;
        }

        private void CloseReader()
        {
            if (_connection != null)
                _connection.Close();
        }

And now. How can use this method on oracle? Oracle command and Oracle store Procedures. I try something but when use where condition it give me error for parameter. How can I fix this code for oracle

        private readonly string _connStr =
    WebConfigurationManager.ConnectionStrings["OracleConnectionString"].ConnectionString;

        private OracleConnection _connection;

        public IDataReader ExecuteOracleCommand(string query)
        {
            if (_connection == null)
                _connection = new OracleConnection(_connStr);

            var oracleConnection = new OracleConnection(_connStr);

            var oracleCommand = new OracleCommand(query, oracleConnection) { CommandType = CommandType.Text };
            oracleConnection.Open();
            OracleDataReader reader = oracleCommand.ExecuteReader();

            CloseReader();
            return reader;


        }

Thanks everyone

hi,

recently i've studied on ADO.NET's Entity Model Framework and say 'wow' as ORM is one of the fevourite pattern i practice..but suddenly i've come to an ambiguous situation when i'm going to start....

 

i usually follow the following 3-tier architecture..

1. UI Layer

2. BLL - business logic layer

3. DAL - Data Access Layer

     a. DTO / DAO

     b. Gateway  (contains the sql query/stored procedure and connection with DB)

 

now when i'm going to use the Entity Model Design,where  the DBML/ .edmx File should be placed !?!!!

Because many a times i'm using the DBML file as DTO because of the mapped objects.. in the same time, sometimes DBML ( .edmx file in .NET 4.0) contains CRUD methods and stored procedured method as well as methods with different selection operations,- which should be in Gateway......

so where the .edmx file should be placed !?!! IN DTO namespace !? or in Gateway namespace !!!

moreover sometimes there is no need for the BLL which breaks the rules of inter-layer-communication (UI > BLL > DAL.Gateway) .. !!!

what makes me confuse is, what should be the ideal n-tier architecture when i'll use the ADO.NET Entity Model Design Framework...