/// Fonction pour effectué la copie des fichiers et inscrire la note dans les document Autofab private void transfertImages_Click(object sender, RoutedEventArgs e) { string noProdval = "CO-" + noProd.Text; try { var ordredocument = (from d in db.DOCUMENTs where d.DOSEQ_REFERENCE == sequenceCommande && d.DONOM_TABLE == "COMMANDE" orderby d.DOORDRE descending select new { d.DOORDRE }).FirstOrDefault(); newOrdreDocNo = ordredocument.DOORDRE + 1; } catch (Exception) { newOrdreDocNo = 1; // aucun document dans commande Ordre = 1 } if (cPhoto.Count > 0 && sequenceCommande != 0) { bool copyValid = false; foreach (var item in cPhoto) { string subPath = @"\\cabanons00013\documentsautofab6\documents\COMMANDE\" + year + @"\" + noProdval + @"\"; // \\cabanons00013\documentsautofab6\documents\COMMANDE\2015\CO-000024 Directory.CreateDirectory(subPath); try { File.Copy(item.Photo, subPath + System.IO.Path.GetFileName(item.Name)); DOCUMENT docNew = new DOCUMENT(); docNew.DONOM_TABLE = "COMMANDE"; docNew.DOSEQ_REFERENCE = sequenceCommande; docNew.DOFICHIER = subPath + System.IO.Path.GetFileName(item.Name); docNew.DOORDRE = newOrdreDocNo; docNew.DODESC_P = "PHOTO INSTALLATION"; docNew.DODESC_S = "PHOTO INSTALLATION"; docNew.DONOTE = ""; docNew.DODATE = DateTime.Now; docNew.DOUSAGER = "PHOTO IMPORTER"; db.DOCUMENTs.InsertOnSubmit(docNew); db.SubmitChanges(); newOrdreDocNo += 1; //Incrémente le compteur copyValid = true; } catch (Exception) { MessageBox.Show(System.IO.Path.GetFileName(item.Name) + " Fichier déja existant dans le repertoire AutoFAB Image non transféré"); copyValid = false; } } if (copyValid) { MessageBox.Show("Image Transféré a AutoFAB6"); // Vide la selection apres le transfert cPhoto.Clear(); noProd.Text = ""; labelNomClient.Content = null; addl1.Content = null; addl2.Content = null; addl3.Content = null; installateur.Items.Clear(); updateEcran(); } } else { MessageBox.Show("Aucune image transféré"); } }
partial void UpdateDOCUMENT(DOCUMENT instance);
partial void DeleteDOCUMENT(DOCUMENT instance);
partial void InsertDOCUMENT(DOCUMENT instance);