public async Task <RequestModel> Authorization([FromForm, SwaggerParameter("Login of user", Required = true)] string login, [FromForm, SwaggerParameter("Orginal password of user", Required = true)] string password)
{
if (login.IsNullOrEmpty() || password.IsNullOrEmpty())
{
return(await RequestModel.NotAccessAsync());
}
var user = _context.Users.FirstOrDefault(u => u.Login == login && u.HashPassword == Encryptor.SH1Hash(password));
if (user == null)
{
return(await RequestModel.NotAccessAsync());
}
var(accessToken, refreshToken, hashToken) = await GenerateToken(user : user);
user.Token = hashToken;
user.RefreshToken = refreshToken;
user.LastOnline = DateTime.Now;
_context.Update(user);
await _context.SaveChangesAsync();
var authInfo = new { accessToken, refreshToken };
return(await RequestModel.SuccessAsync(authInfo));
}
/// <summary>
/// 添加用户
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public async ValueTask <bool> AddUserAsync(UserInfo user)
{
user.Id = Guid.NewGuid();
user.Dr = true;
user.AddTime = DateTime.Now;
user.UpdateTime = DateTime.Now;
await _context.UserInfos.AddAsync(user);
return(await _context.SaveChangesAsync() >= 0);
}
public async Task <IActionResult> Create([Bind("ID,company,title,job_number,last_checked,last_updated,date_applied,status,notes,interview,rejected,city,state,country")] JobsModel jobsModel)
{
if (ModelState.IsValid)
{
_context.Add(jobsModel);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(jobsModel));
}
public async Task <ActionResult> Create([Bind(Include = "Id,Name,Price")] Job job)
{
if (ModelState.IsValid)
{
job.Id = Guid.NewGuid();
db.Jobs.Add(job);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(job));
}
private async Task <JobsContext> BuildJobsContext()
{
var conn = new SqliteConnection("Data Source=:memory:");
await conn.OpenAsync();
var options = new DbContextOptionsBuilder <JobsContext>()
.UseSqlite(conn)
.Options;
var context = new JobsContext(options);
await context.Database.EnsureCreatedAsync();
// clear
context.Jobs.RemoveRange(context.Jobs);
// dummy jobs
await context.Jobs.AddRangeAsync(new[]
{
new Job {
JobId = 1, Name = "job 1"
},
new Job {
JobId = 2, Name = "job 2"
},
new Job {
JobId = 3, Name = "job 3"
},
});
await context.SaveChangesAsync();
return(context);
}
// PUT: odata/PUR010(5)
public async Task <IHttpActionResult> Put([FromODataUri] Guid key, Delta <PUR010> patch)
{
Validate(patch.GetEntity());
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
PUR010 pUR010 = await db.PUR010.FindAsync(key);
if (pUR010 == null)
{
return(NotFound());
}
patch.Put(pUR010);
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PUR010Exists(key))
{
return(NotFound());
}
else
{
throw;
}
}
return(Updated(pUR010));
}
/// <summary/>
public async Task Save()
{
await _dbContext.SaveChangesAsync();
}
