public static List <SpaceEntity> GetAllSpaceDetailsWithFilter()
{
List <SpaceEntity> resultList = new List <SpaceEntity>();
DapperMySQLConnector p = new DapperMySQLConnector();
p.db = new MySqlConnection(MainWindow.DatabaseconnStringPoolingTrue);
StringBuilder sb = new StringBuilder();
var temp = p.GetAllSpaces();
p.db.Close();
//Alarm to select space with Filters
var queryFilterSpaces = from space in temp
where space.Name == "Space Name" ||
space.Type == 0
select space;
//To display alarms
foreach (var spaceVar in queryFilterSpaces)
{
SpaceEntity _space = (SpaceEntity)spaceVar;
resultList.Add(_space);
}
return(resultList);
}
public AddUpdateSpaceWindow(SpaceEntity space)
{
InitializeComponent();
localSpace = space;
this.Title = "Update Space";
UpdateWindow = true;
}
public SpaceEntity Add(SpaceEntity space)
{
string query = @"Insert into space(Name,Type,No_of_floors,No_of_seats,No_of_rooms,No_of_kitchens" +
",No_of_toilets,No_of_cabins,SquareFeet) values(@Name,@Type,@No_of_floors,@No_of_seats,@No_of_rooms," +
"@No_of_kitchens,@No_of_toilets,@No_of_cabins,@SquareFeet);select Cast(LAST_INSERT_ID() as int)";
db.Query <int>(query, space).SingleOrDefault();
return(space);
}
public static void UpdateSpaceDetails(SpaceEntity space)
{
DapperMySQLConnector p = new DapperMySQLConnector();
p.db = new MySqlConnection(MainWindow.DatabaseconnStringPoolingTrue);
StringBuilder sb = new StringBuilder();
var temp = p.Update(space);
p.db.Close();
}
public SpaceEntity Update(SpaceEntity space)
{
string query = "update space set Name = '" + space.Name + "' , Type = " + space.Type +
" , No_of_floors = " + space.No_of_floors +
" ,No_of_seats = " + space.No_of_seats +
",No_of_rooms = " + space.No_of_rooms +
", No_of_kitchens =" + space.No_of_kitchens +
",No_of_toilets = " + space.No_of_toilets +
", No_of_cabins =" + space.No_of_cabins +
",SquareFeet =" + space.SquareFeet +
" where Space_Id = @Space_Id";
int i = db.Execute(query, new { Space_Id = space.Space_Id });
space.Space_Id = i;
return(space);
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrEmpty(SpaceNameTextBox.Text) ||
string.IsNullOrEmpty(AreaTextBox.Text))
{
MessageBox.Show("Please enter required details and try again.");
return;
}
int areaVal = 0;
if (!int.TryParse(AreaTextBox.Text, out areaVal))
{
MessageBox.Show("Please enter area details as number and try again.");
return;
}
SpaceEntity temp = new SpaceEntity();
temp.Name = SpaceNameTextBox.Text;
temp.SquareFeet = areaVal;
temp.Type = TypeCombobox.SelectedIndex;
temp.No_of_cabins = (int)NumericUpDownCabins.Value;
temp.No_of_floors = (int)NumericUpDownFloors.Value;
temp.No_of_kitchens = (int)NumericUpDownKitchens.Value;
temp.No_of_rooms = (int)NumericUpDownRooms.Value;
temp.No_of_seats = (int)NumericUpDownSeats.Value;
temp.No_of_toilets = (int)NumericUpDownToilets.Value;
if (!UpdateWindow)
{
MainWindow.AddSpaceDetails(temp);
}
else
{
temp.Space_Id = localSpace.Space_Id;
MainWindow.UpdateSpaceDetails(temp);
}
this.Close();
}
