public void DeletePositionEvents(Views.SI_EventsView window)
{
try
{
var grid = window.EventsGrid;
var pos = (SI_Events)grid.SelectedItem;
if (pos != null)
{
if (MessageBox.Show(string.Format("Position {0} wirklich löschen?", pos.Bezeichnung), "", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
try
{
foreach (var item in pos.Personen_Events.ToList())
{
db.DeleteObject(item);
}
db.DeleteObject(pos);
}
catch (Exception)
{
}
events.Remove(pos);
}
}
}
catch (Exception ex)
{
CommonTools.Tools.ErrorMethods.HandleStandardError(ex, "Fehler beim Löschen von Events");
}
}
public static int DeleteTermine(int id)
{
try
{
using (var db = new SteinbachEntities())
{
var adr = db.CRMTermine.Where(t => t.id == id).SingleOrDefault();
//TeilnehmerSI Löschen wegen Ref. Integritätfehler
//var tsi = db.Termine_TeilnehmerSI.Where(s => s.id_Termin == adr.id);
foreach (var teilnehmerSI in adr.Termine_TeilnehmerSI.ToList())
{
db.DeleteObject(teilnehmerSI);
}
//TeilnehmerExtern Löschen wegen Ref. Integritätfehler
//var tex = db.Termin_TeilnehmerExtern.Where(t => t.id_Termin == adr.id);
foreach (var TeilnehmerExtern in adr.Termin_TeilnehmerExtern.ToList())
{
db.DeleteObject(TeilnehmerExtern);
}
//Termin löschen
db.DeleteObject(adr);
return(db.SaveChanges());
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(0);
}
}
public static int DeleteBesuchsbericht(int id)
{
string Rights = "admin suCRM";
if (!Rights.Contains(Session.User.rights))
{
return(0);
}
using (var db = new SteinbachEntities())
{
var besuch = db.Firmen_Kundenbesuche.Where(m => m.id == id).SingleOrDefault();
if (besuch != null)
{
foreach (var item in besuch.Kundenbesuche_TeilnehmerExtern.ToList())
{
db.DeleteObject(item);
}
db.DeleteObject(besuch);
return(db.SaveChanges(System.Data.Objects.SaveOptions.AcceptAllChangesAfterSave));
}
else
{
return(0);
}
}
}
public void Save()
{
try
{
foreach (var item in base.Items)
{
item.SaveChanges(Context);
}
if (Deleted != null)
{
foreach (var item in Deleted.ToArray())
{
var pers = Firmen_TelefonViewModel.GetPersonTelefon(Context, item);
Context.DeleteObject(pers);
Deleted.Remove(item);
}
Deleted.Clear();
Deleted = null;
}
}
catch (Exception ex)
{
MessageBox.Show("Fehler in Firmen_TelefonViewModelCollection " + ex.Message);
}
}
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 void DeletingRows(C1.WPF.DataGrid.DataGridDeletingRowsEventArgs e)
{
if (e.DeletedRows.Count() > 0)
{
if (MessageBox.Show(string.Format("{0} Artikel wirklich löschen ?", e.DeletedRows.Count()), "", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
foreach (var item in e.DeletedRows)
{
var data = (lagerliste)item.DataItem;
// Artikelliste.Remove(data);
db.DeleteObject(data);
}
}
}
}
void UpdateCollection(object sender, System.Collections.Specialized.NotifyCollectionChangedEventArgs e)
{
try
{
switch (e.Action)
{
case System.Collections.Specialized.NotifyCollectionChangedAction.Add:
{
if (e.NewItems != null && e.NewItems.Count > 0)
{
foreach (Firmen_Personen item in e.NewItems)
{
if (fk.Where(k => k.id_Teilnehmer == item.id).Count() == 0)
{
var k = new Termin_TeilnehmerExtern();
k.id_Teilnehmer = item.id;
k.CRMTermine = CurrentTermin;
fk.Add(k);
db.AddToTermin_TeilnehmerExtern(k);
// db.SaveChanges();
}
}
}
break;
}
case System.Collections.Specialized.NotifyCollectionChangedAction.Remove:
{
if (e.OldItems != null && e.OldItems.Count > 0)
{
foreach (Firmen_Personen item in e.OldItems)
{
if (fk.Where(k => k.id_Teilnehmer == item.id).Count() == 1)
{
var k = fk.Where(ka => ka.id_Teilnehmer == item.id).SingleOrDefault();
fk.Remove(k);
db.DeleteObject(k);
// db.SaveChanges();
}
}
}
break;
}
default:
{
break;
}
}
}
catch (Exception ex)
{
CommonTools.Tools.ErrorMethods.ShowErrorMessage(ex);
}
}
public static int DeleteEmail(int id)
{
try
{
using (var db = new SteinbachEntities())
{
var mail = db.CRMEmails.Where(m => m.id == id).SingleOrDefault();
if (mail != null)
{
if (mail.EmailAttachments.Count() > 0)
{
var att = mail.EmailAttachments.ElementAt(0);
FileInfo fi = new FileInfo(att.Path);
DirectoryInfo di = new DirectoryInfo(fi.DirectoryName);
try
{
di.Delete(true);
}
catch (Exception)
{
}
foreach (var item in mail.EmailAttachments.ToList())
{
db.DeleteObject(item);
}
}
db.DeleteObject(mail);
return(db.SaveChanges(System.Data.Objects.SaveOptions.AcceptAllChangesAfterSave));
}
else
{
return(0);
}
}
}
catch (Exception ex)
{
CommonTools.Tools.ErrorMethods.ShowErrorMessage(ex);
return(0);
}
}
void UpdateCollection(object sender, System.Collections.Specialized.NotifyCollectionChangedEventArgs e)
{
switch (e.Action)
{
case System.Collections.Specialized.NotifyCollectionChangedAction.Add:
{
if (e.NewItems != null && e.NewItems.Count > 0)
{
foreach (StammBelegarten item in e.NewItems)
{
if (fk.Where(k => k.id_Belegart == item.id).Count() == 0)
{
var k = new SI_BelegartenTextbausteine();
k.id_Belegart = item.id;
k.id_Textbaustein = textbaustein.id;
k.id_Sprache = textbaustein.id_Sprache;
k.Mandantory = item.Mandantory == true ? (short)1 :(short)0;
fk.Add(k);
db.AddToSI_BelegartenTextbausteine(k);
db.SaveChanges();
}
}
}
break;
}
case System.Collections.Specialized.NotifyCollectionChangedAction.Remove:
{
if (e.OldItems != null && e.OldItems.Count > 0)
{
foreach (StammBelegarten item in e.OldItems)
{
if (fk.Where(k => k.id_Belegart == item.id).Count() == 1)
{
var k = fk.Where(ka => ka.id_Belegart == item.id).SingleOrDefault();
fk.Remove(k);
db.DeleteObject(k);
db.SaveChanges();
}
}
}
break;
}
default:
{
break;
}
}
}
void UpdateCollection(object sender, System.Collections.Specialized.NotifyCollectionChangedEventArgs e)
{
switch (e.Action)
{
case System.Collections.Specialized.NotifyCollectionChangedAction.Add:
{
if (e.NewItems != null && e.NewItems.Count > 0)
{
foreach (AuswahlEintraege item in e.NewItems)
{
if (fk.Where(k => k.id_FirmaEigenschaft == item.id).Count() == 0)
{
var k = new SI_SelectedTypFirmaEigenschaften();
k.id_FirmaEigenschaft = item.id;
fk.Add(k);
db.AddToSI_SelectedTypFirmaEigenschaften(k);
db.SaveChanges();
}
}
}
break;
}
case System.Collections.Specialized.NotifyCollectionChangedAction.Remove:
{
if (e.OldItems != null && e.OldItems.Count > 0)
{
foreach (AuswahlEintraege item in e.OldItems)
{
if (fk.Where(k => k.id_FirmaEigenschaft == item.id).Count() == 1)
{
var k = fk.Where(ka => ka.id_FirmaEigenschaft == item.id).SingleOrDefault();
fk.Remove(k);
db.DeleteObject(k);
db.SaveChanges();
}
}
}
break;
}
default:
{
break;
}
}
}
void UpdateCollection(object sender, System.Collections.Specialized.NotifyCollectionChangedEventArgs e)
{
switch (e.Action)
{
case System.Collections.Specialized.NotifyCollectionChangedAction.Add:
{
if (e.NewItems != null && e.NewItems.Count > 0)
{
foreach (firma item in e.NewItems)
{
if (fk.Where(k => k.id_Kategorie == item.id).Count() == 0)
{
var k = new Personen_Kategorien();
k.id_Kategorie = item.id;
k.Firmen_Personen = CurrentPerson;
fk.Add(k);
db.AddToPersonen_Kategorien(k);
db.SaveChanges();
}
}
}
break;
}
case System.Collections.Specialized.NotifyCollectionChangedAction.Remove:
{
if (e.OldItems != null && e.OldItems.Count > 0)
{
foreach (firma item in e.OldItems)
{
if (fk.Where(k => k.id_Kategorie == item.id).Count() == 1)
{
var k = fk.Where(ka => ka.id_Kategorie == item.id).SingleOrDefault();
fk.Remove(k);
db.DeleteObject(k);
db.SaveChanges();
}
}
}
break;
}
default:
{
break;
}
}
}
void UpdateCollection(object sender, System.Collections.Specialized.NotifyCollectionChangedEventArgs e)
{
switch (e.Action)
{
case System.Collections.Specialized.NotifyCollectionChangedAction.Add:
{
if (e.NewItems != null && e.NewItems.Count > 0)
{
foreach (person item in e.NewItems)
{
if (fk.Where(k => k.id_TeilnemerSI == item.id).Count() == 0)
{
var k = new Kundenbesuche_TeilnehmerSI();
k.id_TeilnemerSI = item.id;
k.Firmen_Kundenbesuche = CurrentBesuch;
fk.Add(k);
db.AddToKundenbesuche_TeilnehmerSI(k);
OnDataChanged(true);
}
}
}
break;
}
case System.Collections.Specialized.NotifyCollectionChangedAction.Remove:
{
if (e.OldItems != null && e.OldItems.Count > 0)
{
foreach (person item in e.OldItems)
{
if (fk.Where(k => k.id_TeilnemerSI == item.id).Count() == 1)
{
var k = fk.Where(ka => ka.id_TeilnemerSI == item.id).SingleOrDefault();
fk.Remove(k);
db.DeleteObject(k);
OnDataChanged(true);
}
}
}
break;
}
default:
{
break;
}
}
}
void UpdateCollection(object sender, System.Collections.Specialized.NotifyCollectionChangedEventArgs e)
{
switch (e.Action)
{
case System.Collections.Specialized.NotifyCollectionChangedAction.Add:
{
if (e.NewItems != null && e.NewItems.Count > 0)
{
foreach (person item in e.NewItems)
{
if (fk.Where(k => k.id_Teilnehmer == item.id).Count() == 0)
{
var k = new Termine_TeilnehmerSI();
k.id_Teilnehmer = item.id;
k.CRMTermine = CurrentTermin;
fk.Add(k);
db.AddToTermine_TeilnehmerSI(k);
// db.SaveChanges();
}
}
}
break;
}
case System.Collections.Specialized.NotifyCollectionChangedAction.Remove:
{
if (e.OldItems != null && e.OldItems.Count > 0)
{
foreach (person item in e.OldItems)
{
if (fk.Where(k => k.id_Teilnehmer == item.id).Count() == 1)
{
var k = fk.Where(ka => ka.id_Teilnehmer == item.id).SingleOrDefault();
fk.Remove(k);
db.DeleteObject(k);
// db.SaveChanges();
}
}
}
break;
}
default:
{
break;
}
}
}
public static bool DeleteCustumer(int id)
{
using (var db = new SteinbachEntities())
{
var cust = db.firmen.Where(c => c.id == id).SingleOrDefault();
if (cust != null)
{
db.DeleteObject(cust);
db.SaveChanges(System.Data.Objects.SaveOptions.AcceptAllChangesAfterSave);
}
}
return(false);
}
public static bool DeleteFirmenAdresse(Firmen_Adressen adresse, SteinbachEntities db)
{
if (adresse.Firmen_Personen != null && adresse.Firmen_Personen.Count > 0)
{
var fp = adresse.Firmen_Personen.ToList();
foreach (var item in fp)
{
DeleteFirmenPersonen(item, db);
}
}
db.DeleteObject(adresse);
return(true);
}
public void DeletePositionKostenStellenFirmen(views.KostenstellenView window)
{
try
{
var grid = window.KostenstellenFirmenGrid;
var pos = (SI_KostenstellenFirmen)grid.SelectedItem;
if (pos != null)
{
if (MessageBox.Show(string.Format("Position {0} wirklich löschen?", pos.Bezeichnung), "", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
try
{
if (pos.SI_Kostenstellen.Count() > 0)
{
foreach (var item in pos.SI_Kostenstellen.ToList())
{
db.DeleteObject(item);
Kostenstellen.Remove(item);
}
}
db.DeleteObject(pos);
}
catch (Exception)
{
}
KostenstellenFirmen.Remove(pos);
}
}
}
catch (Exception ex)
{
CommonTools.Tools.ErrorMethods.HandleStandardError(ex, "Fehler beim Löschen von Kostenstellen Firmen");
}
}
public void DeleteKategorie(FrameworkElement dc)
{
try
{
// string buf = string.Empty;
var x = (Firmen_Kategorien)dc.DataContext;
var lookup = db.firmen.Where(f => f.id == x.id_Kategorie).SingleOrDefault();
//var buf = lookup == null ? "Leere Kategorie" : lookup.name;
if (MessageBox.Show(string.Format("Kategorie {0} wirklich endgültig löschen ?", lookup == null ? "Leere Kategorie" : lookup.name), "Sicherheitsabfrage",
MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
db.DeleteObject(x);
Firmen_KategorienOC.Remove(x);
db.SaveChanges();
}
}
catch (Exception ex)
{
CommonTools.Tools.ErrorMethods.ShowErrorMessage(ex);
}
}
//public void DeleteEintrag()
//{
// Console.WriteLine("DeleteEintrag");
//}
public void GridEintraege_DeletingRows(C1.WPF.DataGrid.DataGridDeletingRowsEventArgs e)
{
if (e.DeletedRows.Count() == 1)
{
var adr = (AuswahlEintraege)e.DeletedRows[0].DataItem;
if (MessageBox.Show(string.Format("Eintrag {0} wirklich endgültig löschen ?", adr.Eintrag), "Sicherheitsabfrage",
MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
db.DeleteObject(adr);
}
else
{
e.Cancel = true;
}
}
}
private void c1GridUnterartikel_RowsDeleted(object sender, C1.WPF.DataGrid.DataGridRowsDeletedEventArgs e)
{
try
{
foreach (var item in e.DeletedRows.Select(row => (row.DataItem as Firmen_Telefon)).ToArray())
{
Firmen_Telefon k = db.Firmen_Telefon.Where(p => p.id == item.id).Single();
db.DeleteObject(k);
db.SaveChanges();
}
}
catch (Exception)
{
}
}
public void Mailadressen_DeletingRows(C1.WPF.DataGrid.DataGridDeletingRowsEventArgs e)
{
if (e.DeletedRows.Count() == 1)
{
var adr = (Personen_Mailadressen)e.DeletedRows[0].DataItem;
if (MessageBox.Show(string.Format("Adresse {0} {1} wirklich endgültig löschen ?", adr.Typ, adr.Mailadresse), "Sicherheitsabfrage",
MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
db.DeleteObject(adr);
}
else
{
e.Cancel = true;
}
}
}
//System.Data.Objects.ObjectQuery<projekt> p;
// if (filter == string.Empty || filter == null)
// {
// p = db.projekte
// .OrderBy("it.created desc");
// }
// else
// {
// p = db.projekte
// .Where(filter)
// .OrderBy("it.created desc");
// }
// RecordCount = p.Count();
// var res = new ProjektCollection(p.Skip(toSkip).Take(toTake), db);
// return res;
#region "EventCalls"
public void DeletePosition(views.Inventur window)
{
var grid = window.c1GridDetais;
var pos = (SI_InventurenPositionen)grid.SelectedItem;
if (pos.IstGebucht == 1)
{
MessageBox.Show(string.Format("Position {0} ist schon gebucht. Löschen nicht möglich.", pos.Artikelname));
}
else
{
if (MessageBox.Show(string.Format("Position {0} wirklich löschen?", pos.Artikelname), "", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
db.DeleteObject(pos);
invPositionen.Remove(pos);
}
}
}
public void ConsolidateLagerbestaende()
{
try
{
Console.WriteLine("ConsolidateLagerbestaende");
var duplicates = (from item in db.Lagerbestaende
group item by new { Lagerliste = item.id_Lagerliste, Lagerort = item.id_Lagerort } into g
where g.Count() > 1
select g);
foreach (var item in duplicates)
{
Console.WriteLine(item.Key.Lagerliste);
var bst = new Lagerbestaende();
db.AddToLagerbestaende(bst);
bst.Lagerbestand = 0;
foreach (Lagerbestaende lb in item.ToList())
{
bst.id_Lagerliste = lb.id_Lagerliste;
bst.id_Lagerort = lb.id_Lagerort;
bst.Lagerbestand += lb.Lagerbestand;
bst.letzteBuchung = lb.letzteBuchung;
bst.Mindestbestand = lb.Mindestbestand;
bst.Sollbestand = lb.Sollbestand;
db.DeleteObject(lb);
}
}
db.SaveChanges();
Console.WriteLine("Ende - ConsolidateLagerbestaende");
}
catch (Exception)
{
throw;
}
}
public void DeleteMailadresse(FrameworkElement dc)
{
try
{
var x = (Personen_Mailadressen)dc.DataContext;
if (MessageBox.Show(string.Format("Adresse {0} {1} wirklich endgültig löschen ?", x.Typ, x.Mailadresse), "Sicherheitsabfrage",
MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
db.DeleteObject(x);
Mailadressen.Remove(x);
//db.SaveChanges();
}
}
catch (Exception ex)
{
MessageBox.Show(CommonTools.Tools.ErrorMethods.GetExceptionMessageInfo(ex));
}
}
public static bool DeleteFirmenPersonen(Firmen_Personen person, SteinbachEntities db)
{
db.DeleteObject(person);
return(true);
}
