private void searchBtn_Click(object sender, EventArgs e) { conObj.startConnection(); String qury = "select id,client_name from Clients where national_id='" + nationalIdtext.Text + "' and montaseb='Y' and stopState='N'"; conObj.SQLCODE(qury, false); if (conObj.myReader.Read()) { custNameText.Text = conObj.myReader[1].ToString(); clientId = int.Parse(conObj.myReader[0].ToString()); } else { MessageBox.Show(" برجاء مراجعة الرقم القومى للعميل لا يوجد عميل منتسب بهذا الرقم القومى"); } }
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 loadBankAccounts() { banksData.Clear(); con.startConnection(); String sql = "select id,type from bank_accounts"; con.SQLCODE(sql, false); while (con.myReader.Read()) { banksData.Add(new ComboBoxItem { Text = con.myReader[1].ToString(), value = con.myReader[0].ToString() }); } }
public Mo2damat() { InitializeComponent(); conn.startConnection(); loadData(); this.ActiveControl = nationalIdtext; }
private void searchButton_Click(object sender, EventArgs e) { if (!String.IsNullOrEmpty(SheeqNumText.Text)) { try { conn.startConnection(); int SheeqNum = int.Parse(SheeqNumText.Text); String sql = "SELECT * FROM cheques WHERE cheque_number = " + SheeqNum + ""; conn.SQLCODE(sql, false); if (conn.myReader.Read()) { elmostafeedText.Text = conn.myReader["cheque_owner"].ToString(); cheeqeValue.Text = conn.myReader["cheque_value"].ToString(); dateTimePicker1.Text = conn.myReader["cheque_Esdar_Date"].ToString(); dateTimePicker2.Text = conn.myReader["cheque_Sarf_Date"].ToString(); photos_group.Add(int.Parse(conn.myReader["Group_id"].ToString())); } 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 + "]"); } } else { MessageBox.Show("برجاء اتمام البيانات"); } }
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("برجاء اتمام البيانات"); } }
public SellingOpreation() { InitializeComponent(); c1 = new ConnectionClass();; c1.startConnection(); loadData(); }
private void searchBtn_Click(object sender, EventArgs e) { conn.startConnection(); if (!String.IsNullOrEmpty(national_id.Text)) { String sql = "select * from Clients where national_id = '" + national_id.Text + "' and deleted = 'N' and Clients.check_out = 'N' and stopState='N'"; conn.SQLCODE(sql, false); if (conn.myReader.Read()) { clientName.Text = conn.myReader["client_name"].ToString(); int client_ID = int.Parse(conn.myReader["ID"].ToString()); if (mo2dmatRadio.Checked) { sql = "SELECT first_paids.details as 'التفاصيل',paid_value as 'القيمة المدفوعة', bank_accounts.type as 'الحساب المستلم',paid_date AS 'تاريخ السداد',Clients.client_name as 'اسم العميل' ,first_paids.group_id,first_paids.ID FROM((first_paids INNER JOIN bank_accounts ON first_paids.bank_id = bank_accounts.ID) INNER JOIN Clients ON (first_paids.client_id = Clients.ID and Clients.check_out = 'N' and stopState='N')) where first_paids.client_id = " + client_ID + " order by paid_date"; } else { int PaymentType = (type0Radio.Checked) ? 0 : 1; sql = "SELECT montsben.details as 'التفاصيل',paid_value as 'القيمة المدفوعة', bank_accounts.type as 'الحساب المستلم',paid_date AS 'تاريخ السداد',Clients.client_name as 'اسم العميل' ,montsben.group_id,montsben.ID FROM((montsben INNER JOIN bank_accounts ON montsben.bank_id = bank_accounts.ID) INNER JOIN Clients ON (montsben.client_id = Clients.ID and Clients.check_out = 'N')) where PaymentType=" + PaymentType + " and montsben.client_id = " + client_ID + " order by paid_date"; } conn.SQLCODE(sql, true); DataTable table = new DataTable(); conn.myAdabter.Fill(table); dataGridView1.DataSource = table; dataGridView1.Columns[6].Visible = false; dataGridView1.Columns[5].Visible = false; dataGridView1.Columns[4].Visible = false; } } }
public showSheeqs() { conn = new ConnectionClass(); conn.startConnection(); InitializeComponent(); load(); photos_group = new List <int>(); }
public ControlPanel(String prev) { InitializeComponent(); con.startConnection(); priv = prev; addpriv(); clientReportObj = new ClientReportForm(); }
private void LoadLastTrans() { conObj.startConnection(); conObj.SQLCODE("select max(group_id) as oldGroupId from transactions;", false); while (conObj.myReader.Read()) { groupID = int.Parse(conObj.myReader["oldGroupId"].ToString()) + 1; } }
private void LoadCustNames() { try { conn.startConnection(); String tmpSql = "SELECT client_name FROM Clients ORDER BY client_name"; conn.SQLCODE(tmpSql, false); while (conn.myReader.Read()) { cust_nameComb.Items.Add(conn.myReader[0].ToString()); } } catch (Exception ex) { MessageBox.Show("خطأ اثناء تحميل البيانات"); Logger.WriteLog("[" + DateTime.Now + "] ExceptionString: " + ex.ToString() + " InnerException: " + ex.InnerException + " ExceptionMessage: " + ex.Message + ". [" + this.Name + "] By [" + SessionInfo.empName + "]"); } }
public Gard() { InitializeComponent(); conn = new ConnectionClass(); conn.startConnection(); loadAreas(); load(); loadAvailableUnits(); }
public TransferUnit() { InitializeComponent(); c1.startConnection(); FunctionsClass.loadAreaTyeps(); foreach (ComboBoxItem item in FunctionsClass.areasData) { unitType.Items.Add(item); } }
private void button1_Click(object sender, EventArgs e) { conn.startConnection(); if (checkBox1.Checked) { try { String date1 = dateTimePicker1.Value.ToString("yyyy/MM/dd"); String date2 = dateTimePicker2.Value.ToString("yyyy/MM/dd"); String sql = "SELECT aqsat.details as 'تفاصيل الايصالات', bank_accounts.type as 'الحساب المستلم',qest_date AS 'تاريخ القسط',aqsat.qest_value as 'قيمة القسط', Clients.client_name as 'اسم العميل' ,aqsat.group_id,aqsat.ID FROM((aqsat INNER JOIN bank_accounts ON aqsat.bank_id = bank_accounts.ID) INNER JOIN Clients ON (aqsat.client_id = Clients.ID and Clients.check_out = 'N')) WHERE qest_date between #" + date1 + "# and #" + date2 + "# order by qest_date"; conn.SQLCODE(sql, true); DataTable table = new DataTable(); conn.myAdabter.Fill(table); dataGridView1.DataSource = table; dataGridView1.Columns[5].Visible = false; dataGridView1.Columns[6].Visible = false; this.Invoke((MethodInvoker) delegate() { sumValues(3); }); } catch (Exception ex) { MessageBox.Show("خطأ ف البيانات المدخلة"); Logger.WriteLog("[" + DateTime.Now + "] ExceptionString: " + ex.ToString() + " InnerException: " + ex.InnerException + " ExceptionMessage: " + ex.Message + ". [" + this.Name + "] By [" + SessionInfo.empName + "]"); } } else { if (!String.IsNullOrEmpty(national_id.Text)) { String sql = "select * from Clients where national_id = '" + national_id.Text + "' and deleted = 'N' and Clients.check_out = 'N'"; conn.SQLCODE(sql, false); if (conn.myReader.Read()) { clientName.Text = conn.myReader["client_name"].ToString(); ID = int.Parse(conn.myReader["ID"].ToString()); } else { MessageBox.Show("لا يوجد عضو بهذا الرقم القومي "); } String sql2 = "select aqsat.details as 'تفاصيل الايصالات' ,bank_accounts.type as 'الحساب المستلم',qest_date AS 'تاريخ القسط',aqsat.qest_value as 'قيمة القسط' ,group_id,aqsat.ID from (aqsat INNER JOIN bank_accounts ON aqsat.bank_id = bank_accounts.ID) where client_id =" + ID + " order by qest_date"; conn.SQLCODE(sql2, true); DataTable table = new DataTable(); conn.myAdabter.Fill(table); dataGridView1.DataSource = table; dataGridView1.Columns[4].Visible = false; dataGridView1.Columns[5].Visible = false; this.Invoke((MethodInvoker) delegate() { sumValues(3); }); } else { MessageBox.Show("برجاء اتمام البيانات"); } } }
public editeQest(String qestVAlue2, String qestDate2, string details, String bank7esab2, int ID2, int groupId) { InitializeComponent(); foreach (ComboBoxItem item in FunctionsClass.banksData) { comboBox1.Items.Add(item); } conn.startConnection(); value.Text = qestVAlue2; dateTimePicker1.Text = qestDate2; comboBox1.Text = bank7esab2; detailsTxt.Text = details; ID = ID2; this.groupId = groupId; if (groupId == 0) { addAttachmentBtn.Enabled = true; } }
private void searchBtn_Click(object sender, EventArgs e) { conn.startConnection(); int ID = -1; try { if (!String.IsNullOrEmpty(national_id.Text)) { String sql = "select * from Clients where national_id = '" + national_id.Text + "' and deleted = 'N' and Clients.check_out = 'N'"; conn.SQLCODE(sql, false); if (conn.myReader.Read()) { clientName.Text = conn.myReader["client_name"].ToString(); ID = int.Parse(conn.myReader["ID"].ToString()); String sql2 = @"SELECT client_name as 'الاسم', client_id, SUM(PAIDVALUE) AS 'اجمالي المدفوع في السنه', DatePart('yyyy', [YEAR]) AS 'السنه' FROM (SELECT Clients.client_name, aqsat.client_id, aqsat.qest_value AS PAIDVALUE, aqsat.qest_date AS [YEAR] FROM (aqsat LEFT OUTER JOIN Clients ON aqsat.client_id = Clients.ID) UNION SELECT Clients_2.client_name, first_paids.client_id, first_paids.paid_value AS FIRSTSUM, first_paids.paid_date AS [YEAR] FROM (first_paids LEFT OUTER JOIN Clients Clients_2 ON first_paids.client_id = Clients_2.ID) UNION SELECT Clients_1.client_name, T5sesMoney.client_id, T5sesMoney.paid_value AS MONTSEBSUM, T5sesMoney.paid_date AS [YEAR] FROM (Clients Clients_1 INNER JOIN T5sesMoney ON T5sesMoney.client_id = Clients_1.ID)) temp GROUP BY client_name, client_id, DatePart('yyyy', [YEAR]) HAVING (client_id = " + ID + ") ORDER BY client_id "; conn.SQLCODE(sql2, true); DataTable table = new DataTable(); conn.myAdabter.Fill(table); dataGridView1.DataSource = table; dataGridView1.Columns[1].Visible = false; //dataGridView1.Rows[0].Cells[0] for (int i = 1; i < dataGridView1.Rows.Count; i++) { dataGridView1.Rows[i].Cells[0].Value = ""; } } 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(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 searchButton_Click(object sender, EventArgs e) { conn.startConnection(); if (!String.IsNullOrEmpty(nationalIdtext.Text)) { conn.startConnection(); String sql = "select * from Clients where national_id = '" + nationalIdtext.Text + "'"; conn.SQLCODE(sql, false); if (conn.myReader.Read()) { agentNameText.Text = conn.myReader["client_name"].ToString(); ID = int.Parse(conn.myReader["ID"].ToString()); } else { MessageBox.Show("لا يوجد بيانات عميل بهذا الرقم"); } } 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 + "]"); } }
/// <summary> /// /// </summary> private void loadGroup() { conObj.startConnection(); String inList = string.Join(",", group_id); if (!String.IsNullOrEmpty(inList)) { String sql = "select * from transactions where group_id in (" + inList + ")"; conObj.SQLCODE(sql, false); while (conObj.myReader.Read()) { photosNames.Add(conObj.myReader["group_id"] + "-" + conObj.myReader["photo_id"]); } } }
private void LoadCheckOut() { if (unitTypes.SelectedIndex != -1) { try { conObj.startConnection(); String sql = "SELECT Clients.client_name as 'العميل المنسحب' ,units.unit_type as 'نوع الوحدة' ,cheques.cheque_value as 'قيمة الشيك' , cheques.cheque_number as 'رقم الشيك', cheques.cheque_owner as 'مستفيد الشيك', cheques.cheque_Esdar_Date as 'تاريخ اصدار الشيك' FROM(((Clients INNER JOIN ClientsUnits ON Clients.ID = ClientsUnits.client_id) left JOIN cheques ON Clients.ID = cheques.client_id) INNER JOIN units ON ClientsUnits.unit_id = units.ID) WHERE(units.unit_type = " + int.Parse((unitTypes.SelectedItem as ComboBoxItem).Text) + " and ClientsUnits.RecoredState='C')"; conObj.SQLCODE(sql, true); DataTable dtNotValid = new DataTable(); conObj.myAdabter.Fill(dtNotValid); dataGridView1.DataSource = dtNotValid; } 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 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 loginButton_Click(object sender, EventArgs e) { con.startConnection(); String sql = "select * from employees where user_name='" + userNameText.Text + "' and user_password='******'"; con.SQLCODE(sql, false); if (con.myReader.Read()) { SessionInfo.empName = con.myReader["employee_name"].ToString(); SessionInfo.userName = con.myReader["user_name"].ToString(); SessionInfo.password = con.myReader["user_password"].ToString(); SessionInfo.privlages = con.myReader["privlages"].ToString(); this.DialogResult = DialogResult.OK; this.Close(); } else { MessageBox.Show("رجاء مراجعه بيانات الدخول"); } }
public updateEmployee(String EmName) { InitializeComponent(); c.startConnection(); employeeName = EmName; String sqlaya = "select*from employees where employee_name='" + employeeName + "'"; c.SQLCODE(sqlaya, false); if (c.myReader.Read()) { employeeNameText.Text = employeeName; employeeNameText.Enabled = false; userNameText.Text = c.myReader["user_name"].ToString(); passwordText.Text = c.myReader["user_password"].ToString(); priv = c.myReader["privlages"].ToString(); upPriv(); } else { MessageBox.Show("لا توجد بيانات لهذا العميل"); this.Close(); } }
private void searchBtn_Click(object sender, EventArgs e) { ClearFormValues(); try { if (!string.IsNullOrEmpty(letterNumberTxt.Text)) { Dbonj.startConnection(); Dbonj.SQLCODE("select * from WarningLetters where LetterNumber=" + letterNumberTxt.Text + "", false); if (Dbonj.myReader.Read()) { subjectTxt.Text = Dbonj.myReader["LetterSubject"].ToString(); notesTxt.Text = Dbonj.myReader["LetterNotes"].ToString(); replyTxt.Text = Dbonj.myReader["LetterReply"].ToString(); LetterType.Text = Dbonj.myReader["LetterType"].ToString(); dateTimePicker1.Text = Dbonj.myReader["LetterDate"].ToString(); photosGroup_id = int.Parse(Dbonj.myReader["group_id"].ToString()); attchmentsBtn.Enabled = true; saveUpdateBtn.Enabled = true; deleteLetterBtn.Enabled = true; } else { MessageBox.Show("لا توجد بيانات بهذا الرقم"); } } 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 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) { if (!String.IsNullOrEmpty(sheeqNumText.Text)) { try { conn.startConnection(); double SheeqNum = double.Parse(sheeqNumText.Text); String sql = "SELECT * FROM cheques WHERE cheque_number = " + SheeqNum + ""; conn.SQLCODE(sql, false); if (conn.myReader.Read()) { found = true; sheequeOwner_text.Text = conn.myReader["cheque_owner"].ToString(); valueText.Text = conn.myReader["cheque_value"].ToString(); dateTimePickerEsdar.Text = conn.myReader["cheque_Esdar_Date"].ToString(); dateTimePicker1Sarf.Text = conn.myReader["cheque_Sarf_Date"].ToString(); ID = int.Parse(conn.myReader["ID"].ToString()); sheqNumUpdate.Text = sheeqNumText.Text; } 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 + "]"); } } else { MessageBox.Show("برجاء اتمام البيانات"); } }
private void FillReportBtn_Click(object sender, EventArgs e) { warningLettersBtn.Text = "خطابات و انذارات [0]"; if (!String.IsNullOrEmpty(nationalSearch.Text)) { stoppingGroupbox.Visible = false; try { conObj.startConnection(); String sql = "SELECT Clients.stopReason,Clients.stopDate,Clients.stopState,units.unit_price,units.unit_type, Clients.client_name,Clients.receivingPayments, ClientsUnits.ID as joinid, Clients.membership_id, Clients.phone_number, Clients.address, Clients.deleted, Clients.national_id, Clients.montaseb, Clients.delivered,Clients.ID, Clients.unit_number, Clients.tour_number, Clients.check_out, Clients.description, Clients.TnazolState FROM ((Clients INNER JOIN ClientsUnits ON Clients.ID = ClientsUnits.client_id) INNER JOIN units ON ClientsUnits.unit_id = units.ID) WHERE(Clients.national_id = '" + nationalSearch.Text + "' and check_out = 'N') ORDER BY ClientsUnits.ID DESC"; conObj.SQLCODE(sql, false); if (conObj.myReader.Read()) { #region Load Client Data #region Display Basic Info About the Client client_id = int.Parse(conObj.myReader["id"].ToString()); client_NameTxt.Text = conObj.myReader["client_name"].ToString(); client_PhoneTxt.Text = conObj.myReader["phone_number"].ToString(); client_NationalTxt.Text = conObj.myReader["national_id"].ToString(); if (conObj.myReader["stopState"].ToString() == "Y") { stoppingGroupbox.Visible = true; stoppingDateLab.Text = conObj.myReader["stopDate"].ToString(); stopReasonTxt.Text = conObj.myReader["stopReason"].ToString(); } if (conObj.myReader["membership_id"].ToString() == "0") { client_MemberShipTxt.Text = ""; } else { client_MemberShipTxt.Text = conObj.myReader["membership_id"].ToString(); } client_AddressTxt.Text = conObj.myReader["address"].ToString(); client_TourNumTxt.Text = conObj.myReader["tour_number"].ToString(); client_UnitNumTxt.Text = conObj.myReader["unit_number"].ToString(); recivePaymentValueTxt.Text = "0"; recivePaymentValueTxt.Text = conObj.myReader["receivingPayments"].ToString(); unitPriceTxt.Text = conObj.myReader["unit_price"].ToString(); unitTypeLab.Text = conObj.myReader["unit_type"].ToString(); #endregion #region check Entsab State and Sum of It`s Money TnazolState = conObj.myReader["TnazolState"].ToString(); if (conObj.myReader["montaseb"].ToString() == "Y") { entsabCheckBox.Checked = true; EntsabGroup.Visible = true; sql = "select sum(paid_value) from montsben where client_id=" + client_id + " and PaymentType=0"; LoadOneCell(sql, entsabPaid_ValueTxt); if (String.IsNullOrEmpty(entsabPaid_ValueTxt.Text)) { entsabPaid_ValueTxt.Text = "0"; } sql = "select sum(paid_value) from montsben where client_id=" + client_id + " and PaymentType=1"; LoadOneCell(sql, entsabManagPaid_ValueTxt); if (String.IsNullOrEmpty(entsabManagPaid_ValueTxt.Text)) { entsabManagPaid_ValueTxt.Text = "0"; } } else { EntsabGroup.Visible = false; } #endregion #region check Tnazol State and Partner if (TnazolState != "N") { TnazolGroup.Visible = true; if (TnazolState == "T") { sql = "SELECT client_name,ID FROM Clients WHERE(ID =(SELECT From_id FROM tanazolat WHERE(to_id = " + client_id + ")))"; motnazelCheckBox.Checked = false; motnazelToCheckBox.Checked = true; conObj.SQLCODE(sql, false); if (conObj.myReader.Read()) { tnazolPartenterTxt.Text = conObj.myReader[0].ToString(); partnerID = int.Parse(conObj.myReader[1].ToString()); } if (partnerID != -1) { sql = "SELECT receivingPayments FROM Clients WHERE(ID =" + partnerID + ")"; conObj.SQLCODE(sql, false); if (conObj.myReader.Read()) { int oldre = int.Parse(conObj.myReader[0].ToString()); recivePaymentValueTxt.Text = (int.Parse(recivePaymentValueTxt.Text) + oldre).ToString(); } } } if (TnazolState == "F") { sql = "SELECT client_name FROM Clients WHERE(ID =(SELECT to_id FROM tanazolat WHERE(from_id = " + client_id + ")))"; motnazelCheckBox.Checked = true; motnazelToCheckBox.Checked = false; LoadOneCell(sql, tnazolPartenterTxt); } } else { TnazolGroup.Visible = false; } #endregion #region Load Paid Fist Values Sum sql = "select sum(paid_value) from first_paids HAVING client_id=" + client_id + " OR client_id=" + partnerID + ""; LoadOneCell(sql, client_Firstpaid_SumTxt); if (String.IsNullOrEmpty(client_Firstpaid_SumTxt.Text)) { client_Firstpaid_SumTxt.Text = "0"; } #endregion #region Load T5ses Money sum sql = "select sum(paid_value) from T5sesMoney HAVING client_id=" + client_id + " OR client_id=" + partnerID + ""; LoadOneCell(sql, client_T5ses_SumTxt); if (String.IsNullOrEmpty(client_T5ses_SumTxt.Text)) { client_T5ses_SumTxt.Text = "0"; } #endregion #region Load Aqsat Total Sum sql = "select sum(qest_value) from aqsat HAVING client_id=" + client_id + " OR client_id=" + partnerID + ""; LoadOneCell(sql, client_Aqsat_SumTxt); if (String.IsNullOrEmpty(client_Aqsat_SumTxt.Text)) { client_Aqsat_SumTxt.Text = "0"; } #endregion #region Sum All data and Display them int tmp = int.Parse(client_Firstpaid_SumTxt.Text); tmp += int.Parse(client_T5ses_SumTxt.Text); tmp += int.Parse(client_Aqsat_SumTxt.Text); tmp += int.Parse(recivePaymentValueTxt.Text); client_Total_SumTxt.Text = tmp.ToString(); unitRestPriceTxt.Text = (int.Parse(unitPriceTxt.Text) - tmp).ToString(); thePercentValueTxt.Text = (0.05 * int.Parse(unitPriceTxt.Text)).ToString(); #endregion sql = "SELECT count(*) FROM WarningLetters where LetterClient_ID =" + client_id + ""; conObj.SQLCODE(sql, false); if (conObj.myReader.Read()) { warningLettersBtn.Text = "[" + conObj.myReader[0].ToString() + "]" + "خطابات الانذار"; } #endregion } 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 + "]"); } } }
public jkshgk() { InitializeComponent(); con.startConnection(); }