protected override void Because_of() { using (var context = new TestContext()) { _destination = context.Arts.ProjectTo <ArtDto>(Configuration).FirstOrDefault(); } }
private void ArtCellGotFocus(SelectionBase sender, ChangeActivePositionEventArgs e) { _needLoadArt = false; _artPosition = e.NewFocusPosition; _selectedArt = _artDtos[_artPosition.Row - 1]; lArt.Text = _selectedArt.FullName; if (_searchMode && !_searchChanging) { _searchString = ""; lInfo.Text = $"Поиск: {_searchString}"; } }
public ArtDto GetArtFromTable(int row) { var art = new ArtDto() { ArtId = (int)gridArt[row, Const.Columns.Art.ArtId].Value, Mag = (string)gridArt[row, Const.Columns.Art.Mag].Value, IYear = (int?)gridArt[row, Const.Columns.Art.IYear].Value, IMonth = (string)gridArt[row, Const.Columns.Art.IMonth].Value, Author = (string)gridArt[row, Const.Columns.Art.Author].Value, Name = (string)gridArt[row, Const.Columns.Art.Name].Value, NN = (int?)gridArt[row, Const.Columns.Art.NN].Value, Serie = (string)gridArt[row, Const.Columns.Art.Serie].Value }; return(art); }
public void UpdateArtRow(ArtDto art, int r) { gridArt[r, 0] = new SourceGrid.Cells.Cell(art.ArtId, _editorsArt[0]); gridArt[r, 1] = new SourceGrid.Cells.Cell(art.Mag, _editorsArt[1]); gridArt[r, 1].AddController(_gridArtController); gridArt[r, 2] = new SourceGrid.Cells.Cell(art.IYear, _editorsArt[2]); gridArt[r, 2].AddController(_gridArtController); gridArt[r, 3] = new SourceGrid.Cells.Cell(art.IMonth, _editorsArt[3]); gridArt[r, 3].AddController(_gridArtController); gridArt[r, 4] = new SourceGrid.Cells.Cell(art.Author, _editorsArt[4]); gridArt[r, 4].AddController(_gridArtController); gridArt[r, 5] = new SourceGrid.Cells.Cell(art.Name, _editorsArt[5]); gridArt[r, 5].AddController(_gridArtController); gridArt[r, 6] = new SourceGrid.Cells.Cell(art.NN, _editorsArt[6]); gridArt[r, 6].AddController(_gridArtController); gridArt[r, 7] = new SourceGrid.Cells.Cell(art.Serie, _editorsArt[7]); gridArt[r, 7].AddController(_gridArtController); gridArt[r, 8] = new SourceGrid.Cells.Cell(art.cnt, _editorsArt[8]); gridArt[r, 9] = new SourceGrid.Cells.Cell(art.FullName, _editorsArt[9]); }
private bool UpdateArtEntity(ArtDto art, int row) { var isAdded = false; if (art.ArtId == 0) { var entity = Mapper.Map <Arts>(art); _ctx.Arts.Add(entity); _ctx.SaveChanges(); art.ArtId = entity.ArtId; gridArt[row, Const.Columns.Art.ArtId].Value = entity.ArtId; isAdded = true; } else { var entity = _ctx.Arts.Single(x => x.ArtId == art.ArtId); Mapper.Map(art, entity); _ctx.SaveChanges(); } _selectedArt = art; _artDtos[row - 1] = art; var pArt = _arts.FirstOrDefault(x => x.Id == art.ArtId); if (pArt != null) { _arts.Remove(pArt); } _arts.InsertPairSorted(new Pair <int>() { Id = art.ArtId, Name = art.FullName }); _editArt.Control.Items.Clear(); _editArt.Control.Items.AddRange(_arts.Select(x => x.Name).ToArray()); return(isAdded); }
private void gridArt_PreviewKeyDown(object sender, PreviewKeyDownEventArgs e) { if (gridArt.Focused) { var pos = gridArt.Selection.ActivePosition; if (pos != Position.Empty) { if (e.KeyCode == Keys.Insert) { SearchModeOff(); var art = new ArtDto() { Mag = (string)gridArt[pos.Row, Const.Columns.Art.Mag].Value, IYear = (int?)gridArt[pos.Row, Const.Columns.Art.IYear].Value, IMonth = (string)gridArt[pos.Row, Const.Columns.Art.IMonth].Value }; _artDtos.Insert(pos.Row - 1, Mapper.Map <ArtDto>(art)); gridArt.Rows.Insert(pos.Row); UpdateArtRow(art, pos.Row); CheckArtSort(pos, true); } else if (e.KeyCode == Keys.Delete && e.Modifiers == Keys.Control) { if (MessageBox.Show("Delete art?", "Confirm", MessageBoxButtons.YesNo) == DialogResult.Yes) { try { var art = _artDtos[pos.Row - 1]; if (art.ArtId > 0) { var entity = _ctx.Arts.Single(x => x.ArtId == art.ArtId); _ctx.Arts.Remove(entity); _ctx.SaveChanges(); } gridArt.Rows.Remove(pos.Row); _artDtos.RemoveAt(pos.Row - 1); var pArt = _arts.FirstOrDefault(x => x.Id == art.ArtId); if (pArt != null) { _arts.Remove(pArt); } _editArt.Control.Items.Clear(); _editArt.Control.Items.AddRange(_arts.Select(x => x.Name).ToArray()); } catch (Exception ex) { MessageBox.Show(GetInnerestException(ex)); } } } else if (e.KeyCode == Keys.Home && e.Modifiers == Keys.None) { var col = 0; while (!gridArt.Columns[col].Visible) { col++; } var focusPosn = new Position(pos.Row, col); gridArt.Selection.Focus(focusPosn, true); } else if (e.KeyCode == Keys.End && e.Modifiers == Keys.None) { var col = gridArt.Columns.Count - 1; while (!gridArt.Columns[col].Visible) { col--; } var focusPosn = new Position(pos.Row, col); gridArt.Selection.Focus(focusPosn, true); } else if (e.KeyCode == Keys.Home && e.Modifiers == Keys.Control) { var col = 0; while (!gridArt.Columns[col].Visible) { col++; } var focusPosn = new Position(1, col); gridArt.Selection.Focus(focusPosn, true); } else if (e.KeyCode == Keys.End && e.Modifiers == Keys.Control) { var col = gridArt.Columns.Count - 1; while (!gridArt.Columns[col].Visible) { col--; } var focusPosn = new Position(gridArt.RowsCount - 1, col); gridArt.Selection.Focus(focusPosn, true); } } } }