public long Update(Spartane.Core.Classes.SpartaneFile.SpartaneFile entity)
{
long rta = 0;
try
{
var padreId = _dataProvider.GetParameter();
padreId.ParameterName = "FileId";
padreId.DbType = DbType.Int64;
padreId.Value = entity.File_Id;
var padreFileName = _dataProvider.GetParameter();
padreFileName.ParameterName = "File_Name";
padreFileName.DbType = DbType.String;
padreFileName.Value = entity.File_Name;
var padreFileSize = _dataProvider.GetParameter();
padreFileSize.ParameterName = "File_Size";
padreFileSize.DbType = DbType.Int64;
padreFileSize.Value = entity.File_Size == entity.File.Length ? entity.File_Size : entity.File.Length;
var padreFile = _dataProvider.GetParameter();
padreFile.ParameterName = "File";
padreFile.DbType = DbType.Binary;
padreFile.Value = entity.File;
//padreFile.Size = entity.File_Size == entity.File.Length ? entity.File_Size : entity.File.Length;
var empEntity =
_dbContext.ExecuteStoredProcedureList <Spartane.Core.Classes.StoredProcedure.sp_UpdateSpartaneFile>(
"sp_UpdateSpartaneFile", padreId, padreFileName,
padreFileSize, padreFile).FirstOrDefault();
if (empEntity != null)
{
rta = Convert.ToInt64(empEntity.FileId);
}
}
catch (ExceptionBase ex)
{
throw ex;
}
catch (Exception ex)
{
throw new ServiceException(ex.Message, ex);
}
return(rta);
}
public HttpResponseMessage Delete(int id)
{
Spartane.Core.Classes.SpartaneFile.SpartaneFile varSpartaneFile = this.service.GetByKey(id, false);
bool result = false;
if (varSpartaneFile == null)
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
try
{
result = this.service.Delete(id);//, globalData, dataReference);
}
catch (ServiceException ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
}
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
public HttpResponseMessage Put(int id, Spartane.Core.Classes.SpartaneFile.SpartaneFile varSpartaneFile)
{
if (ModelState.IsValid && id == varSpartaneFile.File_Id)
{
long data = -1;
try
{
data = this.service.Update(varSpartaneFile);//, globalData, dataReference);
}
catch (ServiceException ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
}
return(Request.CreateResponse(HttpStatusCode.OK, data, Configuration.Formatters.JsonFormatter));
}
else
{
var errors = ModelState.Values.SelectMany(v => v.Errors).Select(error => error.ErrorMessage);
return(Request.CreateResponse(HttpStatusCode.BadRequest, errors));
}
}
