private void btAdd_Click(object sender, EventArgs e)
{
RoomStatus editRoom = new RoomStatus();
this.Hide();
RoomStatusEdit editform = new RoomStatusEdit(editRoom, 2);
editform.Show();
}
public RoomStatusEdit(RoomStatus roomstt, int type)
{
InitializeComponent();
this.roomstatus = roomstt;
this.typeHandle = type;
this.txtID.Enabled = false;
roomStatusBLT = new RoomStatusBLT();
}
public DataTable searchRoomStatus(RoomStatus roomStatus)
{
try
{
return roomStatusDAT.SearchRoomStatus(roomStatus);
}
catch (System.Exception ex)
{
Console.WriteLine("Message= {1}", ex.Message);
}
return null;
}
public DataTable SearchRoomStatus(RoomStatus roomStatus)
{
try
{
SqlParameter[] para = new SqlParameter[2];
para[0] = new SqlParameter("@p_id", roomStatus.Id);
para[1] = new SqlParameter("@p_name", roomStatus.Name);
DataTable lstRoomStatus = LoadDataTableStoreProcedure("Roomstatus_Search", para);
return lstRoomStatus;
}
catch (System.Exception ex)
{
Console.WriteLine("Message= {1}", ex.Message);
}
return null;
}
public bool addRoomStatus(RoomStatus roomStatus)
{
try
{
int param = 1;
string[] name = new string[param];
object[] value = new object[param];
name[0] = "@name"; value[0] = roomStatus.Name;
int result = this.Update("RoomStatus_Insert", name, value, param);
if (result != 0)
{
return true;
}
}
catch (System.Exception ex)
{
Console.WriteLine("Message = {1}", ex.Message);
}
return false;
}
public bool updateRoomStatus(RoomStatus roomStatus)
{
return roomStatusDAT.updateRoomStatus(roomStatus);
}
public bool addRoomStatus(RoomStatus roomStatus)
{
return roomStatusDAT.addRoomStatus(roomStatus);
}
public bool updateRoomStatus(RoomStatus roomStatus)
{
try
{
SqlParameter[] para = new SqlParameter[2];
para[0] = new SqlParameter("@id", roomStatus.Id);
para[1] = new SqlParameter("@name", roomStatus.Name);
int result = this.ExecuteNonQuery("UPDATE roomstatus SET name=@name WHERE id = @id", para);
if (result != 0)
{
return true;
}
}
catch (System.Exception ex)
{
Console.WriteLine("Message = {1}", ex.Message);
}
return false;
}
private void btEdit_Click(object sender, EventArgs e)
{
if (gridRoomStatus.Rows.Count > 1)
{
rowIndex = this.gridRoomStatus.CurrentCell.RowIndex;
if ((rowIndex < gridRoomStatus.RowCount - 1) && (rowIndex >= 0))
{
RoomStatus editRoom = new RoomStatus();
editRoom.Id = gridRoomStatus.Rows[rowIndex].Cells[0].Value.ToString();
editRoom.Name = this.tbName.Text;
RoomStatusEdit editform = new RoomStatusEdit(editRoom, 1);
editform.Show();
this.Hide();
}
}else
{
MessageBox.Show("No row Selected!");
}
}
private void btSearch_Click(object sender, EventArgs e)
{
RoomStatus searchRoom = new RoomStatus();
searchRoom.Name = this.tbName.Text;
searchRoom.Id = this.tbID.Text;
this.gridRoomStatus.DataSource = roomStatusBLT.searchRoomStatus(searchRoom);
}
