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