private void ClearDbFile() { DialogResult dialogResult = MessageBox.Show("هل تريد بدا عملية جديدة برجاء الاختفاظ بنسخه البيانات قبل بدا فتره جديدة", "تأكيد بدا عملية جديدة الان", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { ConnectionClass conObj = new ConnectionClass(); conObj.startConnection(); try { #region Delete all the prev Data String sql = "delete from aqsat"; conObj.SQLUPDATE(sql, false); sql = "delete from cheques"; conObj.SQLUPDATE(sql, false); sql = "delete from Clients"; conObj.SQLUPDATE(sql, false); sql = "delete from ClientsUnits"; conObj.SQLUPDATE(sql, false); sql = "delete from units"; conObj.SQLUPDATE(sql, false); sql = "delete from first_paids"; conObj.SQLUPDATE(sql, false); sql = "delete from montsben"; conObj.SQLUPDATE(sql, false); sql = "delete from T5sesMoney"; conObj.SQLUPDATE(sql, false); sql = "delete from tanazolat"; conObj.SQLUPDATE(sql, false); sql = "delete from WarningLetters"; conObj.SQLUPDATE(sql, false); sql = "delete from transactions where group_id <> 0"; conObj.SQLUPDATE(sql, true); #endregion } catch (Exception ex) { MessageBox.Show("خطأ اثناء مسح البيانات القديمة !" + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); Logger.WriteLog("[" + DateTime.Now + "] ExceptionString: " + ex.ToString() + " InnerException: " + ex.InnerException + " ExceptionMessage: " + ex.Message + ". [" + this.Name + "] By [" + SessionInfo.empName + "]"); } } }
public MontasbenMoneyManager() { InitializeComponent(); conn = new ConnectionClass(); photos_group = new List <int>(); }
public NewItem() { InitializeComponent(); conn = new ConnectionClass(); }
public AddNewItems() { InitializeComponent(); conn = new ConnectionClass(); initTyeps(); }
public BankTypes() { InitializeComponent(); con = new ConnectionClass(); loadData(); }
public LoginForm() { InitializeComponent(); con = new ConnectionClass(); this.ActiveControl = userNameText; }
public EditeSheeque() { InitializeComponent(); conn = new ConnectionClass(); }
public ClientReportForm() { InitializeComponent(); conObj = new ConnectionClass(); this.FormBorderStyle = FormBorderStyle.Sizable; }
public CheckOutList() { InitializeComponent(); conObj = new ConnectionClass(); }
public RecivePayments() { InitializeComponent(); conn = new ConnectionClass(); this.ActiveControl = nationalIdtext; }
public TkhcesForm() { InitializeComponent(); conObj = new ConnectionClass(); conObj.startConnection(); }
public AddSheeq(int cli_ID) { InitializeComponent(); conn = new ConnectionClass(); client_id = cli_ID; }
public WarningLettersManager() { InitializeComponent(); Dbonj = new ConnectionClass(); }