public void RemoveAccInfo(int id) { AccInfoC inter = new AccInfoC(); AccInfo info = new AccInfo(); info = inter.FindAccInfo(id); info.Amount = -1 * Convert.ToDouble(info.Amount) + ""; if (info.Kind == "Regular") { Regular(info); } if (info.Kind == "Income") { Income(info); } if (info.Kind == "Expenses") { Expenses(info); } if (info.Kind == "Third party") { Thirdparty(info); } while (con.State == ConnectionState.Open) { System.Threading.Thread.Sleep(500); } con.Open(); MySqlCommand cmd = new MySqlCommand("DELETE FROM AccInfo WHERE Id = @id", con); cmd.Parameters.AddWithValue("@id", id); cmd.ExecuteNonQuery(); con.Close(); }
public void RemoveAcc(Account acc) { string newname = "Deleted Account Number" + acc.AccountNum; //delete from DB AccInfoC inter = new AccInfoC(); List <AccInfo> l = inter.ListBelongToBank(acc.AccountNum, "01/01/1900", DateTime.Now.ToShortDateString(), "All", "All"); //change all the transference that was from and to this account to be know as outside account foreach (var v in l) { v.Kind = "Third party"; if (v.Requestfrom == acc.AccountNum) { v.Requestfrom = newname; } else { v.RequestTo = newname; } inter.UpdateWhenDelete(v); } //delete the account while (con.State == ConnectionState.Open) { System.Threading.Thread.Sleep(500); } con.Open(); MySqlCommand cmd = new MySqlCommand("DELETE FROM Account WHERE AccountNum = @id", con); cmd.Parameters.AddWithValue("@id", acc.AccountNum); cmd.ExecuteNonQuery(); con.Close(); }