MVC Sample Apps

Source code checked in, #9325

robconery — Wed, 11 Jun 2008 00:30:08 GMT

Part 14: Ajax Added Ajax MVC Helper Added MVC Remote scripting javascript bits.

CREATED ISSUE: Server Error in '/' Application

spirith — Mon, 09 Jun 2008 07:15:47 GMT

Hi,

I get the db connection error when I try to execute the website. I have enabled the Local and Remote Connections (using both TCP/IP and Named pipes) using the SQL Surface Area configuration screen. Also enabled the Sql server browser. But still I get this error.

Any ideas?

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Source Error:

Line 26: /// <returns>CategoryCollection</returns>
Line 27: public IList<Category> GetCategories() {
Line 28: IList<Category> rawCategories = _repository
Line 29: .GetCategories().ToList();
Line 30:

Source File: D:\project\StoreFront\Commerce.MVC2\Commerce.MVC\Commerce.MVC.Services\CatalogService.cs Line: 28

Stack Trace:

[SqlException (0x80131904): An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800131
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186
System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) +737554
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +114
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +381
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +173
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +357
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +30
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +494
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Data.Linq.SqlClient.SqlConnectionManager.UseConnection(IConnectionUser user) +41
System.Data.Linq.SqlClient.SqlProvider.get_IsSqlCe() +34
System.Data.Linq.SqlClient.SqlProvider.InitializeProviderMode() +18
System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query) +260
System.Data.Linq.DataQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator() +93
System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) +369
System.Linq.Enumerable.ToList(IEnumerable`1 source) +54
Commerce.MVC.Services.CatalogService.GetCategories() in D:\project\StoreFront\Commerce.MVC2\Commerce.MVC\Commerce.MVC.Services\CatalogService.cs:28
Commerce.MVC.Web.Controllers.CatalogController.Index(String category, String subcategory) in D:\project\StoreFront\Commerce.MVC2\Commerce.MVC\Commerce.MVC.Web\Controllers\CatalogController.cs:51

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +0
System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +72
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) +371
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +29
System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters) +17
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(MethodInfo methodInfo, IDictionary`2 parameters) +545
System.Web.Mvc.<>c__DisplayClass8.<InvokeActionMethodWithFilters>b__5() +108
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) +331
System.Web.Mvc.<>c__DisplayClassa.<InvokeActionMethodWithFilters>b__7() +60
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(MethodInfo methodInfo, IDictionary`2 parameters, IList`1 filters) +451
System.Web.Mvc.ControllerActionInvoker.InvokeAction(String actionName, IDictionary`2 values) +235
System.Web.Mvc.Controller.Execute(ControllerContext controllerContext) +279
System.Web.Mvc.Controller.System.Web.Mvc.IController.Execute(ControllerContext controllerContext) +46
System.Web.Mvc.MvcHandler.ProcessRequest(HttpContextBase httpContext) +382
System.Web.Mvc.MvcHandler.ProcessRequest(HttpContext httpContext) +73
System.Web.Mvc.MvcHandler.System.Web.IHttpHandler.ProcessRequest(HttpContext httpContext) +46
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +358
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

COMMENTED ISSUE: Register always displays "This user already exists"

shahim — Wed, 04 Jun 2008 21:07:48 GMT

When trying to use Register through the application, I am receiving "This user already exists" regardless of what username I enter.
Comments: ** Comment from web user: shahim **

Yes, I see. This is because UserService.GetUser return guest user if specified user doesn't exists and Register method use GetUser for check user existence. Obviously any user registration failed with "This user already exists".

CREATED ISSUE: Register always displays "This user already exists"

ChanceUSC — Sun, 01 Jun 2008 16:20:31 GMT

When trying to use Register through the application, I am receiving "This user already exists" regardless of what username I enter.

Source code checked in

robconery — Sat, 31 May 2008 04:03:46 GMT

Plugged in StructureMap - w00t!

Source code checked in

robconery — Sat, 24 May 2008 01:15:50 GMT

Parts 11, 12, 13. Hooked up Mocking and DI, hooked up the shopping cart. Created UserSessionComponent, hooked up Login/Register routines.

Patch Uploaded

SimonCropp — Wed, 21 May 2008 11:36:16 GMT

SimonCropp has uploaded a patch.

Description:
a fe minor tweaks
-prefer == first instead of !=
-use "as" and check for null rather than double cast
-clean up some references
-remove some redundant usages of "this"
-use ExpectedException rather than "try catch" in tests

Source code checked in

robconery — Tue, 20 May 2008 02:38:30 GMT

Righting this ship - refactored out LazyList and optimized query calls. Re-added CartService and kept with existing pattern. Created SaveCart routine to persist cart without individual routines, keeping with the architectural pattern Refactored integration tests to make sure LinqToSql won't get mad

CREATED ISSUE: Missing File "cart.gif"

SimonCropp — Thu, 15 May 2008 02:08:53 GMT

J:\Code\CodePlex\mvcsamples-6024\Commerce.MVC\Commerce.MVC.Web\Content\Images\cart.gif

CREATED ISSUE: bin dir in source control?

TimBajz — Wed, 14 May 2008 14:01:21 GMT

Hi,

Should the mvcsamples\Commerce.MVC\Commerce.MVC.Web\bin dir be under source control?

Tim.

Source code checked in

robconery — Wed, 14 May 2008 06:41:05 GMT

Part 10 - re-added AssemblyInfo.cs.

COMMENTED ISSUE: Am i missing the adventure works assembly?

robconery — Wed, 14 May 2008 06:36:09 GMT

Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: CS0246: The type or namespace name 'AdventureWorks' could not be found (are you missing a using directive or an assembly reference?)

Source Error:

Line 17: public class ProfileCommon : System.Web.Profile.ProfileBase {
Line 18:
Line 19: public virtual AdventureWorks.Data.Address CurrentShippingAddress {
Line 20: get {
Line 21: return ((AdventureWorks.Data.Address)(this.GetPropertyValue("CurrentShippingAddress")));
Comments: ** Comment from web user: robconery **

oops - bad setting in web.config (copy/past issue). This is fixed

Source code checked in

robconery — Wed, 14 May 2008 06:35:29 GMT

Part 10 Update: Fixed weird AdventureWorks reference in web.config :)

CREATED ISSUE: Am i missing the adventure works assembly?

SimonCropp — Wed, 14 May 2008 05:37:46 GMT

CREATED ISSUE: AssemblyInfo.cs' could not be opened

SimonCropp — Wed, 14 May 2008 05:28:01 GMT

Error 2 Source file 'J:\Code\CodePlex\mvcsamples-6010\Commerce.MVC\Commerce.MVC.Web\Properties\AssemblyInfo.cs' could not be opened ('Unspecified error ') Commerce.MVC.Web

Source code checked in

robconery — Wed, 14 May 2008 03:11:39 GMT

Part 10: Cart refactor, implementing membership

Source code checked in

robconery — Thu, 08 May 2008 00:38:03 GMT

Part 9: Shopping Cart and SqlShoppingCartSpike

Source code checked in

robconery — Tue, 06 May 2008 18:44:10 GMT

Part 8: Adding missing files (sorry)

Source code checked in

robconery — Fri, 02 May 2008 22:08:21 GMT

Part 8: Updated with some refactoring - trying to fix proj file

Source code checked in

robconery — Fri, 02 May 2008 03:29:02 GMT

Part 8 - Demo time.