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