public static int InsertUserDataItem(UserDataAddRequest model, string UserId) { var id = 0; DataProvider.ExecuteNonQuery(GetConnection, "dbo.UserData_Insert" , inputParamMapper : delegate(SqlParameterCollection AddUserData) { AddUserData.AddWithValue("@FirstName", model.FirstName); AddUserData.AddWithValue("@LastName", model.LastName); AddUserData.AddWithValue("@PhoneNumber", model.PhoneNumber); AddUserData.AddWithValue("@UserId", UserId); SqlParameter p = new SqlParameter("@Id", System.Data.SqlDbType.Int); p.Direction = System.Data.ParameterDirection.Output; AddUserData.Add(p); }, returnParameters : delegate(SqlParameterCollection param) { int.TryParse(param["@Id"].Value.ToString(), out id); }); return(id); }
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, IHostingEnvironment env, ApplicationDbContext context, RoleManager <ApplicationRole> roleManager, UserManager <ApplicationUser> userManager) { if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); app.UseDatabaseErrorPage(); } else { app.UseExceptionHandler("/Home/Error"); app.UseHsts(); } app.UseHttpsRedirection(); app.UseStaticFiles(); app.UseCookiePolicy(); app.UseAuthentication(); app.UseMvc(routes => { routes.MapRoute( name: "default", template: "{controller=Home}/{action=Index}/{id?}"); //this is another routing to completely separated page routes.MapRoute( name: "customRoute", template: "customRoute/{controller}/{action}/{id?}"); }); AddUserData.Initialize(context, userManager, roleManager).Wait(); }