public void AddItem()
{
_room info = new _room();
info.floor = cmbFloor.Text;
info.roomnumber = txtRoom.Text;
info.type = cmbType.Text;
info.price = txtPrice.Text;
info.description = txtDescription.Text;
info.connect();
if (btnADD.Text == "ADD")
{
info.Save();
info.AddToCheckInCheckOut();
}
else
{
info.updateRoom();
}
clearTextbox();
btnADD.Enabled = false;
btnNew.Text = "NEW";
btnADD.BackColor = System.Drawing.Color.White;
ReadAllData();
}
private void BtnDelete_Click(object sender, EventArgs e)
{
if (lstRoom.SelectedItems != null)
{
for (int i = lstRoom.Items.Count - 1; i >= 0; i--)
{
if (lstRoom.Items[i].Selected)
{
if (MessageBox.Show("Do you want to delete this record ?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
_room info = new _room();
info.roomnumber = lstRoom.Items[i].SubItems[1].Text;
info.connect();
info.delete();
ReadAllData();
MessageBox.Show("Deleted!");
}
else
{
//do something if NO
}
}
}
}
}
public void ReadAllData()
{
lstRoom.Items.Clear();
SqlConnection con = new SqlConnection("Data Source=Rofat;Initial Catalog=hotel;Integrated Security=True");
con.Open();
SqlCommand cm = new SqlCommand();
cm.Connection = con;
cm.CommandText = "Select * from tblRoom ";
SqlDataReader dr = cm.ExecuteReader();
while (dr.Read())
{
_room info = new _room();
info.floor = dr[0].ToString();
info.roomnumber = dr[1].ToString();
info.type = dr[2].ToString();
info.price = dr[3].ToString();
info.description = dr[4].ToString();
info.AddToList(lstRoom);
}
}