public HttpResponseMessage Delete(int id)
        {
            Spartane_File varSpartan_File = this.service.GetByKey(id, false);
            bool          result          = false;

            if (varSpartan_File == null)
            {
                return(Request.CreateResponse(HttpStatusCode.NotFound));
            }

            try
            {
                result = this.service.Delete(id);//, globalData, dataReference);
                if (!Directory.Exists(fileSaveLocation + "\\" + id))
                {
                    Directory.Delete(fileSaveLocation + "\\" + id);
                }
            }
            catch (ServiceException ex)
            {
                return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
            }

            return(Request.CreateResponse(HttpStatusCode.OK, result));
        }
Пример #2
0
        public long Update(Spartane_File 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 Spartane_FileModel GetModelFromSpartaneFile(Spartane_File file)
 {
     if (file != null)
     {
         return(new Spartane_FileModel()
         {
             Date_Time = file.Date_Time,
             Description = file.Description,
             File = null,
             File_Id = file.File_Id,
             File_Size = file.File_Size
         });
     }
     else
     {
         return(new Spartane_FileModel());
     }
 }
        public HttpResponseMessage Put(int id, Spartane_File 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));
            }
        }