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 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 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 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 Add_ProductionTransaction()
{
Ezzat.ExecutedNoneQuery("insert_ProductionTransaction",
new SqlParameter("@Report_date", DateTime.Parse(DateTime.Now.ToString())),
new SqlParameter("@ReportNotes", richTextBox1.Text)
);
}
private void SaveData()
{
Ezzat.ExecutedNoneQuery("Group_Insert",
new SqlParameter("@Group_Name", txt_Name.Text)
);
MessageBox.Show(SharedClass.Successful_Message);
}
private void EditData()
{
Ezzat.ExecutedNoneQuery("Group_Edit"
, new SqlParameter("@Group_ID", Group_ID)
, new SqlParameter("@Group_Name", txt_Name.Text)
);
MessageBox.Show(SharedClass.Edit_Message);
}
private void Delete()
{
Ezzat.ExecutedNoneQuery("delete_EmployiesAndData",
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)
);
}
private void SaveData()
{
Ezzat.ExecutedNoneQuery("Outlay_insertOutlay", new System.Data.SqlClient.SqlParameter("@Band_Name", txt_Name.Text));
MessageBox.Show(SharedParameter.Add_Message);
txt_Name.Text = "";
}
private void Edit_Account()
{
string[] ar = label12.Text.Split('-');
Ezzat.ExecutedNoneQuery("update_EmployeeAccount",
new SqlParameter("@Employee_ID", Employee_ID),
new SqlParameter("@DateMonth", ar[0]),
new SqlParameter("@DateYear", ar[1])
);
}
private void EditPerson()
{
Ezzat.ExecutedNoneQuery("update_User"
, new SqlParameter("@Username", tb_name.Text)
, new SqlParameter("@password", tb_pass.Text)
, new SqlParameter("@isAdmin", radioButton1.Checked)
, new SqlParameter("@id", Id)
);
}
private void AddPerson()
{
Ezzat.ExecutedNoneQuery("insert_User"
, new SqlParameter("@Username", tb_name.Text)
, new SqlParameter("@Password", tb_pass.Text)
, new SqlParameter("@isAdmin", radioButton1.Checked)
);
MessageBox.Show(Shared_Class.Add_Message);
}
private void StartSafeMoney()
{
object o = Ezzat.ExecutedScalar("select_StartSafe_ID", new SqlParameter("@Day", DateTime.Parse(DateTime.Now.ToString())));
if (o == null)
{
Ezzat.ExecutedNoneQuery("insert_StartSafe", new SqlParameter("@Day", DateTime.Parse(DateTime.Now.ToString())));
}
}
private void EditData()
{
Ezzat.ExecutedNoneQuery("Chemical_Edit"
, new SqlParameter("@Chemical_ID", Chemical_ID)
, new SqlParameter("@Chemical_Name", txt_Name.Text)
, new SqlParameter("@Chemical_Unit", txt_Unit.Text)
);
MessageBox.Show(SharedClass.Edit_Message);
}
private void Edit()
{
Ezzat.ExecutedNoneQuery("updateProduct"
, new SqlParameter("@Product_ID", Product_ID)
, new SqlParameter("@Product_Name", tb_name.Text)
, new SqlParameter("@Product_Price", float.Parse(tb_price.Text))
, new SqlParameter("@Product_Sell", float.Parse(tb_sell.Text))
);
}
private void ChangeCreditLimit()
{
int row = Ezzat.ExecutedNoneQuery("update_CreditLimit", new SqlParameter("@Bill_ID", textBox2.Text), new SqlParameter("@Type", false), new SqlParameter("@ownerID", combo_Supliers.SelectedValue));
if (row == 0)
{
MessageBox.Show("كان لا يوجد فاتورة حد ائتمان بهذا الرقم تستحق التسديد");
}
}
private void SaveData()
{
Ezzat.ExecutedNoneQuery("Periods_Insert"
, new SqlParameter("@Periods_Name", txt_Name.Text)
, new SqlParameter("@Periods_Start", int.Parse(txt_Start.Text))
, new SqlParameter("@Periods_End", int.Parse(txt_End.Text))
);
MessageBox.Show(SharedClass.Successful_Message);
}
private void SaveData()
{
Ezzat.ExecutedNoneQuery("Employee_insertEmployee"
, new SqlParameter("@emp_name", tb_name.Text)
, new SqlParameter("@emp_card", tb_carNumber.Text)
, new SqlParameter("@emp_address", tb_address.Text)
, new SqlParameter("@emp_phone", tb_phone.Text)
, new SqlParameter("@emp_money", double.Parse(tb_money.Text))
);
}
private void Insert()
{
Ezzat.ExecutedNoneQuery("insertBank",
new SqlParameter("@Bank_Name", tb_name.Text),
new SqlParameter("@Bank_Account", tb_number.Text),
new SqlParameter("@Bank_Address", tb_address.Text),
new SqlParameter("@Bank_Phone", tb_phone.Text),
new SqlParameter("@Bank_Phone2", tb_phone2.Text)
);
}
private void insert_Analysis()
{
Ezzat.ExecutedNoneQuery("AnalysisPatient_Insert"
, new SqlParameter("@Analysis_ID", int.Parse(txt_Number.Text))
, new SqlParameter("@Analysis_Date", DateTime.Parse(txt_date.Text))
, new SqlParameter("@Analysis_Prise", double.Parse(txt_Prise.Text))
, new SqlParameter("@Patient_ID", combo_Patient.SelectedValue)
, new SqlParameter("@Doctor_ID", combo_Doctor.SelectedValue)
);
}
private void AddOutlayTansaction()
{
// اضافة تعامل مصاريف
Ezzat.ExecutedNoneQuery("Outlay_insertOutlayTransaction",
new SqlParameter("@Report_Total", float.Parse(textBox4.Text)),
new SqlParameter("@Report_Notes", richTextBox1.Text),
new SqlParameter("@Report_Date", DateTime.Parse(DateTime.Now.ToString())),
new SqlParameter("@Report_Band", comboBox1.SelectedValue)
);
}
private void SaveData()
{
Ezzat.ExecutedNoneQuery("Chemical_Insert",
new SqlParameter("@Chemical_Name", txt_Name.Text),
new SqlParameter("@Chemical_Quantity", int.Parse(txt_Quantity.Text)),
new SqlParameter("@Chemical_Unit", txt_Unit.Text)
);
MessageBox.Show(SharedClass.Successful_Message);
}
private void AddTransaction()
{
Ezzat.ExecutedNoneQuery("Employee_insertTransaction"
, new SqlParameter("@Employee_ID", comboBox1.SelectedValue)
, new SqlParameter("@Employee_Money", txt_Payment.Text)
, new SqlParameter("@Report_Notes", richTextBox1.Text)
, new SqlParameter("@Report_Date", DateTime.Parse(DateTime.Now.ToString()))
, new SqlParameter("@Report_ID", txt_billNumber.Text)
);
}
private void OwnerTransacton(string report_type, bool transaction_type)
{
Ezzat.ExecutedNoneQuery("insert_OwnerTransaction",
new SqlParameter("@report_id", label2.Text),
new SqlParameter("@report_type", report_type),
new SqlParameter("@report_date", DateTime.Parse(DateTime.Now.ToString())),
new SqlParameter("@reportdetails", richTextBox1.Text),
new SqlParameter("@totalmoney", double.Parse(tb_BillTotal.Text)),
new SqlParameter("@transaction_type", transaction_type)
);
}
private void EditData()
{
Ezzat.ExecutedNoneQuery("Employee_UpdateEmployee"
, new SqlParameter("@emp_name", tb_name.Text)
, new SqlParameter("@emp_card", tb_carNumber.Text)
, new SqlParameter("@emp_address", tb_address.Text)
, new SqlParameter("@emp_phone", tb_phone.Text)
, new SqlParameter("@emp_money", double.Parse(tb_money.Text))
, new SqlParameter("@emp_id", Emp_ID)
);
}
private void Add_Account()
{
foreach (DataGridViewRow item in dataGridView1.Rows)
{
Ezzat.ExecutedNoneQuery("insert_SupplierAccountsBank",
new SqlParameter("@Supplier_ID", Supplier_ID),
new SqlParameter("@Bank_Name", item.Cells[0].Value),
new SqlParameter("@Bank_Number", item.Cells[1].Value)
);
}
}
private void EditData()
{
Ezzat.ExecutedNoneQuery("Supplier_updateSupplier",
new SqlParameter("@Supplier_Name", txtName.Text)
, new SqlParameter("@Company_Name", txtCompany.Text)
, new SqlParameter("@Company_Address", txAddress.Text)
, new SqlParameter("@Phone1", txtPhone.Text)
, new SqlParameter("@Phone2", txtPhone2.Text)
, new SqlParameter("@Supplier_ID", Supplier_ID)
);
}
private void SaveData()
{
Ezzat.ExecutedNoneQuery("Supplier_insertSupplier"
, new SqlParameter("@Supplier_Name", txtName.Text)
, new SqlParameter("@Company_Name", txtCompany.Text)
, new SqlParameter("@Company_Address", txAddress.Text)
, new SqlParameter("@Phone1", txtPhone.Text)
, new SqlParameter("@Phone2", txtPhone2.Text)
, new SqlParameter("@TotalMoney", double.Parse("0"))
);
}
private void EditData()
{
Ezzat.ExecutedNoneQuery("Periods_Edit"
, new SqlParameter("@Periods_ID", Period_ID)
, new SqlParameter("@Periods_Name", txt_Name.Text)
, new SqlParameter("@Periods_Start", int.Parse(txt_Start.Text))
, new SqlParameter("@Periods_End", int.Parse(txt_End.Text))
);
MessageBox.Show(SharedClass.Edit_Message);
}
private void EditBank()
{
Ezzat.ExecutedNoneQuery("updateBank",
new SqlParameter("@Customer_ID", BankId),
new SqlParameter("@Customer_Name", tb_name.Text),
new SqlParameter("@Customer_Phone", tb_phone.Text),
new SqlParameter("@Customer_Phone2", tb_phone2.Text),
new SqlParameter("@Customer_Address", tb_address.Text),
new SqlParameter("@Customer_Company", tb_number.Text)
);
}