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));
}
}
}
