public void DoWriteFirmannummer() { try { using (var db = new SteinbachEntities()) { var query = from f in db.firmen where f.istFirma == 1 select new { f.KdNr, f.name }; foreach (var item in query) { var project = from p in db.projekte where p.firmenname == item.name select p; foreach (var pro in project) { pro.FirmenNr = item.KdNr; } } db.SaveChanges(); } } catch (Exception ex) { System.Windows.MessageBox.Show(ErrorMethods.GetExceptionMessageInfo(ex)); } }
private bool SaveChanges() { try { //if (this.KalkulationDetailView.IsEditingItem) //{ // this.KalkulationDetailView.CommitEdit(); //} //if (this.KalkulationDetailView.IsAddingNew) //{ // this.KalkulationDetailView.CommitNew(); //} var om = this.db.ObjectStateManager.GetObjectStateEntries(System.Data.EntityState.Modified | System.Data.EntityState.Added); foreach (var o in om) { if (o.Entity is kalkulationstabelle) { var p = (kalkulationstabelle)o.Entity; if (p.EntityState == System.Data.EntityState.Added || p.EntityState == System.Data.EntityState.Modified) { if (this.txtProjektnummer.Text == string.Empty) { MessageBox.Show("Es muss eine Projektnummer eingegeben werden"); return(false); } } } } db.SaveChanges(); //db.Dispose(); return(true); } catch (Exception ex) { MessageBox.Show(ErrorMethods.GetExceptionMessageInfo(ex)); return(false); } }
//F:\VERKAUF\BR\Aufträge\2012\E-Teile\120158-S, Tender Donau\Auftrag\Kommerziell //BR 100031-S-E R1 //100031-S-E Eilbek public CallRechnung(string RNr, DateTime Datum, string SchiffName, string Firma, string Projektnummer, string LandSchiff = "") { try { string kurzname = string.Empty; string pfad = string.Empty; string pfadDetail = string.Empty; string year = Datum.ToString("yyyy"); string Folder1 = string.Empty; DirectoryInfo foRechnungen; using (DAL.SteinbachEntities db = new DAL.SteinbachEntities()) { kurzname = db.firmen.Where(n => n.name == Firma).Single().kurzname; if (LandSchiff != "") { pfad = db.config.Where(i => i.mkey == "PfadSIRechnungenJets").Single().value; Folder1 = string.Format(@pfad, kurzname, year, LandSchiff); } else { pfad = db.config.Where(i => i.mkey == "PfadSIRechnungen").Single().value; Folder1 = string.Format(@pfad, kurzname, year); } pfadDetail = db.config.Where(i => i.mkey == "PfadSIRechnungenDetail").Single().value; } DirectoryInfo fo1 = new DirectoryInfo(Folder1); DirectoryInfo[] fo2 = fo1.GetDirectories(string.Format("*{0}*", Projektnummer)); if (fo2.Count() == 1) { var foProjekt = (DirectoryInfo)fo2[0]; //var foRechnungen = new DirectoryInfo(string.Format("{0}\\Auftrag\\Kommerziell", foProjekt.FullName)); foRechnungen = new DirectoryInfo(string.Format(@pfadDetail, foProjekt.FullName)); FileInfo[] files = foRechnungen.GetFiles(string.Format("{0}.*", RNr)); if (files.Count() == 1) { FileInfo fi = (FileInfo)files[0]; OpenRechnung(fi.FullName); } else if (files.Count() > 1) { FileInfo fi = (FileInfo)files[0]; ShowFiles(fi.FullName); } else if (files.Count() == 0) { ShowFiles(foRechnungen.FullName); } } else { ShowFiles(fo1.FullName); } } catch (Exception ex) { throw new Exception(ErrorMethods.GetExceptionMessageInfo(ex)); } }