public async Task <ActionResult <User> > PostUser(UserInternal user)
{
if (user is null ||
!user.Currencies.Any())
{
return(BadRequest());
}
var _currencies = new List <Currency>();
foreach (var c in user.Currencies)
{
if (!Enum.IsDefined(typeof(CurrencyEnum), c.CurrencyCode) ||
c.Ammount < 0)
{
return(BadRequest());
}
_currencies.Add(new Currency()
{
CurrencyCode = c.CurrencyCode, Ammount = c.Ammount
});
}
var _user = new User()
{
Name = user.Name,
Currencies = _currencies
};
_context.Users.Add(_user);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetUser", new { id = _user.Id }, user));
}
public IActionResult DeleteUserInternal(int id, UserInternal UserInternal)
{
try
{
_IInternal.DeleteUserInternal(UserInternal.Id);
return(RedirectToAction("UserInternal"));
}
catch
{
return(View());
}
}
public IActionResult EditUserInternal(int id, UserInternal UserInternal)
{
try
{
_IInternal.UpdateUserInternal(UserInternal);
return(RedirectToAction("UserInternal"));
}
catch
{
return(View());
}
}
public IActionResult CreateUserInternal(UserInternal UserInternal)
{
try
{
if (ModelState.IsValid)
{
_IInternal.InsertUserInternal(UserInternal);
return(RedirectToAction("List"));
}
return(View(UserInternal));
}
catch (Exception ex)
{
return(View());
}
}
public int InsertUserInternal(UserInternal UserInternal)
{
using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString))
{
con.Open();
SqlTransaction sqltrans = con.BeginTransaction();
var param = new DynamicParameters();
param.Add("@Id", UserInternal.Id);
param.Add("@UserId", UserInternal.UserId);
param.Add("@InternalId", UserInternal.InternalId);
var result = con.Execute("InsertUpdateUserInternal", param, sqltrans, 0, System.Data.CommandType.StoredProcedure);
if (result > 0)
{
sqltrans.Commit();
}
else
{
sqltrans.Rollback();
}
return(result);
}
}
