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 + "]"); } }