private void btn_Save(object sender, RoutedEventArgs e) { if (dg_AllExpenceHeads.SelectedItem != null || dg_AllExpenceSubHeads.SelectedItem != null || dg_AllExpenceSubHeads.SelectedItem != null || tb_Cost.Text != null) { try { tbl_ExpenceHead eh = (tbl_ExpenceHead)dg_AllExpenceHeads.SelectedItem; tbl_ExpenceSubHead esh = (tbl_ExpenceSubHead)dg_AllExpenceSubHeads.SelectedItem; string name = tb_Name.Text; int cost = Convert.ToInt32(tb_Cost.Text); tbl_Expence expence = new tbl_Expence(); expence.Comment = name; expence.Amount = cost; expence.ExpenseHead_Id = eh.Id; expence.ExpenceSubHead_Id = esh.Id; DateTime date = DateTime.Now; expence.DatenTime = date; Expence.insert(expence); AutoClosingMessageBox.Show("Expence Added", "Success", 3000); Close(); } catch { AutoClosingMessageBox.Show("Some Error Occures", "Failed", 3000); } } else { AutoClosingMessageBox.Show("Please Insert Data Properly", "Alert", 3000); } }
public static void insert(tbl_Expence e) { RMSDBEntities db = DBContext.getInstance(); db.tbl_Expence.Add(e); db.SaveChanges(); }
public static void deleteById(int id) { RMSDBEntities db = DBContext.getInstance(); tbl_Expence e = db.tbl_Expence.Find(id); db.tbl_Expence.Remove(e); db.SaveChanges(); }