private void deleteButton_Click(object sender, EventArgs e)
{
if (deleteRoomTextBox.Text == "")
{
MessageBox.Show("please click on the row.");
}
else
{
RoomInfo rmObj = new RoomInfo()
{
rm_No = Convert.ToInt32(deleteRoomTextBox.Text),
};
DialogResult dr = MessageBox.Show("Are you want to delete Room no:" + rmObj.rm_No, "continue", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dr == DialogResult.Yes)
{
RoomEntryDateAccess ob = new RoomEntryDateAccess();
ob.deleteRoomInfo(rmObj);
deleteRoomTextBox.Text = "";
MessageBox.Show("deleted ");
deleteRoomTextBox.Text = "";
RoomEntryDateAccess dataAccess = new RoomEntryDateAccess();
List <RoomInfo> rooms = dataAccess.viewRoomInfo();
roomEntryDataGridView.AutoGenerateColumns = false;
roomEntryDataGridView.DataSource = rooms;
}
else if (dr == DialogResult.No)
{
MessageBox.Show("not deleted.");
}
}
}
private void updateButton_Click(object sender, EventArgs e)
{
deleteRoomTextBox.Text = "";
RoomInfo rmObj = new RoomInfo()
{
block_No = blockNoTextBox.Text,
floor_No = floorNoTextBox.Text
};
if (roomNoTextBox.Text == "" || availableSeatTextBox.Text == "")
{
rmObj.rm_No = -1;
rmObj.available_Seat = -1;
}
else
{
rmObj.rm_No = Convert.ToInt32(roomNoTextBox.Text);
rmObj.available_Seat = Convert.ToInt32(availableSeatTextBox.Text);
}
RoomEntryCheck obj = new RoomEntryCheck();
obj.updateButtonCheck(rmObj);
deleteRoomTextBox.Text = "";
RoomEntryDateAccess dataAccess = new RoomEntryDateAccess();
List <RoomInfo> rooms = dataAccess.viewRoomInfo();
roomEntryDataGridView.AutoGenerateColumns = false;
roomEntryDataGridView.DataSource = rooms;
//roomNoTextBox.ReadOnly = false;
}
public void updateButtonCheck(RoomInfo rmObj)
{
if (rmObj.rm_No == -1 || rmObj.block_No == "" || rmObj.floor_No == "" || rmObj.available_Seat == -1)
{
MessageBox.Show("please fill up all properties successfully !!!");
}
else if (rmObj.rm_No < 0)
{
MessageBox.Show("room number should be positive !!!");
}
else if (rmObj.available_Seat < 0)
{
MessageBox.Show("available seat should be positive !!!");
}
else
{
RoomEntryDateAccess dataAccess = new RoomEntryDateAccess();
int i = dataAccess.haveAnyRoomNO(rmObj);
if (i == 1)
{
RoomEntryDateAccess obj = new RoomEntryDateAccess();
obj.updateRoomInfo(rmObj);
}
else
{
MessageBox.Show("there is exit no room of " + rmObj.rm_No + " !!!\n please try again.");
}
}
}
private void RefreshButton_Click(object sender, EventArgs e)
{
deleteRoomTextBox.Text = "";
RoomEntryDateAccess dataAccess = new RoomEntryDateAccess();
List <RoomInfo> rooms = dataAccess.viewRoomInfo();
roomEntryDataGridView.AutoGenerateColumns = false;
roomEntryDataGridView.DataSource = rooms;
}
public void viewButton_Click(object sender, EventArgs e)
{
deleteRoomTextBox.Text = "";
RoomEntryDateAccess dataAccess = new RoomEntryDateAccess();
List <RoomInfo> rooms = dataAccess.viewRoomInfo();
roomEntryDataGridView.AutoGenerateColumns = false;
roomEntryDataGridView.DataSource = rooms;
roomEntryDataGridView.Columns[0].DataPropertyName = "rm_No";
roomEntryDataGridView.Columns[1].DataPropertyName = "block_No";
roomEntryDataGridView.Columns[2].DataPropertyName = "floor_No";
roomEntryDataGridView.Columns[3].DataPropertyName = "available_Seat";
}
public List <RoomInfo> RoomSearchCheck(RoomInfo rmObj)
{
List <RoomInfo> rooms;
if (rmObj.rm_No == -1)
{
MessageBox.Show("please fill up \"Room No\" property successfully !!!");
rooms = null;
}
else
{
RoomEntryDateAccess dataAccess = new RoomEntryDateAccess();
rooms = dataAccess.viewRoomInfoSearch(rmObj);
}
return(rooms);
}
public void entryButtonCheck(RoomInfo rmObj)
{
if (rmObj.rm_No == -1 || rmObj.block_No == "" || rmObj.floor_No == "" || rmObj.available_Seat == -1)
{
MessageBox.Show("please fill up all properties successfully !!!");
}
//else if (rmObj.rm_No < 0 )
//{
// MessageBox.Show("room number should be positive !!!");
//}
////else if (rmObj.floor_No < 0)
////{
//// MessageBox.Show("room number should be positive !!!");
////}
//else if (rmObj.available_Seat<0)
//{
// MessageBox.Show("available seat should be positive !!!");
//}
else
{
RoomEntryDateAccess dataAccess = new RoomEntryDateAccess();
int i = dataAccess.haveAnyRoomNO(rmObj);
if (i == 0)
{
RoomEntryDateAccess obj = new RoomEntryDateAccess();
int j = obj.roomAdd(rmObj);
string Message = j > 0 ? "create successfully" : "data not saved";
MessageBox.Show(Message);
}
else
{
MessageBox.Show("there is exit another account has same room no !!!\n\t please try again.");
}
}
}
