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