public void DoDeleteServiceTranscation() { if (SelectedRow == null) { System.Windows.MessageBox.Show("No Selected Row"); return; } DetailServiceTransaction dst = mainAtt.Mydb.DetailServiceTransactions.Where(a => a.DetailServiceID == SelectedRow.DetailServiceID).FirstOrDefault(); mainAtt.Mydb.DetailServiceTransactions.Remove(dst); mainAtt.Mydb.SaveChanges(); initDB(); }
public void DoAddServiceTransaction() { if (ValidateField()) { System.Windows.MessageBox.Show("All field must be filled!"); return; } DetailServiceTransaction d = new DetailServiceTransaction(); var fulldb = mainAtt.Mydb.DetailServiceTransactions.ToList(); string lastID; if (fulldb.Count == 0) { lastID = "DS001"; } else { lastID = fulldb[fulldb.Count - 1].DetailServiceID; int temp = Convert.ToInt32(lastID[2].ToString() + lastID[3].ToString() + lastID[4].ToString()) + 1; int count = 0; int temp2 = temp; while (temp2 != 0) { temp2 /= 10; count++; } if (count == 1) { lastID = "DS00" + temp.ToString(); } else if (count == 2) { lastID = "DS0" + temp.ToString(); } else { lastID = "DS" + temp.ToString(); } } DetailServiceTransaction dst = new DetailServiceTransaction(); dst.HeaderID = HtID; dst.DetailServiceID = lastID; if (_selectedService.Equals("Telkomsel")) { dst.ServiceID = "SE001"; } else if (_selectedService.Equals("Indosat")) { dst.ServiceID = "SE002"; } else if (_selectedService.Equals("XL")) { dst.ServiceID = "SE003"; } else if (_selectedService.Equals("MyPLN")) { dst.ServiceID = "SE004"; } else if (_selectedService.Equals("YourElec")) { dst.ServiceID = "SE005"; } dst.ServicePrice = (decimal)SelectedPrice; mainAtt.Mydb.DetailServiceTransactions.Add(dst); mainAtt.Mydb.SaveChanges(); System.Windows.MessageBox.Show("Success add a bill"); this.TryClose(); }