/// <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);
}