/// <summary> /// 100データを作成します /// </summary> public async Task <IActionResult> Create100Data() { UserDataModel usermodel = new UserDataModel(); Random ran = new Random(); String letters = "abcdefghijklmnopqrstuvwxyz"; int length = 8; int maxid = 0; String randomName = ""; for (int j = 0; j < 100; j++) { randomName = ""; var rec = _context.Users.FirstOrDefault(); if (rec == null) { maxid = 0; } else { maxid = _context.Users.Max(p => p.UserId); } for (int i = 0; i < length; i++) { int c = ran.Next(26); randomName = randomName + letters.ElementAt(c); } usermodel.UserId = maxid + 1; usermodel.NumberOfWins = 0; usermodel.NumberOfDefeats = 0; usermodel.NumberOfDraws = 0; usermodel.UserName = randomName; _context.Add(usermodel); _context.Database.OpenConnection(); try { _context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Users ON"); _context.SaveChanges(); _context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Users OFF"); } finally { _context.Database.CloseConnection(); } } await _context.SaveChangesAsync(); return(RedirectToAction("Index")); }
public async Task <IActionResult> Create([Bind("UserId,Name,Gender,DateOfBirth")] PersonalInfo personalInfo) { if (ModelState.IsValid) { _context.Add(personalInfo); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(personalInfo)); }
public async Task <ActionResult <User> > Create([FromBody] User user) { if (ModelState.IsValid) { _context.Add(user); await _context.SaveChangesAsync(); return(CreatedAtAction(nameof(Create), user)); } return(user); }
public async Task <ActionResult <Transaction> > Create([FromBody] Transaction transaction) { if (ModelState.IsValid) { _context.Add(transaction); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(transaction); }
public async Task <ActionResult <Wallet> > Create([FromBody] Wallet wallet) { if (ModelState.IsValid) { _context.Add(wallet); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(wallet); }
public async Task <IActionResult> Create([Bind("CardId,CardNumber,MailingAddress,CreditLimt,UserId")] CreditCard creditCard) { if (ModelState.IsValid) { _context.Add(creditCard); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } var errors = ModelState.Values.SelectMany(v => v.Errors); ViewData["UserId"] = new SelectList(_context.User, "UserId", "Name", creditCard.UserId); return(View(creditCard)); }
public async Task <IActionResult> Register([FromBody] User user) { try { //Check if user already exists var alreadyExists = await _context.users .FromSqlRaw("SELECT * FROM users WHERE users.email = {0}", user.email).ToListAsync(); if (alreadyExists.Count() > 0) { var errorResponse = new { error = "User already exists.", ok = false }; return(Json(errorResponse)); } else { Console.WriteLine("Inserting a new User {0}", user.email); User newUser = new User(); DateTime currentDateTime = DateTime.Now; newUser = user; newUser.created = currentDateTime; newUser.password = BC.HashPassword(user.password); _context.Add(newUser); _context.SaveChanges(); return(Json(newUser)); } } catch (Exception e) { //Error Console.WriteLine("Error Stack {0}", e.Message); Console.WriteLine("Error Stack {0}", e); var errorResponse = new { error = true, ok = false, errorMessage = e.Message }; return(Json(errorResponse)); } }
public bool Adduser(UserProfile model) { try { var user = Context.Set <UserProfile>().Where(x => x.Email == model.Email).FirstOrDefault(); if (user != null) { return(false); } Context.Add(model); Context.SaveChanges(); return(true); } catch (Exception) { throw; } }
// POST: api/Users public HttpResponseMessage Post([FromBody] User user) { try { int result = UserDBContext.Add(user); if (result < 0) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Failed to create new user")); } //result should contain the Id of the user that was just POSTed user.Id = result; var message = Request.CreateResponse(HttpStatusCode.Created, user); message.Headers.Location = new Uri(Request.RequestUri + user.Id.ToString()); return(message); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public async Task <User> Handle(PostUserQuery request, CancellationToken cancellationToken) { User newRequest; if (request == null) { return(null); } else { userDBContext.Add(newRequest = new User { Id = request.NewUsers.Id, FirstName = request.NewUsers.FirstName, LastName = request.NewUsers.LastName, DateOfBirth = request.NewUsers.DateOfBirth, IsActive = true, IsDeleted = false }); } userDBContext.SaveChanges(); return(newRequest); }