public async Task UpdateUser(SecUsers user)
{
if (db != null)
{
try
{
SecUsers record = await db.SecUsers.FirstOrDefaultAsync(x => x.SecUserId == user.SecUserId);
if (record != null)
{
record.UserName = user.UserName;
record.Password = user.Password;
record.FirstName = user.FirstName;
record.LastName = user.LastName;
record.Email = user.Email;
record.PhoneNumber = user.PhoneNumber;
record.UpdatedOn = user.UpdatedOn;
}
//update that post
db.SecUsers.Update(record);
//Commit the transaction
await db.SaveChangesAsync();
}
catch (Exception ex)
{
Console.WriteLine("Exception: ", ex.StackTrace);
}
}
}
public async Task <IActionResult> CreateUser([FromBody] SecUsers model)
{
if (ModelState.IsValid)
{
try
{
model.Channel = "website";
model.Status = 1;
model.CreatedOn = DateFormatter.ConvertStringToDate(DateTime.Now.ToString("dd/MM/yyyy"));
var userId = await _userService.CreateUser(model);
if (userId > 0)
{
return(Ok(userId));
}
else
{
return(NotFound());
}
}
catch (Exception ex)
{
Console.WriteLine("Some Error AAcquired: " + ex.StackTrace);
return(BadRequest());
}
}
return(BadRequest());
}
public async Task <int> CreateUser(SecUsers users)
{
try
{
if (db != null)
{
//vmUser u = await (from p in db.SecUsers where p.CreatedBy == users.CreatedBy select new vmUser { Id = p.SecUserId}).FirstOrDefaultAsync();
//users.CreatedBy = u.Id;
await db.SecUsers.AddAsync(users);
int id = await db.SaveChangesAsync();
return(id);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
return(0);
}
public async Task <IActionResult> UpdateUser([FromBody] SecUsers model)
{
if (ModelState.IsValid)
{
try
{
model.UpdatedOn = UsersController.ConvertStringToDate(DateTime.Now.ToString("dd/MM/yyyy"));
await _userService.UpdateUser(model);
return(Ok());
}
catch (Exception ex)
{
if (ex.GetType().FullName == "Microsoft.EntityFrameworkCore.DbUpdateConcurrencyException")
{
return(NotFound());
}
return(BadRequest());
}
}
return(BadRequest());
}
