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 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 combo_Employee_SelectedIndexChanged(object sender, EventArgs e)
{
if (combo_Employee.Focused)
{
dataGridView1.DataSource = null;
dataGridView1.Rows.Clear();
SqlConnection con;
SqlDataReader dataReader = Ezzat.GetDataReader("selectEmployee_Month_Salary", out con, new SqlParameter("@Employer_ID", combo_Employee.SelectedValue));
if (dataReader.HasRows)
{
while (dataReader.Read())
{
dataGridView1.Rows.Add();
dataGridView1[0, dataGridView1.Rows.Count - 1].Value = dataReader[1].ToString() + "-" + dataReader[2].ToString();
dataGridView1[1, dataGridView1.Rows.Count - 1].Value = dataReader[6].ToString();
dataGridView1[2, dataGridView1.Rows.Count - 1].Value = dataReader[8].ToString();
dataGridView1[3, dataGridView1.Rows.Count - 1].Value = dataReader[7].ToString();
dataGridView1[4, dataGridView1.Rows.Count - 1].Value = dataReader[9].ToString();
dataGridView1[5, dataGridView1.Rows.Count - 1].Value = dataReader[11].ToString();
dataGridView1[6, dataGridView1.Rows.Count - 1].Value =
((double.Parse(dataReader[6].ToString()) + double.Parse(dataReader[8].ToString()))
- (double.Parse(dataReader[7].ToString()) + double.Parse(dataReader[9].ToString()) + double.Parse(dataReader[11].ToString())));
dataGridView1[7, dataGridView1.Rows.Count - 1].Value = dataReader[10].ToString();
}
}
con.Close();
}
}
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 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 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 All_Transaction()
{
SqlConnection con;
SqlDataReader dataReader = Ezzat.GetDataReader("_Supplier_SupplierTransaction_During", out con,
new SqlParameter("@Day", DateTime.Parse(dateTimePicker1.Value.ToString())),
new SqlParameter("@Day2", DateTime.Parse(dateTimePicker2.Value.ToString())),
new SqlParameter("@Supplier_ID", combo_Supliers.SelectedValue));
if (dataReader.HasRows)
{
while (dataReader.Read())
{
gv.Rows.Add();
gv[0, gv.Rows.Count - 1].Value = dataReader[0].ToString();
gv[1, gv.Rows.Count - 1].Value = dataReader[2].ToString();
gv[2, gv.Rows.Count - 1].Value = dataReader[1].ToString();
gv[3, gv.Rows.Count - 1].Value = (double.Parse(dataReader[2].ToString()) - double.Parse(dataReader[1].ToString()));
gv[4, gv.Rows.Count - 1].Value = dataReader[3].ToString();
gv[5, gv.Rows.Count - 1].Value = dataReader[5].ToString();
gv[6, gv.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 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 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(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 SelectComponents(int Type)
{
dataGridView1.Rows.Clear();
if (Type == 0)
{
panel6.Enabled = false;
}
else
{
getAllMaterial();
SqlConnection con;
panel6.Enabled = true;
SqlDataReader dr = Ezzat.GetDataReader("selectComponent", out con, new SqlParameter("@Prpduct_ID", Product_ID));
if (dr.HasRows)
{
while (dr.Read())
{
dataGridView1.Rows.Add();
dataGridView1[0, dataGridView1.Rows.Count - 1].Value = dr[0].ToString();
dataGridView1[1, dataGridView1.Rows.Count - 1].Value = dr[1].ToString();
dataGridView1[2, dataGridView1.Rows.Count - 1].Value = dr[2].ToString();
dataGridView1[3, dataGridView1.Rows.Count - 1].Value = dr[3].ToString();
}
}
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 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 ShowDetails()
{
SqlConnection con;
SqlDataReader dataReader = Ezzat.GetDataReader("customer_selectBillDetails2", out con, new SqlParameter("@bill_ID", bill_ID));
if (dataReader.HasRows)
{
while (dataReader.Read())
{
//tb_name.Text = dataReader["Customer_Name"].ToString();
//tb_carNumber.Text = dataReader["Car_Number"].ToString();
//tb_carShaseh.Text = dataReader["Car_Chaseh"].ToString();
//comboBox1.Text = dataReader["Car_Type"].ToString();
//tb_phone.Text = dataReader["Customer_Phone"].ToString();
//tb_kilo.Text = dataReader["Kilomaters"].ToString();
txt_AfterDiscount.Text = dataReader["After_Discount"].ToString();
txt_Discount.Text = dataReader["Discount_Money"].ToString();
txt_MaterialTotal.Text = dataReader["Material_Money"].ToString();
txt_OldMoney.Text = dataReader["Total_oldMoney"].ToString();
txt_Payment.Text = dataReader["Payment_Money"].ToString();
txt_Render.Text = dataReader["After_Payment"].ToString();
txt_Total.Text = dataReader["Total_Money"].ToString();
}
}
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 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 ShowDetails_Payback_Supplier_Load(object sender, EventArgs e)
{
l_type.Text = type.ToString();
if (type.ToString().Contains("تسديد"))
{
SqlConnection con;
SqlDataReader dataReader = Ezzat.GetDataReader("select_IMBillDeteils_Payback", 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();
label2.Text = dataReader[8].ToString();
l_name.Text = dataReader[11].ToString();
}
}
con.Close();
}
else if (type.ToString().Contains("خصم"))
{
SqlConnection con;
SqlDataReader dataReader = Ezzat.GetDataReader("select_IMBillDeteils_Discount", 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[3].ToString();
tb_payment.Text = dataReader[4].ToString();
tb_AfterPayment.Text = dataReader[5].ToString();
richTextBox1.Text = dataReader[6].ToString();
label2.Text = dataReader[7].ToString();
l_name.Text = dataReader[8].ToString();
}
}
con.Close();
}
}
private void FillCustomerAccount()
{
dataGridView2.Rows.Clear();
SqlConnection con;
SqlDataReader dr, dr1;
dr = Ezzat.GetDataReader("select_AllCustomer", out con);
if (dr.HasRows)
{
while (dr.Read())
{
dr1 = Ezzat.GetDataReader("sum_CustomerDuring", out con
, new SqlParameter("@Day", DateTime.Parse(dateTimePicker1.Value.ToString()))
, new SqlParameter("@Day2", DateTime.Parse(dateTimePicker2.Value.ToString()))
, new SqlParameter("@Customer_ID", dr[0].ToString())
, new SqlParameter("@Customer_Name", dr[1].ToString())
);
if (dr1.HasRows)
{
while (dr1.Read())
{
dataGridView2.Rows.Add();
dataGridView2[0, dataGridView2.Rows.Count - 1].Value = dr1[0].ToString();
dataGridView2[1, dataGridView2.Rows.Count - 1].Value = dr1[1].ToString();
dataGridView2[2, dataGridView2.Rows.Count - 1].Value = dr1[2].ToString();
dataGridView2[3, dataGridView2.Rows.Count - 1].Value = dr1[3].ToString();
dataGridView2[4, dataGridView2.Rows.Count - 1].Value = (double.Parse(dr1[3].ToString()) - double.Parse(dr1[2].ToString()));
o = Ezzat.ExecutedScalar("customer_Start", new SqlParameter("@Customer_ID", (int)dr1[0]), new SqlParameter("@Day", dateTimePicker1.Value));
if ((o + "").Length == 0)
{
o = 0;
}
dataGridView2[6, dataGridView2.Rows.Count - 1].Value = String.Format("{0:0.00}", o);
o = Ezzat.ExecutedScalar("customer_End", new SqlParameter("@Customer_ID", (int)dr1[0]), new SqlParameter("@Day", dateTimePicker2.Value));
if ((o + "").Length == 0)
{
o = 0;
}
dataGridView2[7, dataGridView2.Rows.Count - 1].Value = String.Format("{0:0.00}", o);
}
}
}
}
con.Close();
}
private void ShowDetails_Customer(int ID)
{
SqlConnection con;
SqlDataReader dr = Ezzat.GetDataReader("selectSpasific_Customer", out con, new SqlParameter("@Customer_Id", ID));
if (dr.HasRows)
{
while (dr.Read())
{
tb_OldMoney.Text = dr["Total_Money"].ToString();
Calcolate();
}
}
con.Close();
}
private void ShowDetailsCustomer(int selectedValue)
{
SqlConnection con;
SqlDataReader dataReader = Ezzat.GetDataReader("Customer_selectSearch_BYID", out con, new SqlParameter("@Customer_ID", selectedValue));
if (dataReader.HasRows)
{
while (dataReader.Read())
{
txt_OldMoney.Text = dataReader["Customer_Money"].ToString();
}
}
con.Close();
}
private void getPatientPeriod(int patientAge)
{
SqlConnection con;
SqlDataReader dataReader = Ezzat.GetDataReader("Period_Select_ByAge",
out con, new SqlParameter("@Patient_Age", patientAge));
if (dataReader.HasRows)
{
while (dataReader.Read())
{
patientClass.set_patientPeriod((int)dataReader[0]);
}
}
con.Close();
}
private void ShowDetailsProduct(int customer_ID)
{
SqlConnection con;
SqlDataReader dataReader = Ezzat.GetDataReader("Product_selectSearch_BYID", out con, new SqlParameter("@Product_ID", customer_ID));
if (dataReader.HasRows)
{
while (dataReader.Read())
{
txt_Price.Text = dataReader["Product_Price"].ToString();
}
}
con.Close();
}
private void ShowDetails(int value)
{
SqlConnection con;
SqlDataReader dataReader = Ezzat.GetDataReader("selectSpasific_Bank", out con, new SqlParameter("@Customer_Id", value));
if (dataReader.HasRows)
{
while (dataReader.Read())
{
tb_account.Text = dataReader["Bank_Account"].ToString();
}
}
con.Close();
}
private void ShowDetails(int customer_ID)
{
SqlConnection con;
SqlDataReader dataReader = Ezzat.GetDataReader("Employee_selectSearch_BYID", out con, new SqlParameter("@Customer_Id", customer_ID));
if (dataReader.HasRows)
{
while (dataReader.Read())
{
tb_money.Text = dataReader["emp_money"].ToString();
}
}
con.Close();
}
private void ShowDetails_Supplier(int ID)
{
SqlConnection con;
SqlDataReader dr = Ezzat.GetDataReader("selectSpasific_Supplier", out con, new SqlParameter("@Supplier_ID", ID));
if (dr.HasRows)
{
while (dr.Read())
{
//Days_Number = int.Parse(dr["Number_Day"].ToString());
//tb_PaymentMethod.Text = dr["Payment_Method"].ToString();
tb_OldMoney.Text = dr["Total_Money"].ToString();
Calcolate();
}
}
con.Close();
}
private void FillBankAccounts(int value)
{
dataGridView1.Rows.Clear();
SqlConnection con;
SqlDataReader dataReader = Ezzat.GetDataReader("select_SupplierBankAccounts", out con, new SqlParameter("@Supplier_ID", value));
if (dataReader.HasRows)
{
while (dataReader.Read())
{
dataGridView1.Rows.Add();
dataGridView1[0, dataGridView1.Rows.Count - 1].Value = dataReader[2].ToString();
dataGridView1[1, dataGridView1.Rows.Count - 1].Value = dataReader[3].ToString();
}
}
con.Close();
}
private void StartQuantity()
{
object o = Ezzat.ExecutedScalar("select_DayNumber", new SqlParameter("@DayDate", DateTime.Parse(DateTime.Now.ToString())));
if (o == null)
{
o = Ezzat.ExecutedScalar("select_DayNumber_ID");
if (o == null)
{
o = "1";
}
else
{
int i = int.Parse(o.ToString());
i++;
o = i;
}
SqlConnection con;
SqlDataReader dataReader = Ezzat.GetDataReader("Select_All2", out con);
if (dataReader.HasRows)
{
while (dataReader.Read())
{
Ezzat.ExecutedNoneQuery("insert_StartQuantity",
new SqlParameter("@Day_Number", o),
new SqlParameter("@Product_ID", dataReader[0].ToString()),
new SqlParameter("@StartDate", DateTime.Parse(DateTime.Now.ToString())),
new SqlParameter("@StartQuantity", dataReader[1].ToString()),
new SqlParameter("@Product_Type", dataReader[2].ToString()),
new SqlParameter("@Product_Name", dataReader[3].ToString()),
new SqlParameter("@Product_Unit", dataReader[4].ToString())
);
}
}
con.Close();
}
}
private void ShowDetailsPatient(int selectedValue)
{
SqlConnection con;
SqlDataReader dataReader = Ezzat.GetDataReader("Patient_Select_All_BYID",
out con, new SqlParameter("@Patient_ID", selectedValue));
if (dataReader.HasRows)
{
while (dataReader.Read())
{
string patient_Age = dataReader["Patient_Age"].ToString();
string patient_Gender = dataReader["Patient_Gender"].ToString();
patientClass.set_patientAge(int.Parse(patient_Age));
patientClass.set_patientGender(bool.Parse(patient_Gender));
}
}
con.Close();
}
private void ShowDetails(int group_ID)
{
bt_edit.Enabled = true;
bt_save.Enabled = false;
SqlConnection con;
SqlDataReader dataReader = Ezzat.GetDataReader("Group_Select_All_BYID",
out con, new SqlParameter("@Group_ID", group_ID));
if (dataReader.HasRows)
{
while (dataReader.Read())
{
txt_Name.Text = dataReader["Group_Name"].ToString();
}
}
con.Close();
}
