public user_share_file addFiles()
        {
            var newFile = new file()
            {
                name = "test222",
                type = 1,
                url  = "test222",
            };

            using (FileEntitiesFinal entities = new FileEntitiesFinal())
            {
                entities.Entry <file>(newFile).State = System.Data.Entity.EntityState.Added;
                entities.SaveChanges();
                entities.Entry(newFile);
                user_share_file newShare = new user_share_file()
                {
                    user_id = 2,
                    file_id = newFile.id,
                    code    = "1234"
                };
                entities.user_share_file.Add(newShare);
                entities.SaveChanges();


                return(newShare);
            }
        }
        public string testFile(string code)
        {
            FileEntitiesFinal entity = new FileEntitiesFinal();
            user_share_file   temp   = entity.user_share_file.Where(f => f.code.Equals(code)).FirstOrDefault();

            return(temp.code);
        }
 public bool isCodeExist(string code)
 {
     using (FileEntitiesFinal entity = new FileEntitiesFinal())
     {
         user_share_file user_Share_File = entity.user_share_file.Where(f => f.code == code).FirstOrDefault();
         return(user_Share_File != null);
     }
 }
        private file getFileUrl(string code)
        {
            file result = null;

            using (FileEntitiesFinal entity = new FileEntitiesFinal())
            {
                user_share_file tempFile = entity.user_share_file.Where(f => f.code.Equals(code)).FirstOrDefault();
                if (tempFile != null)
                {
                    result = tempFile.file;
                }
                else
                {
                    result = null;
                }
            }

            return(result);
        }
 public HttpResponseMessage getDownloadCode(int fileId)
 {
     using (FileEntitiesFinal entity = new FileEntitiesFinal())
     {
         var             userId          = HttpContext.Current.Session["id"];
         string          code            = "";
         user_share_file user_Share_File = entity.user_share_file.Where(u => u.file_id == fileId && u.user_id == (int)userId).FirstOrDefault();
         if (entity.file.Where(f => f.id == fileId).FirstOrDefault() == null)
         {
             return(Request.CreateResponse(HttpStatusCode.NotFound, "No such file"));
         }
         RandomCodeLib.CodeClass codeClass = new CodeClass();
         if (user_Share_File == null)
         {
             codeClass.getRandomCode(6, out code);
             while (isCodeExist(code))
             {
                 codeClass.getRandomCode(6, out code);
                 if (code.Length < 6)
                 {
                     return(Request.CreateResponse(HttpStatusCode.InternalServerError, "File to get the code"));
                 }
             }
             user_Share_File = new user_share_file {
                 user_id = (int)userId, file_id = fileId, code = code
             };
             entity.user_share_file.Add(user_Share_File);
             entity.SaveChangesAsync();
         }
         else
         {
             code = user_Share_File.code;
         }
         return(Request.CreateResponse(HttpStatusCode.OK, code));
     }
 }