public object Convert(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture) { if (value != null) { int id = (int)value; if (id != 0) { using (SteinbachEntities db = new SteinbachEntities()) { //int id = (int)value; var query = db.Firmen_Adressen.Where(k => k.id == id).SingleOrDefault(); var sb = new StringBuilder(); sb.Append(query.Postfach); sb.Append(", "); sb.Append(query.PostfachPLZ); sb.Append(" "); sb.Append(query.PostfachOrt); return(sb.ToString()); } } } return(""); }
public object Convert(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture) { using (var db = new SteinbachEntities()) { if (value == null || (int)value == 0) { return(0); } int v = (int)value; if (v == 35) { Console.WriteLine(""); } var query = from p in db.Lagerbestaende where p.id_Lagerliste == v select p; int?bestand = 0; foreach (var item in query) { bestand += item.Lagerbestand; } if (bestand.HasValue) { return((int)bestand); } else { return(0); } } }
private void SaveNewArtikel() { try { if (ArtState == ArtikelState.ArtikelNew) { if (ThisArtikel != null) { using (var dbTemp = new SteinbachEntities()) { db.AddTolagerlisten(ThisArtikel); db.SaveChanges(); } } } } catch (Exception) { } finally { ArtState = ArtikelState.NoState; ThisArtikel = null; } }
private void LoadKontakte(int id_Firma, string filter = "") { using (var db = new SteinbachEntities()) { try { if (filter == string.Empty) { var query = from f in db.Firmen_Personen where f.id_Firma == id_Firma orderby f.Nachname select f; this.lfcKontakt.CBoxItemssource = query; // AlleFirmen = new FirmenCollection(query, db); } else { var query = db.Firmen_Personen.Where(f => f.Nachname.Contains(filter) && f.id_Firma == id_Firma).OrderBy(f => f.Nachname); //AlleFirmen = new FirmenCollection(query, db); this.lfcKontakt.CBoxItemssource = query; } } catch (System.Exception ex) { MessageBox.Show(CommonTools.Tools.ErrorMethods.GetExceptionMessageInfo(ex)); } } }
private void LoadAktionen(string filter = "") { using (var db = new SteinbachEntities()) { try { if (filter == string.Empty) { var query = from f in db.AuswahlEintraeges where f.Gruppe == "EmailAktion" orderby f.Eintrag select f; this.lfcAktion.CBoxItemssource = query; } else { var query = db.AuswahlEintraeges.Where(f => f.Eintrag.Contains(filter) && f.Gruppe == "EmailAktion").OrderBy(f => f.Eintrag); //AlleFirmen = new FirmenCollection(query, db); this.lfcKontakt.CBoxItemssource = query; } } catch (System.Exception ex) { MessageBox.Show(CommonTools.Tools.ErrorMethods.GetExceptionMessageInfo(ex)); } } }
public static int GetLagerbestand(int ArtikelID, int LagerortID) { if (ArtikelID != null && LagerortID != null) { try { using (var db = new SteinbachEntities()) { var lo = db.Lagerbestaende.Where(n => n.id_Lagerliste == ArtikelID && n.id_Lagerort == LagerortID).SingleOrDefault(); if (lo != null) { if (lo.Lagerbestand.HasValue) { return((int)lo.Lagerbestand); } } } } catch (Exception ex) { var sb = new StringBuilder(); sb.AppendLine("Fehler in Lagerbuchungen.GetLagerbestand"); sb.AppendLine("ArtikelID : " + ArtikelID); sb.AppendLine("LagerortID : " + LagerortID); CommonTools.Tools.ErrorMethods.HandleStandardError(ex, sb.ToString()); } } return(0); }
//private AuswahlEintraege _SelectedEintraegeStatus; //public AuswahlEintraege SelectedEintraegeStatus //{ // get { return _SelectedEintraegeStatus; } // set // { // _SelectedEintraegeStatus = value; // if (value != null) // { // CurrentFirma.status = value.Eintrag; // } // NotifyOfPropertyChange(() => SelectedEintraegeStatus); // } //} //private ObservableCollection<AuswahlEintraege> _EintraegeStatus; //public ObservableCollection<AuswahlEintraege> EintraegeStatus //{ // get { return _EintraegeStatus; } // set // { // _EintraegeStatus = value; // NotifyOfPropertyChange(() => EintraegeStatus); // } //} // Deactivated 09.01.2013 //private int FirmaAktuell; //private ObservableCollection<StammFirmen_Kategorien> _SelectedEmployees; //public ObservableCollection<StammFirmen_Kategorien> SelectedEmployees //{ // get // { // if (_SelectedEmployees == null) // { // _SelectedEmployees = new ObservableCollection<StammFirmen_Kategorien> ( db.StammFirmen_Kategorien.Where(p=>p.id==1)); // SelectedEmployeesText = WriteSelectedEmployeesString(_SelectedEmployees); // _SelectedEmployees.CollectionChanged += // (s, e) => // { // SelectedEmployeesText = WriteSelectedEmployeesString(_SelectedEmployees); // NotifyOfPropertyChange(() => SelectedEmployees); // }; // } // return _SelectedEmployees; // } // set // { // _SelectedEmployees = value; // } //} //public string SelectedEmployeesText //{ // get { return _SelectedEmployeesText; } // set // { // _SelectedEmployeesText = value; // NotifyOfPropertyChange(() => SelectedEmployeesText); // } //} string _SelectedEmployeesText; //private static string WriteSelectedEmployeesString(IList<StammFirmen_Kategorien> list) //{ // if (list.Count == 0) // return String.Empty; // StringBuilder builder = new StringBuilder(list[0].Kategoriename); // for (int i = 1; i < list.Count; i++) // { // builder.Append(", "); // builder.Append(list[i].Kategoriename); // } // return builder.ToString(); //} #endregion public void Handle(KundeChangedEvent message) { this.db = message.db; this.CurrentFirma = message.Firma; LoadFirma(message.id); }
public void CopyProjektAnlagen2SChiffAnlagen() { using (var db = new SteinbachEntities()) { var query = from p in db.schiffe select p; foreach (var s in query) { if (s.brplantnr != string.Empty) { AddSchiffAnlage(s, s.brplantnr, db); } if (s.brplantnr2 != string.Empty) { AddSchiffAnlage(s, s.brplantnr2, db); } if (s.brplantnr3 != string.Empty) { AddSchiffAnlage(s, s.brplantnr3, db); } if (s.brplantnr4 != string.Empty) { AddSchiffAnlage(s, s.brplantnr4, db); } } db.SaveChanges(); } }
public void DoAddCustomers() { using (SteinbachEntities db = new SteinbachEntities()) { var projects = (from p in db.projekte select new { p.kundenname }).Distinct(); foreach (var po in projects) { var q = from k in db.firmen where k.name.Equals(po.kundenname, StringComparison.CurrentCulture) select k; if (q.Count() == 0) { var f = new firma(); f.name = po.kundenname; f.created = DateTime.Now; f.istFirma = 3; db.firmen.AddObject(f); } } db.SaveChanges(); Console.WriteLine("Done . . . . . ."); } }
public KundeChangedEvent(int id, string addionalInfo, firma Firma, SteinbachEntities db) { this.id = id; this.addionalInfo = addionalInfo; this.db = db; this.Firma = Firma; }
public ListboxKundenbesucheVertreteneFirmenViewModel(Firmen_Kundenbesuch besuch, SteinbachEntities db) { _selectedNames.CollectionChanged += (sender, e) => UpdateCollection(sender, e); this.db = db; CurrentBesuch = besuch; _AvailableNames = db.firmen.Where(n => n.istFirma == 1).ToList(); }
public CalcData(int id) { Positionen = new List <SummePos>(); using (var db = new SteinbachEntities()) { double xt = 0; var query = (from c in db.kalkulationstabelle_details where c.id_kalkulationstabelle == id select c.gesamtangebot).Sum(); double x = query != null ? (double)query : 0; var Transport = from t in db.kalkulationstabellen where t.id == id select t.transportverpackung; xt = Transport.FirstOrDefault().HasValue ? (double)Transport.FirstOrDefault() : 0; var s = new SummePos { Bezeichnung = "Summe", SummePositionen = x + (double)xt }; Positionen.Add(s); } }
private void ReloadFirma(int id) { // db.Dispose(); db = new SteinbachEntities(); if (CurrentFirmaData != null) { if (id == 0) { CurrentFirmaData = null; } else { CurrentFirmaData = null; CurrentFirmaData = db.firmen.Where(i => i.id == id).SingleOrDefault(); EventFirmaChanged(); LoadFirma(); } } LoadFirmen(string.Empty); if (CurrentFirmaData != null) { SelectedAlleFirmen = CurrentFirmaData; } }
public ListboxSelectedBelegartenViewModel(SteinbachEntities db, StammTextbaustein tbs) { _selectedNames.CollectionChanged += (sender, e) => UpdateCollection(sender, e); this.db = db; _AvailableNames = db.StammBelegarten.ToList(); textbaustein = tbs; }
public ListboxTeilnehmerSIViewModel(CRMTermine termin, SteinbachEntities db) { _selectedNames.CollectionChanged += (sender, e) => UpdateCollection(sender, e); this.db = db; CurrentTermin = termin; _AvailableNames = db.personen.ToList(); }
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)); } }
public void CheckAppointments() { try { StringBuilder sb = new StringBuilder(); using (SteinbachEntities db = new SteinbachEntities()) { DateTime Von = DateTime.Now.AddMinutes(-30); DateTime Bis = DateTime.Now.AddMinutes(15); var ap = from t in db.CRMTermine where (t.EmailSent == null || t.EmailSent == 0) && t.Erinnerung == 1 && t.ErinerungDatum >= Von && t.ErinerungDatum <= Bis select t; foreach (var item in ap) { var m = from i in db.Termine_TeilnehmerSI where i.id_Termin == item.id select i; foreach (var itemM in m) { string appShort = string.Empty; person Person = (from p in db.personen where p.id == itemM.id_Teilnehmer select p).SingleOrDefault(); sb.Clear(); sb.Append("Termin von :"); sb.AppendLine(item.TerminVon.ToString()); sb.Append("Termin bis :"); sb.AppendLine(item.TerminBis.ToString()); sb.AppendLine(); sb.Append("Betreff :"); sb.AppendLine(item.Betreff); sb.AppendLine(); sb.AppendLine("Details :"); sb.AppendLine(item.Details); appShort = sb.ToString(); DoSendMail(Person.email, "EMail Erinnerung für " + item.Betreff, sb.ToString()); Eventlogging.log(MailAppointment, "Mail versandt an :" + Person.email, "Termin : " + item.id.ToString(), appShort); } item.EmailSent = 1; item.EmailSentDate = DateTime.Now; } db.SaveChanges(); } } catch (Exception ex) { Eventlogging.log(VerarbeitungFehler, System.Diagnostics.EventLogEntryType.Error, "Fehler bei EMailversand Terminerinnerung" , ex.Message , ex.InnerException == null ? "" :ex.InnerException.Message); } }
private static bool RefreshUser() { try { using (var db = new SteinbachEntities()) { if (_user != null) { var query = from p in db.personen where p.benutzername == _user.benutzername && p.passwort == _user.passwort select p; _user = query.FirstOrDefault(); return(true); } else { return(false); } } } catch (Exception) { return(false); } }
public ListboxPersonenKategorienViewModel(Firmen_Personen person, SteinbachEntities db) { _selectedNames.CollectionChanged += (sender, e) => UpdateCollection(sender, e); this.db = db; CurrentPerson = person; _AvailableNames = db.firmen.Where(f => f.istFirma == 1).ToList(); }
public static bool Login(string user, string password) { try { using (var db = new SteinbachEntities()) { var query = from p in db.personen where p.benutzername == user && p.passwort == password select p; _user = query.FirstOrDefault(); if (_user == null) { return(false); } } return(true); } catch (Exception ex) { StringBuilder sb = new StringBuilder(); sb.AppendLine("Beim Verbinden mit der Datenbank ist ein Fehler aufgetreten"); sb.AppendLine(); sb.AppendLine(ex.Message); if (ex.InnerException != null) { sb.AppendLine(ex.InnerException.Message); } System.Windows.MessageBox.Show(sb.ToString()); return(false); } }
public FirmaDataViewModel(SteinbachEntities db, firma Firma) { try { this.db = db; CurrentFirma = Firma; ListboxKategorien = new ListboxKategorienViewModel(CurrentFirma, db); ListboxEigenschaften = new ListboxEigenschaftenViewModel(CurrentFirma, db); Adressen = new ObservableCollection <Firmen_Adressen>(CurrentFirma.Firmen_Adressen); Telefonnummern = new ObservableCollection <Firmen_Telefon>(CurrentFirma.Firmen_Telefon.OrderBy(o => o.id_Standort)); Mailadressen = new ObservableCollection <Firmen_Mailadressen>(CurrentFirma.Firmen_Mailadressen.OrderBy(o => o.id_Standort)); //Employees = new ObservableCollection<StammFirmen_Kategorien>(db.StammFirmen_Kategorien); Firmen_KategorienOC = new ObservableCollection <Firmen_Kategorien>(db.Firmen_Kategorien.Where(k => k.id_Firma == CurrentFirma.id)); this.db = db; this.db.SavingChanges += new EventHandler(db_SavingChanges); timer = new DispatcherTimer(); timer.Tick += new EventHandler(timer_Tick); timer.Interval = new TimeSpan(0, 0, 0, 0, 500); timer.Start(); AdressenExpanded = true; TelefonnummernExpanded = true; MailadressenExpanded = true; ResetPhoneNumberDirty(false); } catch (Exception ex) { CommonTools.Tools.ErrorMethods.ShowErrorMessage(ex, true); } }
public ListboxKundenbesucheTeilnehmerSIViewModel(Firmen_Kundenbesuch besuch, SteinbachEntities db) { _selectedNames.CollectionChanged += (sender, e) => UpdateCollection(sender, e); this.db = db; CurrentBesuch = besuch; _AvailableNames = db.personen.Where(n => n.ListeKontakteAktiv == 1).ToList(); }
private void LoadFirmen(string filter) { using (var db = new SteinbachEntities()) { try { if (filter == string.Empty) { var query = from f in db.firmas where f.IstKunde == 1 orderby f.name select f; this.lfcFirma.CBoxItemssource = query; } else { var query = db.firmas.Where(f => f.name.Contains(filter) && f.IstKunde == 1).OrderBy(f => f.name); this.lfcFirma.CBoxItemssource = query; } } catch (System.Exception ex) { MessageBox.Show(CommonTools.Tools.ErrorMethods.GetExceptionMessageInfo(ex)); } } }
public ListboxSelectedEventsViewModel(Firmen_Personen person, SteinbachEntities db) { _selectedNames.CollectionChanged += (sender, e) => UpdateCollection(sender, e); this.db = db; CurrentPerson = person; _AvailableNames = db.SI_Events.Where(f => f.istAktiv == 1).ToList(); }
void LoadData(DateTime from, DateTime to) { var db = new SteinbachEntities(); DateTime Bis = CommonTools.Tools.DateTools.GetDateWithCustomHour(to, 23, 59, 59); DateTime Von = CommonTools.Tools.DateTools.GetDateWithCustomHour(from, 0, 0, 0); //var t = db.CRMTermine.Where(d => d.TerminVon >= Von && d.TerminVon <= Bis && d.AppointmentType == "Termin"); var t = db.CRMTermine.Where(d => d.TerminBis >= Von && d.TerminVon <= Bis && d.AppointmentType == "Termin"); c1Scheduler1.BeginInit(); foreach (var item in t) { Appointment a = new Appointment(); a.Start = (DateTime)item.TerminVon; a.End = (DateTime)item.TerminBis; a.Duration = item.TerminDauer == null?TimeSpan.FromTicks(0) : TimeSpan.FromTicks((long)item.TerminDauer); AuswahlEintraege Aktion = db.AuswahlEintraege.Where(ak => ak.id == item.Aktion).SingleOrDefault(); string sAction = Aktion == null ? "" : Aktion.Eintrag; int iAction = Aktion == null ? 8 : (int)Aktion.ai_int; a.Subject = String.Format("{0} => {1}", item.Betreff, sAction); a.Location = item.Standort; int ac = iAction < 12 ? iAction : 8; a.Label = this.c1Scheduler1.DataStorage.LabelStorage.Labels[ac]; a.Tag = "Tag Test"; a.CustomData = item.id.ToString(); a.Body = item.Details; this.c1Scheduler1.DataStorage.AppointmentStorage.Appointments.Add(a); } c1Scheduler1.EndInit(); }
protected override void RemoveItem(int index) { try { // vwLagerListenOberartikel project = this[index]; using (var db = new SteinbachEntities()) { int id = this[index].id; var artikel = db.lagerlisten.Where(s => s.id == id); Console.WriteLine(artikel.FirstOrDefault().beschreibung); db.DeleteObject(artikel.FirstOrDefault()); db.SaveChanges(); } base.RemoveItem(index); } catch (Exception ex) { string Message; Message = ex.Message; if (ex.InnerException != null) { Message += '\n'; Message += ex.InnerException.Message; } throw new Exception(Message); } }
public bool Lagerbuchung(int id_Lagerort, int id_Artikel, int BewegungsMenge) { try { using (var db = new SteinbachEntities()) { var lb = db.Lagerbestaende.Where(n => n.id_Lagerliste == id_Artikel && n.id_Lagerort == id_Lagerort).SingleOrDefault(); if (lb == null) { lb = new Lagerbestaende(); lb.id_Lagerliste = id_Artikel; lb.id_Lagerort = id_Lagerort; lb.Lagerbestand = 0; db.AddToLagerbestaende(lb); } if (!lb.Lagerbestand.HasValue) { lb.Lagerbestand = 0; } lb.Lagerbestand += BewegungsMenge; db.SaveChanges(); return(true); } } catch (Exception ex) { CommonTools.Tools.ErrorMethods.HandleStandardError(ex, "Lagerbuchung fehlgeschlagen."); return(false); // throw; } }
public object Convert(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture) { using (var db = new SteinbachEntities()) { if (value == null || (int)value == 0) { return("-"); } int v = (int)value; var query = from p in db.personen where p.id == v select p.benutzername; //string res = ""; //foreach (string s in query) //{ // res = s; //} //string buf =res ; return(query.FirstOrDefault()); } }
public Kalkulation(int CalcID) { InitializeComponent(); CurrentProjektID = CalcID; db = new SteinbachEntities(); FillList(); }
private void LoadFirmen(string filter) { using (var db = new SteinbachEntities()) { try { if (filter == string.Empty) { var query = from f in db.firmen where f.IstKunde == 1 orderby f.name select f; Firmen = new FirmenCollection(query, db); } else { var query = db.firmen.Where(f => f.name.Contains(filter) && f.IstKunde == 1).OrderBy(f => f.name); Firmen = new FirmenCollection(query, db); } } catch (Exception ex) { CommonTools.Tools.ErrorMethods.HandleStandardError(ex); // MessageBox.Show(CommonTools.Tools.ErrorMethods.GetExceptionMessageInfo(ex)); } } }