public List <CabinViewModel> GetAllCabinFromView()
{
Query = "SELECT * FROM ViewAllCabins ORDER BY CabinName,CategoryName,FloorName";
Command = new SqlCommand(Query, Connection);
//Connection.Open();
Reader = Command.ExecuteReader();
List <CabinViewModel> cabinViewModels = new List <CabinViewModel>();
int sl = 0;
while (Reader.Read())
{
sl++;
CabinViewModel aCabinViewModel = new CabinViewModel();
aCabinViewModel.Sl = Convert.ToInt32(sl);
aCabinViewModel.Id = (int)Reader["Id"];
aCabinViewModel.CabinName = Reader["CabinName"].ToString();
aCabinViewModel.Description = Reader["Description"].ToString();
aCabinViewModel.FloorName = Reader["FloorName"].ToString();
aCabinViewModel.CategoryName = Reader["CategoryName"].ToString();
aCabinViewModel.Rate = Convert.ToInt32(Reader["Rate"]);
aCabinViewModel.CategoryId = (int)Reader["CategoryId"];
aCabinViewModel.FloorId = (int)Reader["FloorId"];
cabinViewModels.Add(aCabinViewModel);
}
Reader.Close();
//Connection.Close();
return(cabinViewModels);
}
private void cabinListView_MouseDoubleClick(object sender, MouseEventArgs e)
{
CabinViewModel aCabinViewModel = cabinListView.SelectedItems[0].Tag as CabinViewModel;
if (aCabinViewModel != null)
{
idTextBox.Text = aCabinViewModel.Id.ToString();
cabinNameTextBox.Text = aCabinViewModel.CabinName;
floorComboBox.SelectedValue = aCabinViewModel.FloorId;
categoryComboBox.SelectedValue = aCabinViewModel.CategoryId;
descriptionTextBox.Text = aCabinViewModel.Description;
rateTextBox.Text = aCabinViewModel.Rate.ToString();
deleteButton.Enabled = true;
saveButton.Text = "Update";
}
deleteButton.Enabled = true;
}
