public void RemoveAllRelations(SendLetter Old)
 {
     //Add to temp
     DBC.Set <SendLetterFile>().RemoveRange(Old.sendLetterFiles);
     DBC.Set <SendAppendage>().RemoveRange(Old.Appendages);
     SendAppendage df = new SendAppendage();
 }
        public void UpdateSendLetterAppendages(SendLetter sendLetter,
                                               List <HttpPostedFileBase> fileUploadAppendages, List <Guid> AppendagesID)
        {
            if (sendLetter.Appendages != null)
            {
                List <SendAppendage> deletedList = new List <SendAppendage>();
                foreach (var item in sendLetter.Appendages.ToList())
                {
                    if (AppendagesID.All(x => x != item.Id))
                    {
                        deletedList.Add(item);
                    }
                }

                //Delete Items
                var dbSetremovefiles = DBC.Set <SendAppendage>();
                foreach (var item in deletedList)
                {
                    dbSetremovefiles.Remove(item);
                }
            }

            int i = 0;

            foreach (var item in fileUploadAppendages)
            {
                if (item != null && item.ContentLength > 0)
                {
                    var           target        = new MemoryStream();
                    SendAppendage sendAppendage = new SendAppendage();
                    item.InputStream.CopyTo(target);
                    sendAppendage.File = new ArchiveFile
                    {
                        Content     = target.ToArray(),
                        Name        = item.FileName,
                        ContentType = item.ContentType
                    };
                    try
                    {
                        sendLetter.Appendages[i] = sendAppendage;
                    }
                    catch (Exception)
                    {
                        sendLetter.Appendages.Add(sendAppendage);
                    }
                }
                i++;
            }
        }
        //[ValidateAntiForgeryToken]
        public ActionResult Add(AddOutgoingViewModel outgoingLettersViewModel)
        {
            SendLetterManager sendLetterManager = new SendLetterManager();

            //Add letter files
            if (outgoingLettersViewModel.fileUploadLetters != null && outgoingLettersViewModel.fileUploadLetters.Count > 0)
            {
                outgoingLettersViewModel.sendLetter.sendLetterFiles = new List <SendLetterFile>(); //

                foreach (var item in outgoingLettersViewModel.fileUploadLetters)
                {
                    if (item == null || item.ContentLength <= 0)
                    {
                        continue;
                    }
                    var            target         = new MemoryStream();
                    SendLetterFile sendLetterFile = new SendLetterFile();
                    item.InputStream.CopyTo(target);
                    sendLetterFile.File = new ArchiveFile
                    {
                        Content     = target.ToArray(),
                        Name        = item.FileName,
                        ContentType = item.ContentType
                    };
                    outgoingLettersViewModel.sendLetter.sendLetterFiles.Add(sendLetterFile);
                }
            }

            //Add letter appendages
            if (outgoingLettersViewModel.fileUploadAppendages != null && outgoingLettersViewModel.fileUploadAppendages.Count > 0)
            {
                outgoingLettersViewModel.sendLetter.Appendages = new List <SendAppendage>();
                foreach (var item in outgoingLettersViewModel.fileUploadAppendages)
                {
                    if (item == null || item.ContentLength <= 0)
                    {
                        continue;
                    }
                    var target        = new MemoryStream();
                    var sendAppendage = new SendAppendage();
                    item.InputStream.CopyTo(target);
                    sendAppendage.File = new ArchiveFile
                    {
                        Content     = target.ToArray(),
                        Name        = item.FileName,
                        ContentType = item.ContentType
                    };
                    outgoingLettersViewModel.sendLetter.Appendages.Add(sendAppendage);
                }
            }

            //Date Times
            if (!string.IsNullOrEmpty(outgoingLettersViewModel.LetterDateTime))
            {
                outgoingLettersViewModel.sendLetter.LetterDateTime =
                    outgoingLettersViewModel.LetterDateTime.ToGeorgianDateTime();
            }
            outgoingLettersViewModel.sendLetter.ArchiveDateTime    = DateTime.Now;
            outgoingLettersViewModel.sendLetter.LastModifyDateTime = DateTime.Now;
            //outgoingLettersViewModel.sendLetter.User = Sessions.CurrentUser;
            sendLetterManager.AddUser(outgoingLettersViewModel.sendLetter, new Guid(User.Identity.Name));


            //Set Parent Letter
            sendLetterManager.AddParent(outgoingLettersViewModel.sendLetter, outgoingLettersViewModel.ParentletterId);
            //Add organization , post and person
            if (outgoingLettersViewModel.PersonGuid != Guid.Empty || outgoingLettersViewModel.OrganizationGuid != Guid.Empty)
            {
                sendLetterManager.AddReciever(outgoingLettersViewModel.sendLetter, outgoingLettersViewModel.OrganizationGuid, outgoingLettersViewModel.PersonGuid, outgoingLettersViewModel.PostGuid);
            }
            //Add department , post and employee
            if (outgoingLettersViewModel.EmployeeGuid != Guid.Empty || outgoingLettersViewModel.DepartmentGuid != Guid.Empty)
            {
                sendLetterManager.AddSenderEmployee(outgoingLettersViewModel.sendLetter, outgoingLettersViewModel.DepartmentGuid, outgoingLettersViewModel.EmployeeGuid, outgoingLettersViewModel.DepartmentPostGuid);
            }

            //set rowNumber Logic
            outgoingLettersViewModel.sendLetter.RowNumber = outgoingLettersViewModel.autoRowNumber ? sendLetterManager.AutoRowNumber(outgoingLettersViewModel.sendLetter.SenderEmployee?.Department) : outgoingLettersViewModel.RowNumber;

            //Add cases
            if (outgoingLettersViewModel.SelectedCasesGuid != null && outgoingLettersViewModel.SelectedCasesGuid.Count > 0)
            {
                sendLetterManager.AddCases(outgoingLettersViewModel.sendLetter, outgoingLettersViewModel.SelectedCasesGuid);
            }


            //Start Processing Files and Appendages to Save them as pdf
            sendLetterManager.GeneratePDF(outgoingLettersViewModel.sendLetter, outgoingLettersViewModel.LetterTemplate);
            sendLetterManager.Add(outgoingLettersViewModel.sendLetter);
            sendLetterManager.saveChanges();



            return(RedirectToAction("Index"));
        }