private void button1_Click(object sender, EventArgs e)
{
string user_select = "select user_id,user_name,user_password from users where user_name='" + user_txt.Text + "'";
DataSet data = new DataSet();
db.selectDB(ref data, user_select);
try
{
if (data.Tables[0].Rows.Count > 0)
{
if (data.Tables[0].Rows[0][2].ToString() == password_txt.Text)
{
new MainForm(Convert.ToInt32(data.Tables[0].Rows[0][0].ToString())).Show();
this.Close();
}
else
{
MessageBox.Show("الرقم السري خاطئ");
}
}
else
{
MessageBox.Show("المستخدم غير موجود");
}
}
catch (Exception)
{
}
}
private void AddCheckForm_Load(object sender, EventArgs e)
{
if (cases == 1)
{
if (payment.customer_combo.SelectedIndex >= 0)
{
owner_txt.Text = payment.customer_combo.SelectedItem.ToString();
}
if (ch != null)
{
id_txt.Text = ch.Id + "";
bank_txt.Text = ch.Bank;
owner_txt.Text = ch.Owner;
date_pic.Value = ch.Delv_Date;
price_txt.Text = ch.Price + "";
note_combo.SelectedItem = ch.Notes;
}
}
else if (cases == 3)
{
id_txt.Text = ch_id + "";
data = new DataSet();
db.selectDB(ref data, "SELECT * FROM checks WHERE ch_id=" + ch_id);
bank_txt.Text = data.Tables[0].Rows[0][2].ToString();
owner_txt.Text = data.Tables[0].Rows[0][3].ToString();
date_pic.Value = Convert.ToDateTime(data.Tables[0].Rows[0][4].ToString());
price_txt.Text = data.Tables[0].Rows[0][5].ToString();
note_combo.SelectedItem = data.Tables[0].Rows[0][6].ToString();
}
}
private void AddBillForm_Load(object sender, EventArgs e)
{
foreach (string s in db.ListOF("select * from teeth_type"))
{
type_combo.Items.Add(s);
}
foreach (string s in db.ListOF("select * from color_type"))
{
color_combo.Items.Add(s);
}
if (cases == 2)
{
DataSet data1 = new DataSet();
db.selectDB(ref data1, "SELECT * FROM bill WHERE id='" + bill_id + "'");
DataSet data2 = new DataSet();
db.selectDB(ref data2, "SELECT cust_name,cust_type from customer WHERE cust_id='" + data1.Tables[0].Rows[0][2] + "'");
LinkedList <string> teethes_data = db.ListOF("SELECT number from teeth where bill_id='" + bill_id + "'");
teethes.Text = "تعديل الاسنان";
save.Text = "تعديل";
id_txt.Text = data1.Tables[0].Rows[0][1].ToString();
cust_type_combo.SelectedItem = data2.Tables[0].Rows[0][1].ToString();
customer_combo.SelectedItem = data2.Tables[0].Rows[0][0].ToString();
teethes_list = new bool[49];
for (int i = 0; i < teethes_list.Length; i++)
{
teethes_list[i] = false;
}
foreach (string s in teethes_data)
{
int index = Convert.ToInt32(s);
teethes_list[index] = true;
}
teethes_txt.Text = data1.Tables[0].Rows[0][3].ToString();
color_combo.SelectedItem = data1.Tables[0].Rows[0][4].ToString();
type_combo.SelectedItem = data1.Tables[0].Rows[0][5].ToString();
price_txt.Text = data1.Tables[0].Rows[0][9].ToString();
delv_state_combo.SelectedItem = data1.Tables[0].Rows[0][6].ToString();
price = Convert.ToDouble(price_txt.Text);
notes_txt.Text = data1.Tables[0].Rows[0][10].ToString();
warrnity.Visible = false;
warr_txt.Visible = false;
}
}
private void MainForm_Load(object sender, EventArgs e)
{
new Thread(() => {
if (InvokeRequired)
{
this.Invoke(new MethodInvoker(delegate
{
user_data = new DataSet();
db.selectDB(ref user_data, "SELECT * FROM users WHERE user_id='" + Id + "'");
string title_select = user_data.Tables[0].Rows[0][2].ToString();
if (user_data.Tables[0].Rows.Count > 0)
{
title.Text = "مرحبا " + title_select;
}
user_role = user_data.Tables[0].Rows[0][4].ToString();
if (user_role != "مسؤول")
{
settings.Visible = false;
del_bill.Visible = false;
edit_cust.Visible = false;
del_cust.Visible = false;
dell_sell_bill.Visible = false;
sell_bill_gridview.Visible = false;
}
cust_type_search = "";
cust_name_search = "";
date_combo.SelectedIndex = 0;
th = new Thread(new ThreadStart(UpdateEach10Mins));
th.Start();
}
));
}
}).Start();
//RefreshCust(cust_query);
//RefreshBill(bill_query);
}
