//private void GenerateID()
//{
// Conn obcon = new Conn();
// SqlConnection ob = new SqlConnection(obcon.strCon);
// SqlDataAdapter da = new SqlDataAdapter();
// da.SelectCommand = new SqlCommand();
// da.SelectCommand.Connection = ob;
// SqlCommand cmd = da.SelectCommand;
// cmd.CommandText = "Select isnull(max(ID),0)+1 as ID from Cabin";
// cmd.CommandType = CommandType.Text;
// DataTable dt = new DataTable();
// da.Fill(dt);
// if (dt.Rows.Count > 0)
// {
// idTextBox.Text = dt.Rows[0]["Id"].ToString();
// }
//}
private void CabinSetup_Load(object sender, EventArgs e)
{
Floor defaultFloor = new Floor();
defaultFloor.FloorName = "--Select--";
defaultFloor.Id = -1;
List <Floor> floors = new List <Floor>();
floors.Add(defaultFloor);
floors.AddRange(aFloorManager.GetAllFloors());
floorComboBox.DisplayMember = "FloorName";
floorComboBox.ValueMember = "Id";
floorComboBox.DataSource = floors;
Category defaultCategory = new Category();
defaultCategory.CategoryName = "--Select--";
defaultCategory.Id = -1;
List <Category> categories = new List <Category>();
categories.Add(defaultCategory);
categories.AddRange(aCategoryManager.GetAllCategories());
categoryComboBox.DisplayMember = "CategoryName";
categoryComboBox.ValueMember = "Id";
categoryComboBox.DataSource = categories;
PopulateCabinListView();
Control buttonControl = new ButtonPermissionAccess().UserButton(this.groupBox1, this.Name);
//GenerateID();
//GetAllFloor();
//GetAllCategory();
}
private void BedSetup2_Load(object sender, EventArgs e)
{
Floor defaultFloor = new Floor();
defaultFloor.FloorName = "--Select--";
defaultFloor.Id = -1;
List <Floor> floors = new List <Floor>();
floors.Add(defaultFloor);
floors.AddRange(aFloorManager.GetAllFloors());
floorComboBox.DisplayMember = "FloorName";
floorComboBox.ValueMember = "Id";
floorComboBox.DataSource = floors;
Category defaultCategory = new Category();
defaultCategory.CategoryName = "--Select--";
defaultCategory.Id = -1;
List <Category> categories = new List <Category>();
categories.Add(defaultCategory);
categories.AddRange(aCategoryManager.GetAllCategories());
categoryComboBox.DisplayMember = "CategoryName";
categoryComboBox.ValueMember = "Id";
categoryComboBox.DataSource = categories;
Ward defaultWard = new Ward();
defaultWard.WardName = "--Select--";
defaultWard.Id = -1;
List <Ward> wards = new List <Ward>();
wards.Add(defaultWard);
wards.AddRange(aWardManager.GetAllWards());
wardComboBox.DisplayMember = "WardName";
wardComboBox.ValueMember = "Id";
wardComboBox.DataSource = wards;
Room defaultRoom = new Room();
defaultRoom.RoomName = "--Select--";
defaultRoom.Id = -1;
List <Room> rooms = new List <Room>();
rooms.Add(defaultRoom);
rooms.AddRange(aRoomManager.GetAllRooms());
roomComboBox.DisplayMember = "RoomName";
roomComboBox.ValueMember = "Id";
roomComboBox.DataSource = rooms;
PopulateItemsListView();
editButton.Enabled = false;
deleteButton.Enabled = false;
}
private void LoadFloor()
{
Floor defaultFloor = new Floor();
defaultFloor.FloorName = "--Select--";
defaultFloor.Id = -1;
List <Floor> floors = new List <Floor>();
floors.Add(defaultFloor);
floors.AddRange(aFloorManager.GetAllFloors());
floorComboBox.DisplayMember = "FloorName";
floorComboBox.ValueMember = "Id";
floorComboBox.DataSource = floors;
}
