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 FillList()
{
//db = new SteinbachEntities();
ArtState = ArtikelState.NoState;
pRepo = new ProjektRepository(this.db);
db.SavingChanges += new EventHandler(db_SavingChanges);
KalkulationViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("Kalkulation_ViewSource")));
KalkulationDetailViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("KalkulationDetail_ViewSource")));
SetsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("SetsViewSource")));
// var calc = from k in db.kalkulationstabellen where k.id == CurrentProjektID select k;
KalkulationViewSource.Source = pRepo.GetKalkukationByID(CurrentProjektID);
KalkulationView = (ListCollectionView)KalkulationViewSource.View;
KalkulationDetailView = (BindingListCollectionView)KalkulationDetailViewSource.View;
LieferantenViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("LieferantenViewSource")));
LieferantenViewSource.Source = db.firmen.Where(id => id.istFirma == 1);
SetsViewSource.Source = db.StammLagerorte.Where(n => n.istSet == 1);
if (CurrentProjektID == 0)
{
addNewKalkulation(ProjektNummer);
db.SaveChanges();
}
var con = new Comma2PointConverter();
this.ftbAufschlag.SetBinding("procent", BindingMode.TwoWay, UpdateSourceTrigger.PropertyChanged, con);
var cbi = new C1.WPF.C1ComboBoxItem();
// c1CboAufschlag.Items.Add((double)0);
si.Add("0");
for (int i = 100; i < 500; i += 5)
{
double res = (double)i / 10;
//c1CboAufschlag.Items.Add(res);
si.Add(res.ToString());
}
source = (IEnumerable <string>)si;
ftbAufschlag.cBox.ItemsSource = source;
try
{
KalkulationDetailView.CurrentChanged += new EventHandler(KalkulationDetailView_CurrentChanged);
KalkulationView.CurrentChanged += new EventHandler(KalkulationView_CurrentChanged);
}
catch (Exception)
{
}
}
private void c1GridDetais_LostFocus(object sender, RoutedEventArgs e)
{
try
{
if (bRowEditing)
{
var grid = (C1.WPF.DataGrid.C1DataGrid)e.Source;
var r = (kalkulationstabelle_detail)grid.CurrentRow.DataItem;
string CellName = grid.CurrentCell.Column.Name;
if (grid.CurrentCell.Value != null)
{
string CellValue = grid.CurrentCell.Value.ToString();
using (SteinbachEntities dbLocal = new SteinbachEntities())
{
if (CellName == "artikelnr")
{
try
{
//if (ArtState == ArtikelState.NoState)
//{
var q = from b in dbLocal.lagerlisten where b.artikelnr == CellValue select b;
if (q.Count() > 0)
{
ArtState = ArtikelState.Done;
r.beschreibung = q.FirstOrDefault().beschreibungeng != null?q.FirstOrDefault().beschreibungeng : "";
r.umrechnungeuro = q.FirstOrDefault().preisbrutto.HasValue ? (double)q.FirstOrDefault().preisbrutto : 0;
r.einheit = q.FirstOrDefault().einheit != null?q.FirstOrDefault().einheit : "";
r.id_Lieferant = q.FirstOrDefault().id_lieferant.HasValue ? q.FirstOrDefault().id_lieferant : null;
}
//else
//{
// ArtState = ArtikelState.ArtikelNew;
// ThisArtikel = new lagerliste();
// ThisArtikel.artikelnr = CellValue;
// grid.CurrentCell.Presenter.Background=Brushes.Yellow;
//}
//}
}
catch (Exception)
{
}
}
//else
//{
// try
// {
// if (ArtState == ArtikelState.ArtikelNew)
// {
// if (CellName == "beschreibung")
// {
// ThisArtikel.beschreibungeng = CellValue;
// ThisArtikel.bezeichnung = CellValue;
// }
// if (CellName == "umrechnungeuro")
// {
// ThisArtikel.preisbrutto = decimal.Parse(CellValue);
// }
// if (CellName == "id_Lieferant")
// {
// ThisArtikel.id_lieferant = int.Parse(CellValue);
// }
// if (CellName == "einheit")
// {
// ThisArtikel.einheit = CellValue;
// }
// }
// }
//catch (Exception)
//{
//}
}
}
}
}
//}
catch (Exception)
{
}
}
