/// <summary> /// Appends UserProfile-specific parameters to the specificied SqlCommand. /// </summary> /// <param name="command">SqlCommand to be executed.</param> /// <param name="alert">Instance of UserProfile class</param> /// <param name="action">Database action type (select, insert, update, delete).</param> public static void AddEntityParameters(this SqlCommand command, UserProfile userProfile, DbActionType action) { command.AddCommonParameters(userProfile.Id, action); command.Parameters.Add("@email", SqlDbType.NVarChar).Value = userProfile.Name.ToDbValue(); command.Parameters.Add("@password", SqlDbType.NVarChar).Value = userProfile.Password.ToDbValue(); command.Parameters.Add("@password_question", SqlDbType.NVarChar).Value = userProfile.PasswordQuestion.ToDbValue(); command.Parameters.Add("@password_answer", SqlDbType.NVarChar).Value = userProfile.PasswordAnswer.ToDbValue(); command.Parameters.Add("@first_name", SqlDbType.NVarChar).Value = userProfile.FirstName.ToDbValue(); command.Parameters.Add("@last_name", SqlDbType.NVarChar).Value = userProfile.LastName.ToDbValue(); command.Parameters.Add("@comment", SqlDbType.NVarChar).Value = userProfile.Comment.ToDbValue(); command.Parameters.Add("@is_approved", SqlDbType.Bit).Value = userProfile.IsApproved; command.Parameters.Add("@current_time_utc", SqlDbType.DateTime).Value = DateTime.UtcNow; }
public static int CreateUser(UserProfile entity) { var res = -1; using (var holder = SqlConnectionHelper.GetConnection()) { var cmd = holder.Connection.CreateSPCommand("user_create"); try { cmd.AddEntityParameters(entity, DbActionType.Insert); cmd.ExecuteNonQuery(); entity.Id = cmd.GetRowIdParameter(); res = cmd.GetReturnParameter(); } catch (SqlException e) { cmd.AddDetailsToException(e); throw; } } return res; }
private static AccountController GetAccountController(UserProfile user = null) { var membershipRepository = new Mock<MembershipRepository>(); var cookieContainer = new Mock<ICookieContainer>(); cookieContainer.Setup(c => c.SetValue(It.IsAny<string>(), It.IsAny<object>(), It.IsAny<DateTime>())); cookieContainer.Setup(c => c.SetAuthCookie(It.IsAny<string>(), It.IsAny<string>(), It.IsAny<bool>())); membershipRepository.Setup(m => m.GetUser(It.IsAny<string>(), It.IsAny<string>())).Returns(user); IFormsAuthentication formsAuth = new MockFormsAuthenticationService(); var contextBase = MvcMockHelpers.FakeHttpContext(); // new MockHttpContext(); var controller = new AccountController( cookieContainer.Object, formsAuth, membershipRepository.Object); controller.ControllerContext = new ControllerContext(contextBase, new RouteData(), controller); controller.Url = new UrlHelper(new RequestContext(contextBase, new RouteData()), new RouteCollection()); return controller; }
public static UserProfile CreateUser(string email, string password, string default_company_name, string default_account_name, string approveCode) { UserProfile res = new UserProfile(email, password, approveCode); using (var holder = SqlConnectionHelper.GetConnection()) { var cmd = holder.Connection.CreateSPCommand("user_signin"); try { cmd.Parameters.Add("@id", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Parameters.Add("@email", SqlDbType.NVarChar).Value = email; cmd.Parameters.Add("@password", SqlDbType.NVarChar).Value = password; cmd.Parameters.Add("@default_company_name", SqlDbType.NVarChar).Value = default_company_name; cmd.Parameters.Add("@default_account_name", SqlDbType.NVarChar).Value = default_account_name; cmd.Parameters.Add("@current_time_utc", SqlDbType.DateTime).Value = DateTime.UtcNow; cmd.Parameters.Add("@approve_code", SqlDbType.NVarChar).Value = approveCode; cmd.ExecuteNonQuery(); res.Id = cmd.GetRowIdParameter(); } catch (SqlException e) { cmd.AddDetailsToException(e); throw; } } return res; }
private static TransactionsController GetController() { var reps = new Mock<TransactionsRepository>(); reps.Setup(m => m.GetTransactions(It.IsAny<int?>())).Returns<int?>(p => GetTestTrans(p)); var car_rep = new Mock<CategoriesRepository>(); car_rep.Setup(m => m.GetAll(It.IsAny<int?>())).Returns<int?>(p => GetTestCats(p)); var tag_rep = new Mock<TagsRepository>(); tag_rep.Setup(m => m.GetAll(It.IsAny<int?>())).Returns<int?>(p => GetTestTags(p)); var controller = new TransactionsController(reps.Object, car_rep.Object, tag_rep.Object); //set user and def company var user = new UserProfile(); user.DefaultCompany = 1; var comps = new List<Company>(); comps.Add(new Company() { Id = 1 }); user.Companies = comps; controller.CurrentUser = user; return controller; }
public virtual string SetSessionForUser(UserProfile profile) { // generate session key var cId = Guid.NewGuid().ToString(); new CacheWrapper().Set(cId, profile, true, null); return cId; }