private void Button2_Click(object sender, EventArgs e)
{
if (found)
{
try
{
if (deliveredcheckBox1.Checked)
{
sql = "update Clients set unit_number = '" + unitNumber.Text + "', tour_number = '" + borgNumber.Text + "' , delivered ='Y' where id=" + ID + " ";
conn.SQLUPDATE(sql, false);
}
String national = national_id_new.Text;
String address = Client_address.Text;
int client_phone = int.Parse(phoneNumber.Text);
String name = client_name.Text;
String membership = membershipNum.Text;
String details = details_text.Text;
sql = "update Clients set stopState = '" + stopState + "', stopDate = '" + stopDateTxt.Text + "' , stopReason ='" + stopReasonTxt.Text + "',client_name = '" + name + "', description='" + details + "', membership_id = '" + membership + "', phone_number= " + client_phone + ",address='" + address + "',national_id='" + national + "' where id=" + ID + "";
conn.SQLUPDATE(sql, true);
}
catch (Exception ex)
{
MessageBox.Show("خطأ ف البيانات المدخلة");
Logger.WriteLog("[" + DateTime.Now + "] ExceptionString: " + ex.ToString() + " InnerException: " + ex.InnerException + " ExceptionMessage: " + ex.Message + ". [" + this.Name + "] By [" + SessionInfo.empName + "]");
}
}
else
{
MessageBox.Show("برجاء اتمام البيانات");
}
}
private void button2_Click(object sender, EventArgs e)
{
if (ID != 0)
{
String sql = "update Clients set check_out='Y' where national_id='" + nationalIdtext.Text + "' ";
conn.SQLUPDATE(sql, false);
sql = "select unit_id from ClientsUnits where client_id=" + ID + " and RecoredState='N'";
conn.SQLCODE(sql, false);
if (conn.myReader.Read())
{
unitIdToBack = int.Parse(conn.myReader[0].ToString());
}
sql = "update ClientsUnits set RecoredState='C' where client_id=" + ID + " and RecoredState='N'";
conn.SQLUPDATE(sql, false);
sql = "update units set available_units=available_units+1 where ID=" + unitIdToBack + "";
conn.SQLUPDATE(sql, true);
AddSheeq addObj = new AddSheeq(ID);
addObj.ShowDialog();
this.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(area_text.Text) && !String.IsNullOrEmpty(price_txt.Text) && !String.IsNullOrEmpty(Qest_type_text.Text))
{
try
{
conn.startConnection();
String area = area_text.Text;
int price = int.Parse(price_txt.Text);
int type = int.Parse(Qest_type_text.Text);
String sql = "INSERT INTO units (unit_type,qest_system,unit_price,available_units) VALUES (" + area + "," + type + "," + price + ",0)";
conn.SQLUPDATE(sql, true);
tryloadthis(area);
FunctionsClass fc = new FunctionsClass();
}
catch (Exception ex)
{
MessageBox.Show("خطأ ف البيانات المدخلة");
Logger.WriteLog("[" + DateTime.Now + "] ExceptionString: " + ex.ToString() + " InnerException: " + ex.InnerException + " ExceptionMessage: " + ex.Message + ". [" + this.Name + "] By [" + SessionInfo.empName + "]");
}
}
else
{
MessageBox.Show("برجاء اتمام البيانات");
}
}
static public void updtaeMyScriptHistory(int client_Id)
{
con.startConnection();
String sql = "update ClientsUnits set RecoredState='O' where client_id=" + client_Id + "";
con.SQLUPDATE(sql, false);
}
private void saveButton_Click(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(sheeqNumText.Text) && !String.IsNullOrEmpty(sheequeOwner_text.Text) && !String.IsNullOrEmpty(valueText.Text))
{
conn.startConnection();
try
{
double sheeque_num = double.Parse(sheeqNumText.Text);
String sheeque_name = sheequeOwner_text.Text;
int sheeque_value = int.Parse(valueText.Text);
String DateEsdar = dateTimePickerEsdar.Value.ToString("yyyy/MM/dd");
String DateSarf = dateTimePicker1Sarf.Value.ToString("yyyy/MM/dd");
String sql = "INSERT INTO cheques (cheque_number,cheque_owner,cheque_value,cheque_Esdar_Date,Group_id,cheque_Sarf_Date,client_id) VALUES (" + sheeque_num + ",'" + sheeque_name + "'," + sheeque_value + ",'" + DateEsdar + "'," + photosGroup_id + ",'" + DateSarf + "'," + client_id + ") ";
conn.SQLUPDATE(sql, true);
}
catch (Exception ex) {
MessageBox.Show("خطأ اتمام البيانات");
Logger.WriteLog("[" + DateTime.Now + "] ExceptionString: " + ex.ToString() + " InnerException: " + ex.InnerException + " ExceptionMessage: " + ex.Message + ". [" + this.Name + "] By [" + SessionInfo.empName + "]");
}
}
else
{
MessageBox.Show("برجاء اتمام البيانات");
}
}
private void saveButton_Click(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(qestValueText.Text) && ID != 0)
{
try
{
int qestValue = int.Parse(qestValueText.Text);
String Date = datePicker.Value.ToString("yyyy/MM/dd");
String sql = "INSERT INTO aqsat (client_id,qest_value,qest_date,Group_id,bank_id,details) VALUES (" + ID + "," + qestValue + ",'" + Date + "'," + photosGroup_id + "," + (receivingAccountText.SelectedItem as ComboBoxItem).value + ",'" + detailsTxt.Text + "')";
conn.SQLUPDATE(sql, true);
qestValueText.Text = "";
photosGroup_id = 0;
detailsTxt.Text = "";
}
catch (Exception ex)
{
MessageBox.Show("خطأ ف البيانات المدخلة");
Logger.WriteLog("[" + DateTime.Now + "] ExceptionString: " + ex.ToString() + " InnerException: " + ex.InnerException + " ExceptionMessage: " + ex.Message + ". [" + this.Name + "] By [" + SessionInfo.empName + "]");
}
}
else
{
MessageBox.Show("برجاء اتمام البيانات");
}
}
private void button2_Click(object sender, EventArgs e)
{
if (found)
{
String nubmber = sheqNumUpdate.Text;
String mostafed = sheequeOwner_text.Text;
int sheeque_value = int.Parse(valueText.Text);
String DateEsdar = dateTimePickerEsdar.Value.ToString("yyyy/MM/dd");
String DateSarf = dateTimePicker1Sarf.Value.ToString("yyyy/MM/dd");
String sql = "update cheques set cheque_number = " + nubmber + ", cheque_owner = '" + mostafed + "',cheque_value=" + sheeque_value + ",cheque_Esdar_Date='" + DateEsdar + "',cheque_Sarf_Date='" + DateSarf + "' where ID = " + ID + "";
conn.SQLUPDATE(sql, true);
}
else
{
MessageBox.Show("برجاء اتمام البيانات");
}
}
private void saveButton_Click(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(newBankAccount.Text))
{
#region save
con.startConnection();
String sql = "insert into bank_accounts (type) values ('" + newBankAccount.Text + "')";
con.SQLUPDATE(sql, true);
newBankAccount.Text = "";
FunctionsClass w = new FunctionsClass();
#endregion
}
}
private void button1_Click(object sender, EventArgs e)
{
int bankId = 0;
bankId = int.Parse((comboBox1.SelectedItem as ComboBoxItem).value.ToString());
String sql;
if (OpreationTable == "first_paids")
{
sql = "UPDATE first_paids set paid_value = " + int.Parse(value.Text.ToString()) + ",details='" + detailsTxt.Text + "',paid_date = '" + dateTimePicker1.Value.ToString() + "', bank_id= " + bankId + ",Group_id=" + groupId + " where ID = " + ID;
}
else if (OpreationTable == "Montsben")
{
sql = "UPDATE montsben set paid_value = " + int.Parse(value.Text.ToString()) + ",details='" + detailsTxt.Text + "',paid_date = '" + dateTimePicker1.Value.ToString() + "', bank_id= " + bankId + ",Group_id=" + groupId + " where ID = " + ID;
}
else
{
sql = "UPDATE aqsat set qest_value = " + int.Parse(value.Text.ToString()) + ",details='" + detailsTxt.Text + "',qest_date = '" + dateTimePicker1.Value.ToString() + "', bank_id= " + bankId + ",Group_id=" + groupId + " where ID = " + ID;
}
conn.SQLUPDATE(sql, true);
}
private void button2_Click(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(newValue.Text) && ID != -1)
{
int new_value = Int32.Parse(newValue.Text);
String Data = dateTimePicker1.Value.ToString("yyyy/MM/dd");
String sql = "INSERT INTO first_paids (client_id,paid_value,paid_date,bank_id,details) VALUES (" + ID + "," + new_value + ",'" + Data + "'," + int.Parse((comboBox1.SelectedItem as ComboBoxItem).value) + ",'" + detailsTxt.Text + "') ";
conn.SQLUPDATE(sql, true);
}
else
{
MessageBox.Show("برجاء اتمام البيانات");
}
}
private void DeletButton_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("هل أنت متأكد من مسح هذا العميل ؟", "نأكد من المسح", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
String deleteSql = "DELETE FROM employees WHERE employee_name='" + Name.Text.ToString() + "'";
con.SQLUPDATE(deleteSql, true);
}
else if (dialogResult == DialogResult.No)
{
//do something else
}
}
private void saveButton_Click(object sender, EventArgs e)
{
if (custNameText.Text != "" && banksCombo.SelectedItem != null)
{
conObj.startConnection();
int new_value = Int32.Parse(paidValue.Text);
String Data = datePicker.Value.ToString("yyyy/MM/dd");
String sql = "INSERT INTO T5sesMoney (client_id,paid_value,paid_date,bank_id,Group_id,details) VALUES (" + clientId + "," + new_value + ",'" + Data + "'," + int.Parse((banksCombo.SelectedItem as ComboBoxItem).value) + "," + GroupId + ",'" + detailsTxt.Text + "') ";
conObj.SQLUPDATE(sql, true);
}
else
{
MessageBox.Show("رجاء اتمام البيانات اولاً");
}
}
private void saveBtn_Click(object sender, EventArgs e)
{
try
{
if (!string.IsNullOrEmpty(clientName) && !string.IsNullOrEmpty(outboxNumberTxt.Text) && !string.IsNullOrEmpty(subjectTxt.Text))
{
Dbonj.startConnection();
Dbonj.SQLUPDATE("insert into WarningLetters" +
"(LetterNumber," +
"LetterType," +
"LetterSubject," +
"LetterDate," +
"LetterNotes," +
"group_id," +
"LetterClient_ID" +
")" +
" values (" +
"" + outboxNumberTxt.Text + "," +
"'" + letterType.Text + "'," +
"'" + subjectTxt.Text + "'," +
"'" + letterDatePicker.Value.ToString("yyyy/MM/dd") + "'," +
"'" + notesTxt.Text + "'," +
"" + photosGroup_id + "," +
"" + clientID + "" +
")", true);
}
else
{
MessageBox.Show("خطأ ف البيانات المدخلة");
}
}
catch (Exception ex)
{
MessageBox.Show("خطأ ف البيانات المدخلة");
Logger.WriteLog("[" + DateTime.Now + "] ExceptionString: " + ex.ToString() + " InnerException: " + ex.InnerException + " ExceptionMessage: " + ex.Message + ". [" + this.Name + "] By [" + SessionInfo.empName + "]");
}
}
private void saveButton_Click(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(qestValueText.Text) && ID != 0)
{
try
{
int qestValue = int.Parse(qestValueText.Text);
String sql = "update clients set receivingPayments =receivingPayments+" + qestValue + " where id = " + ID + "";
conn.SQLUPDATE(sql, true);
qestValueText.Text = "";
ID = 0;
agentNameText.Text = "";
}
catch (Exception ex)
{
MessageBox.Show("خطأ ف البيانات المدخلة");
Logger.WriteLog("[" + DateTime.Now + "] ExceptionString: " + ex.ToString() + " InnerException: " + ex.InnerException + " ExceptionMessage: " + ex.Message + ". [" + this.Name + "] By [" + SessionInfo.empName + "]");
}
}
else
{
MessageBox.Show("برجاء اتمام البيانات");
}
}
private void button1_Click(object sender, EventArgs e)
{
if (comboBox1.SelectedItem != null && !String.IsNullOrEmpty(avaliableQuntity_txt.Text))
{
try
{
conn.startConnection();
int unitID = int.Parse((comboBox1.SelectedItem as ComboBoxItem).value.ToString());
int quntity = int.Parse(avaliableQuntity_txt.Text);
int price = int.Parse(unitPriceTxt.Text);
String query = "UPDATE units SET available_units =available_units +" + quntity + " , unit_price=" + price + " where ID=" + unitID + " ";
conn.SQLUPDATE(query, true);
}
catch (Exception ex)
{
MessageBox.Show("خطأ ف البيانات المدخلة");
Logger.WriteLog("[" + DateTime.Now + "] ExceptionString: " + ex.ToString() + " InnerException: " + ex.InnerException + " ExceptionMessage: " + ex.Message + ". [" + this.Name + "] By [" + SessionInfo.empName + "]");
}
}
else
{
MessageBox.Show("برجاء اتمام البيانات");
}
}
private void button1_Click(object sender, EventArgs e)
{
#region Validation Region
//validation
{
if (string.IsNullOrWhiteSpace(clientName.Text))
{
nameErr = new ErrorProvider();
nameErr.SetError(clientName, "يجب إدخال إسم العميل ");
arr[0] = false;
}
else
{
// z=true;
arr[0] = true;
if (nameErr != null)
{
nameErr.Clear();
}
}
if (InsertNationalIdChecker(nationalId.Text) || string.IsNullOrWhiteSpace(nationalId.Text) || (nationalId.Text.Length != 14 && nationalId.Text.Length != 16))
{
nationalIdErr = new ErrorProvider();
nationalIdErr.SetError(nationalId, "خطأ متعلق بالرقم القومى متواجد قبل ذلك او ليس 14 رقم او 16 فى حاله اكتر من وحده");
arr[1] = false;
}
else
{
// z=true;
if (nationalIdErr != null)
{
nationalIdErr.Clear();
}
arr[1] = true;
}
if (string.IsNullOrWhiteSpace(membershipId.Text) && !entsabCheck.Checked)
{
membershipIdErr = new ErrorProvider();
membershipIdErr.SetError(membershipId, "يجب إدخال رقم العضوية ");
// z=false;
arr[2] = false;
}
else
{
//z=true;
if (membershipIdErr != null)
{
membershipIdErr.Clear();
}
arr[2] = true;
}
if (string.IsNullOrWhiteSpace(phoneNumber.Text))
{
phoneErr = new ErrorProvider();
phoneErr.SetError(phoneNumber, "يجب إدخال رقم ادخال رقم التليفون ");
//z=false;
arr[3] = false;
}
else
{
//z=true;
if (phoneErr != null)
{
phoneErr.Clear();
}
arr[3] = true;
}
if (string.IsNullOrWhiteSpace(address.Text))
{
addressErr = new ErrorProvider();
addressErr.SetError(address, "يجب إدخال العنوان");
//z=false;
arr[4] = false;
}
else
{
//z=true;
if (addressErr != null)
{
addressErr.Clear();
}
// unitTypeErr = null;
arr[4] = true;
}
if (string.IsNullOrWhiteSpace(unitType.Text))
{
unitTypeErr = new ErrorProvider();
unitTypeErr.SetError(unitType, "يجب إدخال نوع الوحدة");
//z=false;
arr[5] = false;
}
else
{
//z=true;
if (unitTypeErr != null)
{
unitTypeErr.Clear();
}
arr[5] = true;
}
if (entsabCheck.Checked)
{
if (string.IsNullOrWhiteSpace(intesabValue.Text))
{
entesabMoneyErr = new ErrorProvider();
entesabMoneyErr.SetError(intesabValue, "يجب إدخال قيمة المبلغ المدفوع للإنتساب ");
//z=false;
arr[7] = false;
}
else
{
//z=true;
if (entesabMoneyErr != null)
{
entesabMoneyErr.Clear();
}
arr[7] = true;
}
if (string.IsNullOrWhiteSpace(intesabAccount.Text))
{
entesabAccErr = new ErrorProvider();
entesabAccErr.SetError(intesabAccount, "يجب إدخال نوع الحساب ");
//z=false;
arr[9] = false;
}
else
{
//z=true;
if (entesabAccErr != null)
{
entesabAccErr.Clear();
}
arr[9] = true;
}
}
}
#endregion
if (checkfull(arr))
{
try
{
#region insert in Clients Table
if (entsabCheck.Checked)
{
membershipId.Text = "0";
}
String sqlInsert = "insert into Clients(membership_id,client_name,phone_number,address,national_id,deleted,montaseb,delivered,check_out,description,Group_id,TnazolState)"
+ "values(" + int.Parse(membershipId.Text) + ",'" + clientName.Text + "','" + phoneNumber.Text + "','" + address.Text + "','" + nationalId.Text + "','N','N','N','N','" + description.Text + "'," + photosGroup_id + ",'N')";
if (c1.SQLUPDATE(sqlInsert, false))
#endregion
{
#region return the inserted id
String subquery = "select * from Clients where national_id='" + nationalId.Text + "'";
c1.SQLCODE(subquery, false);
int clientId = 0;
while (c1.myReader.Read())
{
clientId = int.Parse(c1.myReader["ID"].ToString());
}
#endregion
#region insert in Clients Units Table
int unitId = int.Parse((unitType.SelectedItem as ComboBoxItem).value);
String sql2 = "insert into ClientsUnits(client_id,unit_id,RecoredState)values(" + clientId + "," + unitId + ",'N')";
c1.SQLUPDATE(sql2, false);
#endregion
if (int.Parse(moqademValue.Text) > int.Parse("0"))
{
#region insert Mo2dam data if not empty
String da = moqademDate.Value.ToString("yyyy/MM/dd");
String moqademSql = "insert into first_paids (client_id,paid_value,paid_date,bank_id) values (" + clientId + "," + int.Parse(moqademValue.Text) + ",#" + da + "#," + int.Parse((accountType.SelectedItem as ComboBoxItem).value) + ")";
c1.SQLUPDATE(moqademSql, false);
#endregion
}
if (entsabCheck.Checked)
{
#region insert Entsab Data if checked
String da1 = intesabDate.Value.ToString("yyyy/MM/dd");
String moqademSql = "insert into montsben (client_id,paid_value,paid_date,bank_id) values (" + clientId + "," + int.Parse(intesabValue.Text) + ",#" + da1 + "#," + int.Parse((intesabAccount.SelectedItem as ComboBoxItem).value) + ")";
c1.SQLUPDATE(moqademSql, false);
String updatesql = "update Clients set montaseb='Y',membership_id =0 where ID=" + clientId;
c1.SQLUPDATE(updatesql, false);
#endregion
}
#region Decreas Available Units
int avaiableunits = 0;
String unitsSql = "select available_units from units where unit_type=" + int.Parse(unitType.Text);
c1.SQLCODE(unitsSql, false);
if (c1.myReader.Read())
{
avaiableunits = int.Parse(c1.myReader["available_units"].ToString());
}
avaiableunits--;
String updateUnitsSql = "update units set available_units=" + avaiableunits + " where unit_type=" + int.Parse(unitType.Text);
c1.SQLUPDATE(updateUnitsSql, true);
if (avaiableunits < 0)
{
MessageBox.Show("تم الحجز لكن عدد الوحدات غير كاافي ");
}
clearFormData();
#endregion
}
}
catch (Exception ex)
{
MessageBox.Show("خطأ ف البيانات المدخلة");
Logger.WriteLog("[" + DateTime.Now + "] ExceptionString: " + ex.ToString() + " InnerException: " + ex.InnerException + " ExceptionMessage: " + ex.Message + ". [" + this.Name + "] By [" + SessionInfo.empName + "]");
}
#region Idk What is this
if (nameErr != null)
{
nameErr.Clear();
}
if (nationalIdErr != null)
{
nationalIdErr.Clear();
}
if (membershipIdErr != null)
{
membershipIdErr.Clear();
}
if (phoneErr != null)
{
phoneErr.Clear();
}
if (addressErr != null)
{
addressErr.Clear();
}
if (unitTypeErr != null)
{
unitTypeErr.Clear();
}
if (entesabMoneyErr != null)
{
entesabMoneyErr.Clear();
}
if (entesabAccErr != null)
{
entesabAccErr.Clear();
}
#endregion
}
else
{
MessageBox.Show("خطأ متعلق بالبيانات");
}
}
private void deleteLetterBtn_Click(object sender, EventArgs e)
{
Dbonj.SQLUPDATE("delete from WarningLetters where LetterNumber=" + letterNumberTxt.Text + " ", true);
ClearFormValues();
}
private void button1_Click(object sender, EventArgs e)
{
//validate
#region ay 5ara w 5las
if (string.IsNullOrWhiteSpace(clientName.Text))
{
err[0] = new ErrorProvider();
err[0].SetError(clientName, "يجب إدخال إسم العميل ");
arr[0] = false;
}
else
{
arr[0] = true;
if (err[0] != null)
{
err[0].Clear();
}
}
if (InsertNationalIdChecker(nationalId.Text) || string.IsNullOrWhiteSpace(nationalId.Text) || (nationalId.Text.Length != 14 && nationalId.Text.Length != 16))
{
err[1] = new ErrorProvider();
err[1].SetError(nationalId, "خطأ متعلق بالرقم القومى متواجد قبل ذلك او ليس 14 رقم او 16 فى حاله اكتر من وحده");
arr[1] = false;
}
else
{
// z=true;
if (err[1] != null)
{
err[1].Clear();
}
arr[1] = true;
}
if (string.IsNullOrWhiteSpace(membershipId.Text) && !entsabCheck.Checked)
{
err[2] = new ErrorProvider();
err[2].SetError(membershipId, "يجب إدخال رقم العضوية ");
// z=false;
arr[2] = false;
}
else
{
//z=true;
if (err[2] != null)
{
err[2].Clear();
}
arr[2] = true;
}
if (string.IsNullOrWhiteSpace(phoneNumber.Text))
{
err[3] = new ErrorProvider();
err[3].SetError(phoneNumber, "يجب إدخال رقم ادخال رقم التليفون ");
//z=false;
arr[3] = false;
}
else
{
//z=true;
if (err[3] != null)
{
err[3].Clear();
}
arr[3] = true;
}
if (string.IsNullOrWhiteSpace(address.Text))
{
err[4] = new ErrorProvider();
err[4].SetError(address, "يجب إدخال العنوان");
//z=false;
arr[4] = false;
}
else
{
//z=true;
if (err[4] != null)
{
err[4].Clear();
}
// unitTypeErr = null;
arr[4] = true;
}
#endregion
if (checkfull(arr))
{
if (entsabCheck.Checked)
{
String sqlInsert = "insert into Clients(membership_id,client_name,phone_number,address,national_id,deleted,montaseb,delivered,check_out,description)"
+ "values(0,'" + clientName.Text + "','" + phoneNumber.Text + "','" + address.Text + "','" + nationalId.Text + "','N','Y','N','N','" + description.Text + "')";
if (c1.SQLUPDATE(sqlInsert, true))
{
currentTnazolOp.MotnazelToComplete = true;
currentTnazolOp.MotnazelToNationalId = nationalId.Text;
MessageBox.Show("تم حفظ بيانات المتنازل الية يمكن اتمام عملبة التنازل");
this.Close();
}
}
else
{
try
{
String sqlInsert = "insert into Clients(membership_id,client_name,phone_number,address,national_id,deleted,montaseb,delivered,check_out,description)"
+ "values(" + int.Parse(membershipId.Text) + ",'" + clientName.Text + "','" + phoneNumber.Text + "','" + address.Text + "','" + nationalId.Text + "','N','N','N','N','" + description.Text + "')";
if (c1.SQLUPDATE(sqlInsert, true))
{
currentTnazolOp.MotnazelToComplete = true;
currentTnazolOp.MotnazelToNationalId = nationalId.Text;
MessageBox.Show("تم حفظ بيانات المتنازل الية يمكن اتمام عملبة التنازل");
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("خطأ ف العملية");
Logger.WriteLog("[" + DateTime.Now + "] ExceptionString: " + ex.ToString() + " InnerException: " + ex.InnerException + " ExceptionMessage: " + ex.Message + ". [" + this.Name + "] By [" + SessionInfo.empName + "]");
}
}
}
else
{
MessageBox.Show("يوجد حقول فارغة ");
}
}
private bool InsertNewTrans()
{
return(conObj.SQLUPDATE("insert into transactions (group_id,photo_id) values (" + groupID + "," + phCount++ + ")", true));
}
private void editButton_Click(object sender, EventArgs e)
{
String privi = "";
if (addEmployeeCH.Checked)
{
privi += "0";
}
if (addUnitsCH.Checked)
{
privi += "1";
}
if (addNewUnitsCh.Checked)
{
privi += "2";
}
if (addClientCH.Checked)
{
privi += "3";
}
if (reportCH.Checked)
{
privi += "4";
}
if (gardCH.Checked)
{
privi += "5";
}
if (searchChequeCH.Checked)
{
privi += "6";
}
if (searchQestCH.Checked)
{
privi += "7";
}
if (showChequeCH.Checked)
{
privi += "8";
}
if (ta5seesCH.Checked)
{
privi += "9";
}
if (sadadTa5seesCH.Checked)
{
privi += "a";
}
if (montasebeenCH.Checked)
{
privi += "b";
}
if (EditClientsDataCH.Checked)
{
privi += "c";
}
if (EditChequesCH.Checked)
{
privi += "d";
}
if (editAqsatCH.Checked)
{
privi += "e";
}
if (unitMas7oobaCH.Checked)
{
privi += "f";
}
if (tanazolCH.Checked)
{
privi += "g";
}
if (moqdematCH.Checked)
{
privi += "h";
}
if (sa7bCH.Checked)
{
privi += "i";
}
if (payQestCH.Checked)
{
privi += "j";
}
if (bankAccountsCH.Checked)
{
privi += "k";
}
if (addChequeCH.Checked)
{
privi += "l";
}
if (transeferUnitCH.Checked)
{
privi += "m";
}
if (settingsCH.Checked)
{
privi += "n";
}
String upSq = "update employees set user_Name='" + userNameText.Text.ToString() + "',user_password='******',privlages='" + privi + "'where employee_name='" + employeeNameText.Text.ToString() + "'";
c.SQLUPDATE(upSq, true);
}
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 + "]");
}
}
}
private void button4_Click(object sender, EventArgs e)
{
//validate
if (string.IsNullOrWhiteSpace(nationalIDMota.Text))
{
err = new ErrorProvider();
err.SetError(nationalIDMota, "يجب إدخال الرقم القومي");
}
else
{
if (err != null)
{
err.Clear();
}
}
//insert into tanazolat
if (err == null && MotnazelToComplete && motnazelID != 0 && !string.IsNullOrEmpty(MotnazelToNationalId))
{
try
{
String motanazaElleh = MotnazelToNationalId;
String subquery = "select ID from Clients where national_id='" + motanazaElleh + "'";
c1.SQLCODE(subquery, false);
int ToID = 0;
int unitType = 0;
while (c1.myReader.Read())
{
ToID = int.Parse(c1.myReader["ID"].ToString());
}
if (ToID != 0 && motnazelID != 0)
{
String da = tanazolDate.Value.ToString("yyyy/MM/dd");
String query1 = "insert into tanazolat (from_id,to_id,tanazol_date) values (" + motnazelID + "," + ToID + ",#" + da + "#)";
if (c1.SQLUPDATE(query1, false))
{
String query2 = "update Clients set TnazolState ='F' where id=" + motnazelID + "";
c1.SQLUPDATE(query2, false);
String query3 = "update Clients set TnazolState ='T' where id=" + ToID + "";
c1.SQLUPDATE(query3, false);
//We need to update aqsat history to be with the new client ID
String query4 = "update aqsat set client_id=" + ToID + ",details='تم نقل القسط بعد التنازل' where client_id=" + motnazelID + "";
c1.SQLUPDATE(query4, false);
String query5 = "update first_paids set client_id=" + ToID + " where client_id=" + motnazelID + "";
c1.SQLUPDATE(query5, false);
String query6 = "update T5sesMoney set client_id =" + ToID + " where client_id=" + motnazelID + "";
c1.SQLUPDATE(query6, false);
//
String unitTypeTanazolSql = "select * from ClientsUnits where client_id=" + motnazelID + " ORDER BY ClientsUnits.ID DESC";
c1.SQLCODE(unitTypeTanazolSql, false);
if (c1.myReader.Read())
{
unitType = int.Parse(c1.myReader["unit_id"].ToString());
}
String sql2 = "insert into ClientsUnits(client_id,unit_id,RecoredState)values(" + ToID + "," + unitType + ",'N')";
c1.SQLUPDATE(sql2, true);
FunctionsClass.updtaeMyScriptHistory(motnazelID);
this.Close();
}
}
}
catch (Exception ex)
{
MessageBox.Show("خطأ ف البيانات المدخلة");
Logger.WriteLog("[" + DateTime.Now + "] ExceptionString: " + ex.ToString() + " InnerException: " + ex.InnerException + " ExceptionMessage: " + ex.Message + ". [" + this.Name + "] By [" + SessionInfo.empName + "]");
}
}
else
{
MessageBox.Show("يوجد خطأ, اما انك لم تدخل بيانات العميل الجديد او أنك لم تدخل الرقم القومي للعميل القديم ");
}
}
private void transferButton_Click(object sender, EventArgs e)
{
if (clientId != 0)
{
#region Func
if (string.IsNullOrWhiteSpace(nationalIdText.Text))
{
err = new ErrorProvider();
err.SetError(nationalIdText, "يجب إدخال الرقم القومي");
}
else
{
if (err != null)
{
err.Clear();
}
}
if (string.IsNullOrWhiteSpace(unitType.Text))
{
unitErr = new ErrorProvider();
err.SetError(unitType, "يجب إدخال نوع الوحدة المحول إليها ");
}
else
{
if (unitErr != null)
{
unitErr.Clear();
}
}
//Sql commands
if (!string.IsNullOrWhiteSpace(unitType.Text) && !string.IsNullOrWhiteSpace(nationalIdText.Text) && unitType.Text != currentUnitState.Text)
{
try
{
String selectUnit = "select ID from units where unit_type=" + int.Parse(unitType.Text.ToString());
c1.SQLCODE(selectUnit, false);
int unittyperetrie = 0;
while (c1.myReader.Read())
{
unittyperetrie = int.Parse(c1.myReader["ID"].ToString());
}
FunctionsClass.updtaeMyScriptHistory(clientId);
String sqlupdateToOld = "update ClientsUnits set RecoredState='O' where (client_id=" + clientId + " and RecoredState='N')";
c1.SQLUPDATE(sqlupdateToOld, false);
String sqlinsert = "insert into ClientsUnits(client_id,unit_id,RecoredState)values(" + clientId + "," + unittyperetrie + ",'N')";
c1.SQLUPDATE(sqlinsert, false);
String updateUnitsSql = "update units set available_units=available_units-1 where unit_type=" + int.Parse(unitType.Text);
c1.SQLUPDATE(updateUnitsSql, false);
updateUnitsSql = "update units set available_units=available_units+1 where unit_type=" + int.Parse(currentUnitState.Text);
c1.SQLUPDATE(updateUnitsSql, true);
}
catch (Exception ex)
{
MessageBox.Show("خطأ ف البيانات المدخلة");
Logger.WriteLog("[" + DateTime.Now + "] ExceptionString: " + ex.ToString() + " InnerException: " + ex.InnerException + " ExceptionMessage: " + ex.Message + ". [" + this.Name + "] By [" + SessionInfo.empName + "]");
}
//clear all errors
if (unitErr != null)
{
unitErr.Clear();
}
if (err != null)
{
err.Clear();
}
}
else
{
MessageBox.Show("خطأ ف البيانات المدخلة");
}
}
#endregion
}
private void saveButton_Click(object sender, EventArgs e)
{
try
{
if (!String.IsNullOrEmpty(employeeNameText.Text) && !String.IsNullOrEmpty(userNameText.Text) && !String.IsNullOrEmpty(passwordText.Text))
{
#region PriviSectionAssign
if (addEmployeeCH.Checked)
{
privi += "0";
}
if (addUnitsCH.Checked)
{
privi += "1";
}
if (addNewUnitsCh.Checked)
{
privi += "2";
}
if (addClientCH.Checked)
{
privi += "3";
}
if (reportCH.Checked)
{
privi += "4";
}
if (gardCH.Checked)
{
privi += "5";
}
if (searchChequeCH.Checked)
{
privi += "6";
}
if (searchQestCH.Checked)
{
privi += "7";
}
if (showChequeCH.Checked)
{
privi += "8";
}
if (ta5seesCH.Checked)
{
privi += "9";
}
if (sadadTa5seesCH.Checked)
{
privi += "a";
}
if (montasebeenCH.Checked)
{
privi += "b";
}
if (EditClientsDataCH.Checked)
{
privi += "c";
}
if (EditChequesCH.Checked)
{
privi += "d";
}
if (editAqsatCH.Checked)
{
privi += "e";
}
if (unitMas7oobaCH.Checked)
{
privi += "f";
}
if (tanazolCH.Checked)
{
privi += "g";
}
if (moqdematCH.Checked)
{
privi += "h";
}
if (sa7bCH.Checked)
{
privi += "i";
}
if (payQestCH.Checked)
{
privi += "j";
}
if (bankAccountsCH.Checked)
{
privi += "k";
}
if (addChequeCH.Checked)
{
privi += "l";
}
if (transeferUnitCH.Checked)
{
privi += "m";
}
if (settingsCH.Checked)
{
privi += "n";
}
#endregion
// MessageBox.Show(privi);
String sql = "insert into employees (employee_name,user_name,user_password,privlages)values('" + employeeNameText.Text + "','" + userNameText.Text + "','" + passwordText.Text + "','" + privi + "')";
con.SQLUPDATE(sql, true);
}
else
{
MessageBox.Show("برجاء اتمام البيانات");
}
}
catch (Exception ex)
{
MessageBox.Show("خطأ ف العملية");
Logger.WriteLog("[" + DateTime.Now + "] ExceptionString: " + ex.ToString() + " InnerException: " + ex.InnerException + " ExceptionMessage: " + ex.Message + ". [" + this.Name + "] By [" + SessionInfo.empName + "]");
}
}
