private void RefForm()
{
txt_Name.Text = txt_Adress.Text = txt_Phone.Text = "";
txt_Money.Text = txt_Discount.Text = "0";
txt_Money.Enabled = true;
bt_save.Enabled = true;
bt_edit.Enabled = false;
using (ds = Ezzat.GetDataSet("Group_Select_All", "X"))
{
combo_Group.DataSource = ds.Tables["X"];
combo_Group.DisplayMember = "اسم المجموعة";
combo_Group.ValueMember = "الرقم المسلسل";
combo_Group.Text = "";
combo_Group.SelectedText = "اختار اسم المؤسسة";
}
using (ds = Ezzat.GetDataSet("Company_Select_All", "X"))
{
dataGridView1.DataSource = ds.Tables["X"];
}
//dataGridView1.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
private void getAllProducts()
{
using (dataSet = Ezzat.GetDataSet("Select_All", "X"))
{
dataGridView2.DataSource = dataSet.Tables["X"];
}
}
private void textBox6_TextChanged(object sender, EventArgs e)
{
using (ds = Ezzat.GetDataSet("Customer_selectSearch", "X", new SqlParameter("text", textBox6.Text)))
{
dataGridView1.DataSource = ds.Tables["X"];
}
}
private void FillCombo()
{
using (dataSet = Ezzat.GetDataSet("selectAllSupplier2", "X"))
{
dataGridView2.DataSource = dataSet.Tables["X"];
}
}
private void RefForm()
{
textBox2.Text = String.Format("{0:HH:mm:ss dd/MM/yyyy}", DateTime.Now);
using (ds = Ezzat.GetDataSet("Product_selectAll", "X"))
{
combo_Product.DataSource = ds.Tables["X"];
combo_Product.DisplayMember = "اسم المنتج";
combo_Product.ValueMember = "رقم المنتج";
combo_Product.Text = "";
combo_Product.SelectedText = "اختار اسم المنتج";
}
object o = Ezzat.ExecutedScalar("IMReturning_selectID");
txt_BillNumber.Text = o + "";
using (ds = Ezzat.GetDataSet("Supplier_selectAll", "X"))
{
combo_name.DataSource = ds.Tables["X"];
combo_name.DisplayMember = "اسم المورد";
combo_name.ValueMember = "رقم المورد";
combo_name.Text = "";
combo_name.SelectedText = "اختار اسم المورد";
}
dataGridView1.Rows.Clear();
txt_Discount.Text = txt_MaterialTotal.Text = txt_OldMoney.Text = "0.00";
txt_Prise.Text = txt_Quantity.Text = txt_TotalMoney.Text = txt_AfterDiscount.Text = "0.00";
}
private void textBox6_TextChanged(object sender, EventArgs e)
{
using (ds = Ezzat.GetDataSet("Company_Select_All_Search", "X", new SqlParameter("@Company_Name", textBox6.Text)))
{
dataGridView1.DataSource = ds.Tables["X"];
}
}
private void RefreshForm()
{
label12.Text = String.Format("{0:HH:mm:ss dd/MM/yyyy}", DateTime.Now);
using (dataSet = Ezzat.GetDataSet("selectAllCustomer", "X"))
{
combo_Cus.DataSource = dataSet.Tables["X"];
combo_Cus.DisplayMember = "Customer_Name";
combo_Cus.ValueMember = "Customer_ID";
combo_Cus.Text = "";
combo_Cus.SelectedText = "اختار اسم العميل";
}
using (dataSet = Ezzat.GetDataSet("selectAllSupplier", "X"))
{
combo_Supliers.DataSource = dataSet.Tables["X"];
combo_Supliers.DisplayMember = "Supplier_Name";
combo_Supliers.ValueMember = "Supplier_ID";
combo_Supliers.Text = "";
combo_Supliers.SelectedText = "اختار اسم المورد";
}
object o = Ezzat.ExecutedScalar("selectBankTransaction_Bill_ID");
label2.Text = o + "";
}
private void textBox2_TextChanged(object sender, EventArgs e)
{
using (ds = Ezzat.GetDataSet("select_allUsers_Search", "X", new SqlParameter("@username", textBox2.Text)))
{
dataGridView2.DataSource = ds.Tables["X"];
}
}
private void radioButton2_CheckedChanged(object sender, EventArgs e)
{
using (dataSet = Ezzat.GetDataSet("store_select_AllMaterial", "X"))
{
dataGridView1.DataSource = dataSet.Tables["X"];
}
}
private void Search()
{
using (dataSet = Ezzat.GetDataSet("_Outlay_During", "X", new SqlParameter("@Day", dateTimePicker1.Value), new SqlParameter("@Day2", dateTimePicker2.Value)))
{
dataGridView1.DataSource = dataSet.Tables["x"];
}
}
private void Total_Out()
{
using (ds = Ezzat.GetDataSet("_TotalOut", "X", new SqlParameter("@Day", dateTimePicker1.Value), new SqlParameter("@Day2", dateTimePicker2.Value)))
{
dgv_Out.DataSource = ds.Tables["X"];
}
}
private void Total_Sup()
{
using (ds = Ezzat.GetDataSet("_TotalSup", "X", new SqlParameter("@Day", dateTimePicker1.Value), new SqlParameter("@Day2", dateTimePicker2.Value)))
{
dgw_Supplier.DataSource = ds.Tables["X"];
}
}
private void FillCombo()
{
using (dataSet = Ezzat.GetDataSet("select_AllEmployee2", "X"))
{
dataGridView2.DataSource = dataSet.Tables["X"];
}
}
private void RefForm()
{
label12.Text = String.Format("{0:HH:mm:ss dd/MM/yyyy}", DateTime.Now);
object o = Ezzat.ExecutedScalar("select_OwnerReportId");
label2.Text = o.ToString();
tb_details.Text = "اكتب بيان الصنف";
richTextBox1.Text = "اكتب بيان الفاتورة ";
dataGridView1.Rows.Clear();
tb_quantity.Text = "0";
tb_price.Text = "0.00";
Bill_Total = 0;
Calcolate();
label12.Text = String.Format("{0:HH:mm:ss dd/MM/yyyy}", DateTime.Now);
using (dataSet = Ezzat.GetDataSet("Select_All", "X"))
{
combo_Materials.DataSource = dataSet.Tables["X"];
combo_Materials.DisplayMember = "اسم الصنف";
combo_Materials.ValueMember = "رفم الصنف";
combo_Materials.Text = "";
combo_Materials.SelectedText = "اختار منتج";
}
}
private void showOrder()
{
using (dataSet = Ezzat.GetDataSet("select_Orders_Day", "X", new SqlParameter("Day", dateTimePicker1.Value)))
{
dataGridView1.DataSource = dataSet.Tables["X"];
dataGridView1.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
}
private void getData()
{
using (dataSet = Ezzat.GetDataSet("select_AllJobtitle", "X"))
{
tb_job.DataSource = dataSet.Tables["X"];
tb_job.DisplayMember = "Job_Name";
}
}
private void textBox6_TextChanged(object sender, EventArgs e)
{
using (ds = Ezzat.GetDataSet("Product_selectSearch", "X", new SqlParameter("@text", textBox6.Text)))
{
dataGridView1.DataSource = ds.Tables["X"];
dataGridView1.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
}
private void Form_Material__Gard_Load(object sender, EventArgs e)
{
using (ds = Ezzat.GetDataSet("Store_Gard", "X"))
{
dataGridView1.DataSource = ds.Tables["X"];
dataGridView1.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
}
private void FillCombo()
{
using (dataSet = Ezzat.GetDataSet("selectAllBank2", "X"))
{
dataGridView2.DataSource = dataSet.Tables["X"];
}
dataGridView2.Columns[0].Width = 50;
dataGridView2.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
private void Form_Customer_Details_Load(object sender, EventArgs e)
{
using (ds = Ezzat.GetDataSet("Customer_billDetails", "X", new SqlParameter("@Bill_ID", bill_ID)))
{
dataGridView1.DataSource = ds.Tables["X"];
dataGridView1.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
ShowDetails();
}
private void Show_Limit_Load(object sender, EventArgs e)
{
using (dataSet = Ezzat.GetDataSet("select_CreditLimit"
, "X"
, new SqlParameter("@Type", f)
))
{
dataGridView1.DataSource = dataSet.Tables["X"];
}
}
private void RefrshForm()
{
using (ds = Ezzat.GetDataSet("Select_All", "X"))
{
comboProduct.DataSource = ds.Tables["X"];
comboProduct.DisplayMember = "اسم الصنف";
comboProduct.ValueMember = "رفم الصنف";
comboProduct.Text = "";
comboProduct.SelectedText = "اختار اسم الصنف";
}
}
private void Form_Customer_Debtors_Load(object sender, EventArgs e)
{
using (ds = Ezzat.GetDataSet("Customer_selectDebtors", "X"))
{
dataGridView1.DataSource = ds.Tables["X"];
dataGridView1.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
getSum();
}
private void Customer_Account_Load(object sender, EventArgs e)
{
using (dataSet = Ezzat.GetDataSet("select_AllCustomer", "X"))
{
combo_Customer.DataSource = dataSet.Tables["X"];
combo_Customer.DisplayMember = "Customer_Name";
combo_Customer.ValueMember = "Customer_ID";
combo_Customer.Text = "";
combo_Customer.SelectedText = "اختار اسم المشترى";
}
}
private void RefreshForm()
{
using (dataSet = Ezzat.GetDataSet("select_Banks", "X"))
{
combo_Bank.DataSource = dataSet.Tables["X"];
combo_Bank.DisplayMember = "Bank_Name";
combo_Bank.ValueMember = "Bank_ID";
combo_Bank.Text = "";
combo_Bank.SelectedText = "اختار اسم بنك";
}
}
private void Search()
{
using (ds = Ezzat.GetDataSet("Outlay_During", "X", new SqlParameter("@Day", dateTimePicker1.Value), new SqlParameter("@Day2", dateTimePicker2.Value)))
{
dataGridView1.DataSource = ds.Tables["x"];
dataGridView1.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridView1.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
}
private void Supplier_Account_Load(object sender, EventArgs e)
{
using (dataSet = Ezzat.GetDataSet("selectAllSupplier", "X"))
{
combo_Supliers.DataSource = dataSet.Tables["X"];
combo_Supliers.DisplayMember = "Supplier_Name";
combo_Supliers.ValueMember = "Supplier_ID";
combo_Supliers.Text = "";
combo_Supliers.SelectedText = "اختار اسم المورد";
}
}
private void FillBankAccounts_Supplier(int value)
{
using (dataSet = Ezzat.GetDataSet("select_SupplierBankAccounts", "X", new SqlParameter("@Supplier_ID", value)))
{
combo_Bank_Sup.DataSource = dataSet.Tables["X"];
combo_Bank_Sup.DisplayMember = "Bank_Name";
combo_Bank_Sup.ValueMember = "Bank_Number";
combo_Bank_Sup.Text = "";
combo_Bank_Sup.SelectedText = "اختار اسم البنك";
}
}
private void RefForm()
{
using (ds = Ezzat.GetDataSet("Customer_selectAll", "X"))
{
combo_Supliers.DataSource = ds.Tables["X"];
combo_Supliers.DisplayMember = "اسم العميل";
combo_Supliers.ValueMember = "رقم المسلسل";
combo_Supliers.Text = "";
combo_Supliers.SelectedText = "اختار اسم العميل";
}
}
private void Employee_Account_Load(object sender, EventArgs e)
{
using (dataSet = Ezzat.GetDataSet("select_AllEmployee", "X"))
{
combo_Employee.DataSource = dataSet.Tables["X"];
combo_Employee.DisplayMember = "Emp_Name";
combo_Employee.ValueMember = "Emp_ID";
combo_Employee.Text = "";
combo_Employee.SelectedText = "اختار موظف موجود";
}
}