private bool IsValid()
{
bool Valid = true;
SqlConnection con;
//بيجيب لو فيه موطفين ف الشهر دا و يعدل عليهم
SqlDataReader dr = Ezzat.GetDataReader("select_EmployiesAndDataAllData", out con,
new SqlParameter("@Month", String.Format("{0:MM}", DateTime.Now)),
new SqlParameter("@Year", String.Format("{0:yyyy}", DateTime.Now)),
new SqlParameter("@Employee_ID", dataGridView1.CurrentRow.Cells[0].Value)
);
if (dr.HasRows)
{
while (dr.Read())
{
if (bool.Parse(dr[10].ToString()) || double.Parse(dr[9].ToString()) != 0 || double.Parse(dr[8].ToString()) != 0 || double.Parse(dr[7].ToString()) != 0)
{
Valid = false;
}
}
}
con.Close();
return(Valid);
}
private void FillGrid_During(DateTime StartDateTime, DateTime EndDateTime)
{
dataGridView2.Rows.Clear();
SqlConnection con;
SqlDataReader dataReader = Ezzat.GetDataReader("Select_All", out con);
if (dataReader.HasRows)
{
while (dataReader.Read())
{
dataGridView2.Rows.Add();
dataGridView2[0, dataGridView2.Rows.Count - 1].Value = dataReader[0].ToString();
dataGridView2[1, dataGridView2.Rows.Count - 1].Value = dataReader[1].ToString();
dataGridView2[2, dataGridView2.Rows.Count - 1].Value = CalcolateEnd(dataReader[0].ToString(), EndDateTime);
dataGridView2[3, dataGridView2.Rows.Count - 1].Value = CalcolateStart(dataReader[0].ToString(), StartDateTime);
dataGridView2[4, dataGridView2.Rows.Count - 1].Value = double.Parse(dataGridView2[2, dataGridView2.Rows.Count - 1].Value + "")
- double.Parse(dataGridView2[3, dataGridView2.Rows.Count - 1].Value + "");
dataGridView2[6, dataGridView2.Rows.Count - 1].Value = Ezzat.ExecutedScalar("select_SUMofProduct__IM"
, new SqlParameter("@Day", dateTimePicker1.Value)
, new SqlParameter("@Day2", dateTimePicker2.Value)
, new SqlParameter("@product_ID", dataReader[0])
);
dataGridView2[7, dataGridView2.Rows.Count - 1].Value = Ezzat.ExecutedScalar("select_SUMofProduct__EX"
, new SqlParameter("@Day", dateTimePicker1.Value)
, new SqlParameter("@Day2", dateTimePicker2.Value)
, new SqlParameter("@product_ID", dataReader[0])
);
}
}
}
private void ShowDetails(int company_ID)
{
bt_edit.Enabled = true;
bt_save.Enabled = false;
SqlConnection con;
SqlDataReader dataReader = Ezzat.GetDataReader("Company_Select_All_BYID",
out con, new SqlParameter("@Company_ID", company_ID));
if (dataReader.HasRows)
{
while (dataReader.Read())
{
txt_Name.Text = dataReader["Company_Name"].ToString();
txt_Adress.Text = dataReader["Company_Adress"].ToString();
txt_Discount.Text = dataReader["Company_Discount"].ToString();
txt_Money.Text = dataReader["Company_Money"].ToString();
txt_Phone.Text = dataReader["Company_Phone"].ToString();
int value = (int)dataReader["Group_ID"];
combo_Group.SelectedValue = value;
}
}
con.Close();
}
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 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 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 FillCombo()
{
using (dataSet = Ezzat.GetDataSet("select_AllEmployee2", "X"))
{
dataGridView2.DataSource = dataSet.Tables["X"];
}
}
private void ShowDetails(int test_ID, string test_Name, string test_Unit)
{
bt_save.Enabled = false;
bt_edit.Enabled = true;
txt_Name.Text = test_Name;
txt_Unit.Text = test_Unit;
dataGridView2.Rows.Clear();
SqlConnection con;
SqlDataReader dataReader = Ezzat.GetDataReader("Normals_Select_All", out con, new SqlParameter("@Test_ID", test_ID));
if (dataReader.HasRows)
{
while (dataReader.Read())
{
DataGridViewRow row = (DataGridViewRow)dataGridView2.Rows[0].Clone();
row.Cells[0].Value = dataReader["الرقم المسلسل"].ToString();
row.Cells[1].Value = dataReader["المرحلة العمرية"].ToString();
row.Cells[2].Value = dataReader["معدل عند الذكر"].ToString();
row.Cells[3].Value = dataReader["معدل عند الانثى"].ToString();
dataGridView2.Rows.Add(row);
}
}
con.Close();
}
private void ReturnData()
{
SqlConnection con;
dataReader = Ezzat.GetDataReader("Safe_selectSafeTransaction", out con,
new SqlParameter("@Day", DateTime.Parse(dateTimePicker1.Value.ToString())),
new SqlParameter("@Day2", DateTime.Parse(dateTimePicker2.Value.ToString())));
if (dataReader.HasRows)
{
while (dataReader.Read())
{
dataGridView1.Rows.Add();
dataGridView1[0, dataGridView1.Rows.Count - 1].Value = dataReader[0].ToString();
dataGridView1[1, dataGridView1.Rows.Count - 1].Value = dataReader[1].ToString();
dataGridView1[2, dataGridView1.Rows.Count - 1].Value = dataReader[2].ToString();
dataGridView1[3, dataGridView1.Rows.Count - 1].Value = (double.Parse(dataReader[1].ToString()) - double.Parse(dataReader[2].ToString()));
dataGridView1[4, dataGridView1.Rows.Count - 1].Value = dataReader[3].ToString();
dataGridView1[5, dataGridView1.Rows.Count - 1].Value = dataReader[5].ToString();
dataGridView1[6, dataGridView1.Rows.Count - 1].Value = dataReader[4].ToString();
}
}
con.Close();
}
private void isValidData()
{
int o = (int)Ezzat.ExecutedScalar("select_CountUsers");
if (o == 0)
{
Add_Users users = new Add_Users();
users.Show();
}
else
{
object q = Ezzat.ExecutedScalar("select_isValid"
, new SqlParameter("@Username", textBox1.Text)
, new SqlParameter("@Password", textBox2.Text)
, new SqlParameter("@isAdmin", radioButton1.Checked)
);
if (q != null)
{
OpenHome();
}
else
{
MessageBox.Show(Shared_Class.Check_Message);
}
}
}
private void EditData()
{
Ezzat.ExecutedNoneQuery("Analysis_Edit",
new SqlParameter("@Analysis_ID", Test_ID),
new SqlParameter("@Analysis_Name", txt_Name.Text),
new SqlParameter("@Analysis_Unit", txt_Unit.Text)
);
Ezzat.ExecutedNoneQuery("Normal_Delete", new SqlParameter("@Test_ID", Test_ID));
foreach (DataGridViewRow item in dataGridView2.Rows)
{
if (item.Cells[0].Value != null)
{
Period_ID = int.Parse(item.Cells[0].Value.ToString());
Male_Value = float.Parse(item.Cells[2].Value.ToString());
Female_Value = float.Parse(item.Cells[3].Value.ToString());
Ezzat.ExecutedNoneQuery("Normal_Insert"
, new SqlParameter("@Test_ID", Test_ID)
, new SqlParameter("@Period_ID", Period_ID)
, new SqlParameter("@Male_Value", Male_Value)
, new SqlParameter("@Female_Value", Female_Value)
);
}
}
MessageBox.Show(SharedClass.Successful_Message);
}
private void radioButton2_CheckedChanged(object sender, EventArgs e)
{
using (dataSet = Ezzat.GetDataSet("store_select_AllMaterial", "X"))
{
dataGridView1.DataSource = dataSet.Tables["X"];
}
}
private void ShowDetails(int patient_ID)
{
bt_edit.Enabled = true;
bt_save.Enabled = false;
SqlConnection con;
SqlDataReader dataReader = Ezzat.GetDataReader("PatientCompany_Select_All_BYID",
out con, new SqlParameter("@Patient_ID", patient_ID));
if (dataReader.HasRows)
{
while (dataReader.Read())
{
txt_Name.Text = dataReader["Patient_Name"].ToString();
txt_Phone.Text = dataReader["Patient_Phone"].ToString();
txt_Age.Text = dataReader["Patient_Age"].ToString();
txt_Number.Text = dataReader["Patient_Number"].ToString();
int value = (int)dataReader["Company_ID"];
combo_Company.SelectedValue = value;
bool bo = (bool)dataReader["Patient_Gender"];
radio_Male.Checked = bo;
radio_Female.Checked = !bo;
}
}
con.Close();
}
private void Employee_Salaries_Load(object sender, EventArgs e)
{
label12.Text = String.Format("{0:MM-yyyy}", DateTime.Now);
SqlConnection con;
//بيجيب كل الموطفين اللي لسه حساباتهم جارية
SqlDataReader dataReader2 = Ezzat.GetDataReader("select_EmployiesAndData_FromEmployee", out con);
if (dataReader2.HasRows)
{
while (dataReader2.Read())
{
dataGridView1.Rows.Add();
dataGridView1[0, dataGridView1.Rows.Count - 1].Value = dataReader2[0].ToString();
dataGridView1[1, dataGridView1.Rows.Count - 1].Value = dataReader2[1].ToString();
dataGridView1[2, dataGridView1.Rows.Count - 1].Value = dataReader2[2].ToString();
dataGridView1[3, dataGridView1.Rows.Count - 1].Value = dataReader2[3].ToString();
dataGridView1[4, dataGridView1.Rows.Count - 1].Value = bool.Parse(dataReader2[4].ToString());
}
}
con.Close();
IsExsisted();
}
private void SaveNormal()
{
// تعديل حساب المورد النهائى
Ezzat.ExecutedNoneQuery("updateTotalMoney_Customer"
, new SqlParameter("@Supplier_ID", (int)combo_Customer.SelectedValue)
, new SqlParameter("@Total_Money", float.Parse(tb_Total.Text)));
// اضافة فاتورة مرتجع الى المورد
// اضافة تعامل ف حساب تعاملات المورد
Ezzat.ExecutedNoneQuery("insertEXReturning_Bill",
new SqlParameter("@Purchasing_ID", int.Parse(label2.Text)),
new SqlParameter("@Customer_ID", (int)combo_Customer.SelectedValue),
new SqlParameter("@Bill_Date", DateTime.Parse(DateTime.Now.ToString())),
new SqlParameter("@Payment_Method", ""),
new SqlParameter("@Material_Money", float.Parse(tb_BillTotal.Text)),
new SqlParameter("@Discount_Money", float.Parse(tb_Discount.Text)),
new SqlParameter("@After_Discount", float.Parse(tb_AfterDiscount.Text)),
new SqlParameter("@Total_oldMoney", float.Parse(tb_OldMoney.Text)),
new SqlParameter("@Total_Money", float.Parse(tb_Total.Text)),
new SqlParameter("@Payment_Money", float.Parse("0.00")),
new SqlParameter("@Bill_Details", richTextBox1.Text),
new SqlParameter("@Sheck_Number", "")
);
// اضافة تفاصيل فاتورة الشراء
AddIMBill_Details(int.Parse(label2.Text));
EditStore();
}
private void FillCombo()
{
using (dataSet = Ezzat.GetDataSet("selectAllSupplier2", "X"))
{
dataGridView2.DataSource = dataSet.Tables["X"];
}
}
private void SumBand()
{
dataGridView2.Rows.Clear();
SqlConnection con;
SqlDataReader dataReader = Ezzat.GetDataReader("select_AllBand", out con);
if (dataReader.HasRows)
{
while (dataReader.Read())
{
dataGridView2.Rows.Add();
dataGridView2[0, dataGridView2.Rows.Count - 1].Value = dataReader[1].ToString();
dataGridView2[1, dataGridView2.Rows.Count - 1].Value =
Ezzat.ExecutedScalar("_Outlay_During_Sum_Band",
new SqlParameter("@Day", dateTimePicker1.Value),
new SqlParameter("@Day2", dateTimePicker2.Value),
new SqlParameter("@Band_iD", dataReader[0].ToString())
);
if (dataGridView2[1, dataGridView2.Rows.Count - 1].Value.ToString().Length == 0)
{
dataGridView2[1, dataGridView2.Rows.Count - 1].Value = "0.0000";
}
}
}
con.Close();
}
private void ShowDetails(int value)
{
bt_edit.Enabled = button1.Enabled = true;
bt_Save.Enabled = false;
SqlConnection con;
SqlDataReader dataReader = Ezzat.GetDataReader("selectSpasific_Supplier", out con, new SqlParameter("@Supplier_ID", value));
if (dataReader.HasRows)
{
while (dataReader.Read())
{
tb_name.Text = dataReader["Supplier_Name"].ToString();
tb_address.Text = dataReader["Supplier_Address"].ToString();
tb_company.Text = dataReader["Supplier_Company"].ToString();
tb_phone.Text = dataReader["Supplier_Phone"].ToString();
tb_phone2.Text = dataReader["Supplier_Phone2"].ToString();
tb_day.Text = dataReader["Number_Day"].ToString();
PaymentMethod(dataReader["Payment_Method"].ToString());
}
}
con.Close();
FillBankAccounts(value);
}
private void FillGrid_During(DateTime StartDateTime, DateTime EndDateTime)
{
dataGridView2.Rows.Clear();
SqlConnection con;
SqlDataReader dataReader = Ezzat.GetDataReader("Product_selectAll", out con);
if (dataReader.HasRows)
{
while (dataReader.Read())
{
dataGridView2.Rows.Add();
dataGridView2[0, dataGridView2.Rows.Count - 1].Value = dataReader[0].ToString();
dataGridView2[1, dataGridView2.Rows.Count - 1].Value = dataReader[1].ToString();
dataGridView2[2, dataGridView2.Rows.Count - 1].Value = Ezzat.ExecutedScalar("Material_IM"
, new SqlParameter("@Day", dateTimePicker1.Value)
, new SqlParameter("@Day2", dateTimePicker2.Value)
, new SqlParameter("@product_ID", dataReader[0])
);
dataGridView2[3, dataGridView2.Rows.Count - 1].Value = Ezzat.ExecutedScalar("Material_EX"
, new SqlParameter("@Day", dateTimePicker1.Value)
, new SqlParameter("@Day2", dateTimePicker2.Value)
, new SqlParameter("@product_ID", dataReader[0])
);
}
}
}
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 All_Transaction()
{
SqlConnection con;
SqlDataReader dataReader = Ezzat.GetDataReader("_BankTransaction_During", out con,
new SqlParameter("@Day", DateTime.Parse(dateTimePicker1.Value.ToString())),
new SqlParameter("@Day2", DateTime.Parse(dateTimePicker2.Value.ToString())),
new SqlParameter("@BankID", combo_Bank.SelectedValue));
if (dataReader.HasRows)
{
while (dataReader.Read())
{
dataGridView1.Rows.Add();
dataGridView1[0, dataGridView1.Rows.Count - 1].Value = dataReader[0].ToString();
dataGridView1[1, dataGridView1.Rows.Count - 1].Value = dataReader[1].ToString();
dataGridView1[2, dataGridView1.Rows.Count - 1].Value = dataReader[2].ToString();
dataGridView1[3, dataGridView1.Rows.Count - 1].Value = (double.Parse(dataReader[1].ToString()) - double.Parse(dataReader[2].ToString()));
dataGridView1[4, dataGridView1.Rows.Count - 1].Value = dataReader[3].ToString();
dataGridView1[5, dataGridView1.Rows.Count - 1].Value = dataReader[5].ToString();
dataGridView1[6, dataGridView1.Rows.Count - 1].Value = dataReader[4].ToString();
}
}
con.Close();
}
private void ShowDetails_Bank_Customer_Load(object sender, EventArgs e)
{
SqlConnection con;
SqlDataReader dataReader = Ezzat.GetDataReader("select_EXBillDeteils_Bank", out con,
new SqlParameter("@Bill_ID", id));
if (dataReader.HasRows)
{
while (dataReader.Read())
{
l_id.Text = dataReader[0].ToString();
l_date.Text = dataReader[2].ToString();
tb_OldMoney.Text = dataReader[4].ToString();
tb_payment.Text = dataReader[5].ToString();
tb_AfterPayment.Text = dataReader[6].ToString();
richTextBox1.Text = dataReader[7].ToString();
l_num.Text = dataReader[8].ToString();
l_name.Text = dataReader[10].ToString();
l_bank.Text = dataReader[11].ToString();
}
}
con.Close();
}
private void ShowDetails_Material(int ID)
{
SqlConnection con;
SqlDataReader dr = Ezzat.GetDataReader("selectSpasificProduct2", out con, new SqlParameter("@Product_ID", ID));
if (dr.HasRows)
{
while (dr.Read())
{
MaterialPrice = double.Parse(dr[7].ToString());
Product_PerUnit = int.Parse(dr[5].ToString());
MaterialUnit = dr[4].ToString();
tb_price.Text = String.Format("{0:0.00}", MaterialPrice);
if (dr[4].ToString() == "كجم")
{
rb_Kilo.Checked = true;
}
else if (dr[4].ToString() == "جم")
{
rb_Gram.Checked = true;
}
}
}
con.Close();
}
private void SaveLater()
{
// تعديل حساب المورد النهائى
Ezzat.ExecutedNoneQuery("updateTotalMoney_Customer", new SqlParameter("@Supplier_ID", (int)combo_Customer.SelectedValue),
new SqlParameter("@Total_Money", float.Parse(tb_render.Text)));
// اضافة فاتورة شراء من المورد
// اضافة تعامل ف حساب تعاملات المورد
Ezzat.ExecutedNoneQuery("insertEXPurchasingBill",
new SqlParameter("@Purchasing_ID", int.Parse(label2.Text)),
new SqlParameter("@Supplier_ID", (int)combo_Customer.SelectedValue),
new SqlParameter("@Bill_Date", DateTime.Parse(DateTime.Now.ToString())),
new SqlParameter("@Payment_Method", "أجل"),
new SqlParameter("@Material_Money", float.Parse(tb_BillTotal.Text)),
new SqlParameter("@Discount_Money", float.Parse(tb_Discount.Text)),
new SqlParameter("@After_Discount", float.Parse(tb_AfterDiscount.Text)),
new SqlParameter("@Total_oldMoney", float.Parse(tb_OldMoney.Text)),
new SqlParameter("@Total_Money", float.Parse(tb_Total.Text)),
new SqlParameter("@Payment_Money", float.Parse(tb_payment.Text)),
new SqlParameter("@After_Payment", float.Parse(tb_render.Text)),
new SqlParameter("@Bill_Details", richTextBox1.Text),
new SqlParameter("@Sheck_Number", "")
);
//Add IMBill_Details
// اضافة تفاصيل فاتورة الشراء
AddIMBill_Details(int.Parse(label2.Text));
// المخازن
EditStore();
MessageBox.Show(Shared_Class.Successful_Message);
}
private string CalcolateEnd(string v, DateTime endDateTime)
{
object Day_Num = Ezzat.ExecutedScalar("select_EndQuantity_Day_Number",
new SqlParameter("@EndDate", endDateTime));
if (Day_Num == null)
{
return("0");
}
else
{
int d = int.Parse(Day_Num.ToString());
d++;
Day_Num = d;
object o = Ezzat.ExecutedScalar("select_EndQuantity",
new SqlParameter("@Day_Number", Day_Num),
new SqlParameter("@Product_ID", int.Parse(v))
);
if (o == null)
{
object q = Ezzat.ExecutedScalar("select_EndQuantity_Today", new SqlParameter("@Product_ID", int.Parse(v)));
return(q + "");
}
else
{
return(o + "");
}
}
}
private void SavePaypack()
{
// تعديل حساب المورد النهائى
Ezzat.ExecutedNoneQuery("updateTotalMoney", new SqlParameter("@Supplier_ID",
(int)combo_Supliers.SelectedValue),
new SqlParameter("@Total_Money", float.Parse(tb_AfterPayment.Text)));
// اضافة بيان تسديد الى مورد
// اضافة تعامل ف التعاملات مع الموردين .... نوعه تسديد
Ezzat.ExecutedNoneQuery("insertIMPayback_Bill",
new SqlParameter("@Report_ID", label2.Text),
new SqlParameter("@Supplier_ID", combo_Supliers.SelectedValue),
new SqlParameter("@Report_Date", DateTime.Parse(DateTime.Now.ToString())),
new SqlParameter("@Payment_Method", "نقدى"),
new SqlParameter("@Total_Money", float.Parse(tb_OldMoney.Text)),
new SqlParameter("@Payment_Money", float.Parse(tb_payment.Text)),
new SqlParameter("@After_Payment", float.Parse(tb_AfterPayment.Text)),
new SqlParameter("@Report_Notes", richTextBox1.Text),
new SqlParameter("@BillNumber_Supplier", int.Parse(textBox1.Text))
);
EditSafe();
MessageBox.Show(Shared_Class.Successful_Message);
}
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 Add_ProductionTransaction()
{
Ezzat.ExecutedNoneQuery("insert_ProductionTransaction",
new SqlParameter("@Report_date", DateTime.Parse(DateTime.Now.ToString())),
new SqlParameter("@ReportNotes", richTextBox1.Text)
);
}
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 Total_Out()
{
using (ds = Ezzat.GetDataSet("_TotalOut", "X", new SqlParameter("@Day", dateTimePicker1.Value), new SqlParameter("@Day2", dateTimePicker2.Value)))
{
dgv_Out.DataSource = ds.Tables["X"];
}
}
