public object EditStorages(StoragesViewModel model)
{
var param = new List <SqlParameter>
{
new SqlParameter("@id", SqlDbType.UniqueIdentifier, 37, model.Id.ToString()),
new SqlParameter("@title", SqlDbType.NVarChar, Int32.MaxValue, model.Title),
new SqlParameter("@description", SqlDbType.NVarChar, 50, model.Description),
new SqlParameter("@isDefault", SqlDbType.Bit, 1, Convert.ToBoolean(model.IsDefault).ToString()),
new SqlParameter("@dateTime", SqlDbType.Int, 10, DisplayValues.ConvertToTimestamp(DateTime.Now).ToString()),
new SqlParameter("@userId", SqlDbType.UniqueIdentifier, 37, _userManager.GetUserId(_user.HttpContext.User))
};
InputOutputInit(param);
try
{
if (!string.IsNullOrEmpty(model.Title))
{
_db.Database.ExecuteSqlCommand($"[dbo].[root_sp_EDIT_Storages] {_input} @output = @output OUT", _output);
}
return(_output.Value);
}
catch (Exception ex)
{
return($"0//{ex.Message}");
}
}
public async void AddStoragesReturnsAddStorage()
{
var controller = new ApiController(_edit.Object);
var storage = new StoragesViewModel
{
Id = Guid.NewGuid(),
Title = "Test",
Description = "Test",
DateTime = DisplayValues.ConvertToTimestamp(DateTime.Now),
};
if (string.IsNullOrEmpty(storage.Title))
{
controller.ModelState.AddModelError("Title", "Required");
}
if (string.IsNullOrEmpty(storage.Description))
{
controller.ModelState.AddModelError("Description", "Required");
}
if (storage.DateTime == 0)
{
controller.ModelState.AddModelError("DateTime", "Required");
}
var result = await controller.EditStorages(storage);
var okResult = Assert.IsType <OkObjectResult>(result);
Assert.NotNull(okResult);
_edit.Verify(i => i.EditStorages(storage));
}
public async Task <IActionResult> DeleteStorages(StoragesViewModel model)
{
var query = _edit.DeleteStorages(model);
if (await ErrorHeplers.ModelState(ModelState, query))
{
return(await Task.Run(() => Ok(query.ToString().Split("//")[1])));
}
return(await Task.Run(() => BadRequest(ModelState)));
}
public object DeleteStorages(StoragesViewModel model)
{
var param = new List <SqlParameter>
{
new SqlParameter("@id", SqlDbType.UniqueIdentifier, 37, model.Id.ToString()),
new SqlParameter("@title", SqlDbType.NVarChar, Int32.MaxValue, model.Title),
new SqlParameter("@dateTime", SqlDbType.Int, 10, DisplayValues.ConvertToTimestamp(DateTime.UtcNow).ToString()),
new SqlParameter("@flag", SqlDbType.Int, 10, 0.ToString()),
new SqlParameter("@userId", SqlDbType.UniqueIdentifier, 37,
_userManager.GetUserId(_user.HttpContext.User))
};
InputOutputInit(param);
try
{
_db.Database.ExecuteSqlCommand($"[dbo].[root_sp_EDIT_Storages] {_input} @output = @output OUT", _output);
return(_output.Value);
}
catch (Exception ex)
{
return($"0//{ex.Message}");
}
}
public async Task <IActionResult> EditStorages(StoragesViewModel model)
{
return(await Task.Run(() => Ok(_edit.EditStorages(model))));
}
public async Task <IActionResult> EditStorages(StoragesViewModel model)
{
return(await Task.Run(() => PartialView(_db.GetStorages(model.Id))));
}
