private void ultraBtnBDelete_Click(object sender, EventArgs e)
{
try
{
objHospitalDB = new HospitalDB();
Bed objBed = new Bed(objHospitalDB);
BedRow objBedRow = new BedRow();
objBedRow.Bed_ID = Convert.ToInt32(this.bed_id);
objBed.Delete(objBedRow);
ultraGridBed.DataSource = objBed.GetAll();
/*ultraGridBed.Rows[this.ultraGridBed.ActiveRow.Index].Delete(true);
* SqlCommand query = objHospitalDB.CreateCommand("delete from Bed where Bed_ID='" + this.bed_id + "';", false);
* int p = query.ExecuteNonQuery();
* MessageBox.Show(p + "Deleted");*/
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
if (objHospitalDB != null)
{
objHospitalDB.Dispose();
}
}
}
// SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-89LF16D;Initial Catalog=Hospital;Integrated Security=True");
private void ultraBtnSave_Click(object sender, EventArgs e)
{
objHospitalDB = new HospitalDB();
Bed objBed = new Bed(objHospitalDB);
BedRow objBedRow = new BedRow();
objBedRow.BedName = ultraTextBedName.Text;
objBedRow.BedType = ultraComboBed.Text;
objBedRow.RatePerDay = Convert.ToInt32(ultraTextRatePerDay.Text);
if (strFormMode == "NEW")
{
if (MessageBox.Show("Are you sure you want to save", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
objBed.Insert(objBedRow);
this.Hide();
}
}
/*SqlCommand query = objHospitalDB.CreateCommand("insert into Bed Values('" + ultraTextBedName.Text + "','" + ultraTextRatePerDay.Text + "','" + ultraComboBed.Text + "')", false);
* // SqlDataAdapter sda = new SqlDataAdapter(query, con);
* int p = query.ExecuteNonQuery();
* MessageBox.Show(p + "Value is registerd");
* this.Hide();*/
else
{
objBedRow.Bed_ID = Convert.ToInt32(this.id);
objBed.Update(objBedRow);
}
}
