private void Add_Click(object sender, RoutedEventArgs e) { int Price = (ProdCombo.SelectedItem as Product_tbl).ProdPrice; int Amount = Convert.ToInt32(ExpA.Text); String Date = ExpD.Text; String Pname = (ProdCombo.SelectedItem as Product_tbl).ProdName; int Id; try { Id = (ProdCombo.SelectedItem as Product_tbl).ProdId; } catch { this.Title = "Erorr"; return; } int Sum = Price * Amount; /*בודק שהוכנסו כל הנתונים שהם חובה * EmpN name of textBox*/ if (ExpA.Text == "" || ExpD.Text == "") { this.Title = "Erorr"; return; } /* שומר את הנתונים שהוקלדו והוכנסו אל המשתנים המתאימים בטבלה * EmpName השם של העמודה בטבלה*/ Expense_Tbl a1 = new Expense_Tbl(); a1.ExpenseDate = Date; a1.ExpenseAmount = Amount; a1.ExpenseProductId = Id; a1.ExpenseSum = Sum; a1.ExpenseProductName = Pname; db.Expense_Tbl.Add(a1); db.SaveChanges(); this.Title = "Employee Add"; ExpD.Text = ""; ExpA.Text = ""; ProdCombo.Text = ""; this.Title = "sucsses"; UpdateDGV(); updateCB(); }
private void Update_Click(object sender, RoutedEventArgs e) { Expense_Tbl a1 = (Expense_Tbl)CB.SelectedItem; Expense_Tbl a2 = (from s in db.Expense_Tbl where s.ExpenseProductId == a1.ExpenseProductId select s).FirstOrDefault(); a2.ExpenseDate = ExpD.Text; a2.ExpenseAmount = Convert.ToInt32(ExpA.Text); a2.ExpenseProductId = (ProdCombo.SelectedItem as Product_tbl).ProdId; a2.ExpenseProductName = (ProdCombo.SelectedItem as Product_tbl).ProdName; a2.ExpenseSum = Convert.ToInt32(ExpA.Text) * (ProdCombo.SelectedItem as Product_tbl).ProdPrice; db.SaveChanges(); updateCB(); UpdateDGV(); }
private void CB_SelectionChanged(object sender, SelectionChangedEventArgs e) { Expense_Tbl a1 = (Expense_Tbl)CB.SelectedItem; if (a1 == null) { ExpD.Text = ""; ExpA.Text = ""; ProdCombo.Text = ""; return; } ExpA.Text = a1.ExpenseAmount.ToString(); ExpD.Text = a1.ExpenseDate; ProdCombo.Text = a1.Product_tbl.ProdName; }