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