public void Insert_A_New_User() { var user = new User { Email = "*****@*****.**", Password = "******", PIN = "04.137.077/0007-27", ReceivePromotions = false, CallSpecialist = true, CompanyName = "Netbiis", Adress = new Adress { City = "s. jose do rio preto", Number = 1245, State = "sp", StreetName = "portal", Suite = "abc", Zipcode = "1234" }, Contact = new Contact { MainContact = "Talita", Phone = "22 2222 2222", Position = "s" } }; var rows = _userRepository.Save(user); Assert.AreEqual(rows, 1); }
public int Save(User user) { var connectionString = _ctx.Database.Connection.ConnectionString; var numberOfRow = 0; using (var con = new SqlConnection(connectionString)) { try { con.Open(); var parameters = new[] { new SqlParameter("@PIN", SqlDbType.Text) { Value = user.PIN }, new SqlParameter("@CompanyName", SqlDbType.Text){ Value = user.CompanyName }, new SqlParameter("@Email", SqlDbType.Text){ Value = user.Email }, new SqlParameter("@Password", SqlDbType.Text){ Value = user.Password }, new SqlParameter("@ReceivePromotions", SqlDbType.Bit){ SqlValue = user.ReceivePromotions }, new SqlParameter("@CallSpecialist", SqlDbType.Bit){ SqlValue = user.CallSpecialist }, new SqlParameter("@Number", SqlDbType.Int){ SqlValue = user.Adress.Number }, new SqlParameter("@StreetName", SqlDbType.Text){ Value = user.Adress.StreetName }, new SqlParameter("@Suite", SqlDbType.Text){ Value = user.Adress.Suite }, new SqlParameter("@City", SqlDbType.Text){ Value = user.Adress.City }, new SqlParameter("@State", SqlDbType.Text){ Value = user.Adress.State }, new SqlParameter("@Zipcode", SqlDbType.Text){ Value = user.Adress.Zipcode }, new SqlParameter("@MainContact", SqlDbType.Text){ Value = user.Contact.MainContact }, new SqlParameter("@Position", SqlDbType.Text){ Value = user.Contact.Position }, new SqlParameter("@Phone", SqlDbType.Text){ Value = user.Contact.Phone } }; var command = new SqlCommand("InsertUser", con); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddRange(parameters); numberOfRow= command.ExecuteNonQuery(); } catch (Exception e) { throw e; } finally { con.Close(); } } return numberOfRow; }
public ActionResult Index(User user) { _userRepository.Save(user); return View(); }