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