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