// 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);
}
}
