public async Task <IActionResult> Post([FromBody] MagazinesViewModel row) { var user = await GetCurrentUser(); var result = (dynamic)null; int mode = 0; if (row != null) { var parameters = new SqlParameter[] { new SqlParameter("@p1", DBNull.Value), new SqlParameter("@p2", user.Id), new SqlParameter("@p3", row.OperationsID), new SqlParameter("@p4", row.NumberDocument), new SqlParameter("@p5", row.DateDocument.ToString("d")), new SqlParameter("@p6", user.UserName), new SqlParameter("@p7", mode) }; try { result = dbContext.ReturnValue.FromSql( "exec set_Magazines @p1, @p2, @p3, @p4, @p5, @p6, @p7", parameters).ToList(); } catch { } if (result != null) { MapperViewModels.returnValueViewModel = Mapper.Map <IEnumerable <ReturnValue>, IEnumerable <ReturnValueViewModel> >(result); var rows = from a in MapperViewModels.returnValueViewModel select a; int Id = 0; if (rows.Count() > 0) { Id = rows.FirstOrDefault().Id; } return(GetRow(Id)); } } // return a generic HTTP Status 500 (Not Found) if the client payload is invalid. return(new StatusCodeResult(500)); }
public async Task <IActionResult> Put(int id, [FromBody] MagazinesViewModel row) { var user = await GetCurrentUser(); var result = (dynamic)null; int mode = 0; if (row != null) { var parameters = new SqlParameter[] { new SqlParameter("@p1", row.Id), new SqlParameter("@p2", user.Id), new SqlParameter("@p3", row.OperationsID), new SqlParameter("@p4", row.NumberDocument), new SqlParameter("@p5", row.DateDocument.ToString("d")), new SqlParameter("@p6", user.UserName), new SqlParameter("@p7", mode) }; try { result = dbContext.ReturnValue.FromSql( "exec set_Magazines @p1, @p2, @p3, @p4, @p5, @p6, @p7", parameters).ToList(); } catch { } if (result != null) { MapperViewModels.returnValueViewModel = Mapper.Map <IEnumerable <ReturnValue>, IEnumerable <ReturnValueViewModel> >(result); var rows = from a in MapperViewModels.returnValueViewModel select a; int Id = 0; if (rows.Count() > 0) { Id = rows.FirstOrDefault().Id; } return(GetRow(Id)); } } // return a HTTP Status 404 (Not Found) if we couldn't find a suitable item. return(NotFound(new { Error = String.Format("ID {0} has not been found", id) })); }