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