private void btn_update_surgeryprice_Click(object sender, EventArgs e)
{
BL.Cls_SurgeryPrices sp = new BL.Cls_SurgeryPrices();
DataTable dts = new DataTable();
sp.update_SurgeryPrices(Convert.ToInt32(cmbxSurgeryName.SelectedValue.ToString()), txtSurgeryCode.Text, Convert.ToInt32(txtSurgeryPrice1.Text), cmbxSurgeryName.Text, "");
XtraMessageBox.Show("تعم التعديل بنجاح");
}
private void cmbxSurgeryName_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
BL.Cls_SurgeryPrices sp = new BL.Cls_SurgeryPrices();
DataTable dts = new DataTable();
dts = sp.select_all_SurgeryPrices();
txtSurgeryPrice1.Text = dts.Rows[cmbxSurgeryName.SelectedIndex][2].ToString();
txtSurgeryCode.Text = dts.Rows[cmbxSurgeryName.SelectedIndex][1].ToString();
}
catch (Exception) { }
}
private void simpleButton1_Click(object sender, EventArgs e)
{
try
{
BL.Cls_SurgeryPrices sp = new BL.Cls_SurgeryPrices();
DataTable dtsp = new DataTable();
dtsp = sp.git_max_SurgeryPrices();
int idsp = Convert.ToInt32(dtsp.Rows[0][0]);
sp.insert_SurgeryPrices(idsp, txtSurgeryCode.Text, Convert.ToInt32(txtSurgeryPrice1.Text), cmbxSurgeryName.Text, "");
XtraMessageBox.Show("تم إضافة البيانات بنجاح");
}
catch (Exception) { }
}
private void SettingSystem_Load_1(object sender, EventArgs e)
{
BL.Cls_BondBookType bt = new BL.Cls_BondBookType();
DataTable dty = new DataTable();
dty = bt.SelectAllBondBookType();
cmBondTypeName.DataSource = dty;
cmBondTypeName.DisplayMember = "Bond_Name";
cmBondTypeName.ValueMember = "Bond_Number";
BL.Cls_SurgeryPrices sp = new BL.Cls_SurgeryPrices();
DataTable dts = new DataTable();
dts = sp.select_all_SurgeryPrices();
cmbxSurgeryName.DataSource = dts;
cmbxSurgeryName.DisplayMember = "SurgeryPrice_name";
cmbxSurgeryName.ValueMember = "SurgeryPrice_id";
}
