public InventarizacionnajaVedomost() { InitializeComponent(); datePrevInvent = new DateTime(); using (CRM_magEntities context = new CRM_magEntities()) { try { if (context.Materialy.FirstOrDefault().date_ostatok_cur != null) { txtBPrevInvent.Text = ((DateTime)context.spInventVed(dtCurInvent.SelectedDate).FirstOrDefault().date_ostatok_cur).ToString("dd/MM/yyyy"); datePrevInvent = (DateTime)context.spInventVed(dtCurInvent.SelectedDate).FirstOrDefault().date_ostatok_cur; } else { btnRun.IsEnabled = false; } } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Error"); } } Zapoln((DateTime)dtCurInvent.SelectedDate); }
public override ValidationResult Validate(object value, System.Globalization.CultureInfo cultureInfo) { Rashod_2 r_2 = (value as BindingGroup).Items[0] as Rashod_2; decimal kolMat = 0; try { using (CRM_magEntities contextDB = new CRM_magEntities()) { kolMat = Convert.ToDecimal(contextDB.spInventVed(DateTime.Now).FirstOrDefault().ostatok_new); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } if (r_2.kol > kolMat) { MessageBox.Show("На складе " + kolMat.ToString() + ".", "Ошибка!"); return(new ValidationResult(false, "Start Date must be earlier than End Date.")); } else { return(ValidationResult.ValidResult); } }
private void Zapoln(DateTime dt) { using (CRM_magEntities context = new CRM_magEntities()) { try { lstIntVed = new List <InventVed>(); foreach (var item in context.spInventVed(dt)) { InventVed mt = new InventVed(); mt.id_material = item.id_material; mt.artikul = item.artikul; mt.NameMaterial = item.NameMaterial; mt.id_ed_izm = item.id_ed_izm; Ed_izm ei = context.Ed_izm.Find(item.id_ed_izm); mt.date_ostatok = (DateTime)item.date_ostatok_cur; mt.nameEI = ei.nameEI; if (item.prih == null) { mt.prih = 0; } else { mt.prih = (decimal)item.prih; } if (item.rash == null) { mt.rash = 0; } else { mt.rash = (decimal)item.rash; } if (item.ostatok_cur == null) { mt.ostatok_cur = 0; } else { mt.ostatok_cur = (decimal)item.ostatok_cur; } if (item.ostatok_new == null) { mt.ostatok_new = 0; } else { mt.ostatok_new = (decimal)item.ostatok_new; } lstIntVed.Add(mt); } } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Error"); } dgInventVedomost.ItemsSource = null; dgInventVedomost.ItemsSource = lstIntVed; } }