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