private void AddClick(Pavilion selectedPavilion) { int startPosition; if (selectedPavilion.Number > pavilionToUpdate.Number) { startPosition = pavilionRepository.GetPavilionPosition(selectedPavilion) - 1; pavilionToUpdate.Size++; pavilionRepository.Update(pavilionToUpdate); pavilionRepository.Delete(selectedPavilion.Id); } else { selectedPavilion.Size++; pavilionRepository.Update(selectedPavilion); shopToUpdate.PavilionId = selectedPavilion.Id; shopRepository.Update(shopToUpdate); startPosition = pavilionRepository.GetPavilionPosition(pavilionToUpdate) - 1; // if (-1) pavilionRepository.Delete(pavilionToUpdate.Id); } pavilionRepository.SortWithUpdate(startPosition, pavilionRepository.Count - startPosition - 1); if (startPosition == -1) { startPosition++; } Log.Info(tag, $"startPosToUpdate: {startPosition}, count: {pavilionRepository.Count}"); var args = new AddPavilionToShopEventsArgs(startPosition, pavilionRepository.Count); AddPavilionToShopFinish?.Invoke(this, args); Dismiss(); }
private void FillDb() { if (db.Table <Floor>().CountAsync().Result == 0) { for (int i = 1; i < FLOORS_COUNT; i++) { var floor = new Floor(); floor.Number = i; floor.Size = 10; floor.EmptySize = PAVILIONS_COUNT; db.InsertAsync(floor).Wait(); Log.Info(tag, $"Floor #{i} created"); for (int j = 1; j <= PAVILIONS_COUNT; j++) { var pavilion = new Pavilion(); pavilion.Size = 1; pavilion.IsEmpty = true; pavilion.FloorId = i; pavilion.Number = j + (100 * i); db.InsertAsync(pavilion).Wait(); Log.Info("Db", $"Pavilion #{pavilion.Number} created"); } } } else { Log.Info(tag, "Floor there"); } }
private void Button_Click_3(object sender, RoutedEventArgs e) { if (list1.SelectedIndex != -1) { FormCol dialog = new FormCol(); if (dialog.ShowDialog() == true) { var p = db.Pavilions .Where(pa => pa.SEC == list1.SelectedIndex + 1) .Count(); var pav = db.Pavilions; p++; for (int i = p; i < p + dialog.number; i++) { Pavilion pa = new Pavilion { number = i, name = "", SEC = list1.SelectedIndex + 1 }; pav.Add(pa); } db.SaveChanges(); updatePavilion(); } else { MessageBox.Show("Создание отменено"); } } }
private void btnSave_Click(object sender, EventArgs e) { try { if (ValidateChildren(ValidationConstraints.Enabled)) { if (_currentPavilion == null) { _currentPavilion = new Pavilion { Name = textName.Text }; pavilionsBindingSource.Add(_currentPavilion); _context.Pavilions.Add(_currentPavilion); } else { _currentPavilion.Name = textName.Text; pavilionsBindingSource.EndEdit(); } _context.SaveChanges(); pavilionsBindingSource.ResetBindings(true); _currentPavilion = null; textName.Text = ""; MetroFramework.MetroMessageBox.Show(this, "Success", "Message", MessageBoxButtons.OK, MessageBoxIcon.Question); } } catch (Exception ex) { MetroFramework.MetroMessageBox.Show(this, ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public AddPavilionToShopDialogFragment(DbHelper DAO, Pavilion pavilion) { pavilionRepository = DAO.CreateRepository <Pavilion>(pavilion.FloorId) as IPavilionRepository; shopRepository = DAO.CreateRepository <Shop>(null) as IShopRepository; pavilionToUpdate = pavilion; shopToUpdate = shopRepository.GetShopByPavilion(pavilion); }
public ShopRegisterFragment(DbHelper DAO, Pavilion pavilion) { this.DAO = DAO; shopRepository = DAO.CreateRepository <Shop>(null) as IShopRepository; pavilionRepository = DAO.CreateRepository <Pavilion>(pavilion.FloorId) as IPavilionRepository; this.pavilion = pavilion; }
public int DeleteByPavilion(Pavilion pavilion) { var shop = db.Table <Shop>() .FirstOrDefaultAsync(s => s.PavilionId == pavilion.Id) .Result; return(base.Delete(shop.Id)); }
private void btnEdit_Click(object sender, EventArgs e) { if (pavilionsBindingSource.Current is Pavilion selectedPavilion) { _currentPavilion = selectedPavilion; textName.Text = _currentPavilion.Name; } }
private void SetPavilionVisibility(Pavilion pavilion, Shop shop, User user) { if (pavilion.IsChecked) { if (pavilion.IsEmpty) { ShopDetails.Visibility = ViewStates.Gone; FilledPavilionFunctional.Visibility = ViewStates.Gone; if (user.AccessLevel != AccessLevels.Visitor) { EmptyPavilionFunctional.Visibility = ViewStates.Visible; if (user.AccessLevel == AccessLevels.Administrator) { EveryPavilionFunctional.Visibility = ViewStates.Visible; } } else { EmptyPavilionFunctional.Visibility = ViewStates.Gone; EveryPavilionFunctional.Visibility = ViewStates.Gone; } } else { ShopDetails.Visibility = ViewStates.Visible; EmptyPavilionFunctional.Visibility = ViewStates.Gone; if (user.AccessLevel == AccessLevels.Administrator) { FilledPavilionFunctional.Visibility = ViewStates.Visible; EveryPavilionFunctional.Visibility = ViewStates.Visible; } else if (user.AccessLevel == AccessLevels.Businessman && shop.OwnerId == user.Id) { FilledPavilionFunctional.Visibility = ViewStates.Visible; EveryPavilionFunctional.Visibility = ViewStates.Visible; } else { FilledPavilionFunctional.Visibility = ViewStates.Gone; EveryPavilionFunctional.Visibility = ViewStates.Gone; } } } else { ShopDetails.Visibility = ViewStates.Gone; EmptyPavilionFunctional.Visibility = ViewStates.Gone; FilledPavilionFunctional.Visibility = ViewStates.Gone; } }
public void BindPavilionView(Pavilion pavilion, Shop shop, User owner, User user) { PavilionNum.Text = pavilion.Number.ToString(); if (pavilion.Size <= 3) { AddPavilionToShopButton.Enabled = true; } else { AddPavilionToShopButton.Enabled = false; } if (pavilion.Size > 1) { SeparatePavilionButton.Visibility = ViewStates.Visible; } else { SeparatePavilionButton.Visibility = ViewStates.Gone; } if (!pavilion.IsEmpty) { ShopName.Text = shop.Name; ShopInfo.Text = "Info: " + shop.Info; ShopSize.Text = "Size: " + pavilion.Size.ToString(); ShopOwnerName.Text = "Owner: " + owner.Name; PavilionNum.SetTextColor(Color.Black); } else { ShopName.Text = ""; ShopInfo.Text = ""; ShopSize.Text = ""; ShopOwnerName.Text = ""; PavilionNum.SetTextColor(Color.LightGray); } SetPavilionVisibility(pavilion, shop, user); }
private void SpinnerItemSelected() { int pavilionNum; bool isNum = Int32.TryParse(pavilionsSpinner.SelectedItem.ToString(), out pavilionNum); if (isNum) { selectedPavilion = pavilionRepository.GetByNum(pavilionNum); Log.Info(tag, $"selected pavilion num #{selectedPavilion.Number.ToString()}"); if (selectedPavilion != null) { addButton.Enabled = true; } } else { addButton.Enabled = false; Log.Info(tag, "pavilion is not selected"); } }
private void Button_Click(object sender, RoutedEventArgs e) { ExcelPackage package = new ExcelPackage(); string pathForSaving = "\\Template"; FileInfo template = new FileInfo("myTemplate.xlsx"); using (package = new ExcelPackage(template, true)) { ExcelWorksheet worksheet = package.Workbook.Worksheets[1]; Helper helper = new Helper(); DataSet data = helper.GetData(); int row = 3; List <Area> areas = new List <Area>(); List <Pavilion> pavilions = new List <Pavilion>(); foreach (DataRow dataRow in data.Tables["Area"].Rows) { Area area = new Area(); area.AreaId = Int32.Parse(dataRow["AreaID"].ToString()); area.Name = dataRow["Name"].ToString(); area.FullName = dataRow["FullName"].ToString(); area.PavilionId = Int32.Parse(dataRow["PavilionId"].ToString()); areas.Add(area); } foreach (DataRow dataRow in data.Tables["dic_Pavilion"].Rows) { Pavilion pav = new Pavilion(); pav.PavilionId = Int32.Parse(dataRow["PavilionID"].ToString()); pav.Name = dataRow["Name"].ToString(); pavilions.Add(pav); } var query = areas.Join(pavilions, a => a.PavilionId, p => p.PavilionId, (a, p) => new { a.Name, a.FullName, PavilionName = p.Name }); foreach (var dataRow in query) { worksheet.Cells[row, 2].Value = dataRow.Name; worksheet.Cells[row, 3].Value = dataRow.FullName; worksheet.Cells[row, 7].Value = dataRow.PavilionName; row++; } //foreach(DataRow Datarow in data.Tables["Area"].Rows) //{ // worksheet.Cells[row, 2].Value = Datarow["Name"]; // worksheet.Cells[row, 3].Value = Datarow["FullName"]; // //worksheet.Cells[row, 4].Value = Datarow["PavilionName"]; // row++; //} package.SaveAs(new System.IO.FileInfo("demoOut.xlsx")); } }
public Shop GetShopByPavilion(Pavilion pavilion) { return(db.Table <Shop>() .FirstOrDefaultAsync(s => s.PavilionId == pavilion.Id).Result); }
public PavilionEventsArgs(Pavilion pavilion, int position) { this.pavilion = pavilion; this.position = position; }