public void LoadRequests()
{
DataGridController dataGrid = new DataGridController();
dataGrid.design(dataGridView1);
try
{
List<RequestViewModel> list = service.GetList();
if (list != null)
{
dataGridView1.DataSource = list;
dataGridView1.Columns[0].Visible = false;
dataGridView1.Columns[5].Visible = false;
dataGridView1.Columns[6].Visible = false;
dataGridView1.Columns[1].HeaderText = "Дата поставки";
dataGridView1.Columns[2].HeaderText = "Адрес поставки";
dataGridView1.Columns[3].HeaderText = "Отметка получения";
dataGridView1.Columns[4].HeaderText = "Дата получения";
dataGridView1.Columns[1].AutoSizeMode =
DataGridViewAutoSizeColumnMode.Fill;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
public PositionListViewModel(IDialogService dialogService, PositionListFacade positionList)
{
this.dialogService = dialogService;
this.positionList = positionList;
positionList.LoadPositionList();
Name = "Position List";
#region Command Initialization
CloseCommand = new ActionCommand(p => CloseRequested?.Invoke(this, EventArgs.Empty));
AddPositionCommand = new ActionCommand(p => AddPosition());
DeletePositionCommand = new ActionCommand(p => DeletePosition());
EditPositionCommand = new ActionCommand(p => EditPosition());
AddSizeCommand = new ActionCommand(p => AddSize());
DeleteSizeCommand = new ActionCommand(p => DeleteSize());
EditSizeCommand = new ActionCommand(p => EditSize());
AddIngredientCommand = new ActionCommand(p => AddIngredient());
DeleteIngredientCommand = new ActionCommand(p => DeleteIngredient());
#endregion
dataGridController = new DataGridController(positionList);
#region Observable Collections Initialization
Positions = new ObservableCollection <Position>();
Sizes = new ObservableCollection <Size>();
#endregion
}
/***************************
* My Files populate data
***************************/
private void PopulateMyFiles(object sender, MouseButtonEventArgs e)
{
VersionCol.Visibility = Visibility.Visible;
InMyFiles = true;
SidebarReviseButton.Visibility = Visibility.Visible;
DatabaseCon con = new DatabaseCon();
con.OpenConnection();
List <string> paths = FileData.GetMyFilePath();
DataGridController data = new DataGridController();
ObservableCollection <FileAndDirAttributes> GridData = new ObservableCollection <FileAndDirAttributes>();
FileProperties file;
if (paths.Count > 0)
{
foreach (string dir in paths)
{
file = new FileProperties(dir);
GridData.Add(new FileAndDirAttributes {
Type = false, FileIcon = "/Resources/Icons/file.png", FileName = file.GetFileName(), FileSize = file.GetFileSize(), FileDirectory = file.GetDirectory(), FileCreated = file.GetFileCreated(), FileAccessed = file.GetFileLastAccess(), FileModified = file.GetFileLastModify(), Versions = FileData.VersionCount(dir)
});
}
DirsAndFiles.ItemsSource = GridData;
items.Content = (GridData.Count - 1) + " items";
size.Content = "No file selected.";
}
else
{
MessageBox.Show("Error", "No file found!");
}
}
private void SendFile(object sender, RoutedEventArgs e)
{
FileAndDirAttributes files = (FileAndDirAttributes)DirsAndFiles.SelectedItem;
FileSender send = new FileSender();
Partners pr = new Partners();
string code = "";
code = ContactsData.GetShareCode(ContactName.Text);
string ip = "";
if (code != "")
{
ip = ShareCode.GetIPFromCode(code);
}
if (ip != "" && pr.IsContactAvailable(ip))
{
if (InMyFiles == true)
{
string path = FileData.SelectedVersionPath(files.FileDirectory + "\\" + files.FileName, VersionsList.SelectedIndex);
DataGridController dgc = new DataGridController();
send.SendFile(path, ip);
System.Diagnostics.Process.Start(@path);
}
else
{
send.SendFile(files.FileDirectory + "\\" + files.FileName, "127.0.0.1");
}
}
else
{
MessageBox.Show("Error", "Couldn't connect with partner");
}
}
public GridClipboard(DataGridController controller, string[][] data)
{
if (controller == null)
{
throw new ArgumentNullException("controller");
}
if (data == null)
{
throw new ArgumentNullException("data");
}
Controller = controller;
Cells = new Row[data.Length];
for (int i = 0; i < data.Length; i++)
{
Cells[i] = new Row(data[i]);
}
if (0 < Cells.Length)
{
ColumnCount = Cells[0].Count;
MaxColumnCount = ColumnCount;
foreach (Row row in Cells)
{
MaxColumnCount = Math.Max(MaxColumnCount, row.Count);
}
}
GuessFields();
}
private void DeleteSubject_Button_Click(object sender, RoutedEventArgs e)
{
Subjects subjectToDelete = new Subjects();
try
{
var val = (Subjects)TimeTable_DataGrid.SelectedValue;
subjectToDelete = val;
}
catch (Exception)
{
MessageBox.Show("Prosze zaznaczyc poprawny obiekt. ");
}
int deletedId = new int();
try
{
deletedId = subjectToDelete.subjectId;
SubjectController controller = new SubjectController();
controller.DeleteSubject(deletedId);
DataGridController gridController = new DataGridController(TimeTable_DataGrid);
gridController.SetDataSourceForSubjects();
}
catch (Exception)
{
MessageBox.Show("Zaznacz element do usuniecia.");
}
}
private void AddExam_Button_Click(object sender, RoutedEventArgs e)
{
var examName = this.ExamName_TextBox.Text;
var examDate = this.ExamDate_Calendar.SelectedDate;
ExamController controller = new ExamController();
try
{
Exams exam = new Exams()
{
examName = examName, examTime = examDate
};
controller.AddExam(exam);
ToLearnController toLearnController = new ToLearnController(exam.examName, 10);
toLearnController.AddAndSaveLearnCycle();
DataGridController dataGridController = new DataGridController(ExamGrid);
dataGridController.SetDataSourceForExams();
dataGridController.DataGrid = WhatToLearnToday_DataGrid;
dataGridController.SetDataSourceForLearningDays();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void LoadProviders()
{
DataGridController dataGrid = new DataGridController();
dataGrid.design(dataGridView1);
try
{
List <ProviderViewModel> list = service.GetList();
if (list != null)
{
dataGridView1.DataSource = list;
dataGridView1.Columns[0].Visible = false;
dataGridView1.Columns[1].HeaderText = "Компания";
dataGridView1.Columns[2].HeaderText = "Рейтинг";
dataGridView1.Columns[3].HeaderText = "Адрес";
dataGridView1.Columns[4].HeaderText = "Email";
dataGridView1.Columns[5].HeaderText = "Номер телефона";
dataGridView1.Columns[1].AutoSizeMode =
DataGridViewAutoSizeColumnMode.Fill;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
public virtual void Close()
{
if (Controller != null)
{
Controller.Dispose();
Controller = null;
}
}
private void UserControl_Initialized(object sender, EventArgs e)
{
ParameterStore.AllParameters.ParameterTextChanged += Parameters_ParameterTextChanged;
DataGridControllerResult = new DataGridController();
//DataGridControllerResult.Context = CurrentDataSet;
DataGridControllerResult.Grid = dataGridResult;
listBoxLog.CommandBindings.Add(new CommandBinding(ApplicationCommands.Copy, listBoxLogCommandCopy_Executed));
listBoxLog.CommandBindings.Add(new CommandBinding(ApplicationCommands.SelectAll, listBoxLogCommandSelAll_Executed));
textBoxSql.CommandBindings.Add(new CommandBinding(QueryCommands.NormalizeSQL, textBoxSqlCommandNormalizeSql_Executed));
}
private void Request_Load(object sender, EventArgs e)
{
this.Opacity = .9;
DataGridController dataGrid = new DataGridController();
dataGrid.design(dataGridView1);
LoadProducts();
dataGridView1.Columns[0].AutoSizeMode =
DataGridViewAutoSizeColumnMode.Fill;
}
public void AddExistedRowWorks()
{
var facade = new PositionListFacade(new PositionListStub(), new SizeListStub(),
new IngredientListStub());
var controller = new DataGridController(facade);
controller.Position = facade.LoadPositionList()[0];
controller.AddRow(new Consumable(1, "1", 1));
Assert.AreEqual(1, controller.IngredientRows.Count);
Assert.AreEqual("1", controller.IngredientRows.ToList()[0].Consumable);
Assert.AreEqual(1.0, controller.IngredientRows.ToList()[0].Columns["size1"]);
}
public void RemoveRowMethod_AffectsDomain()
{
var ingredientList = new IngredientListStub();
var facade = new PositionListFacade(new PositionListStub(), new SizeListStub(),
ingredientList);
var controller = new DataGridController(facade);
controller.Position = facade.LoadPositionList()[0];
controller.AddRow(new Consumable(2, "2", 1));
controller.SelectedRow = controller.IngredientRows.ToList()[0];
controller.RemoveRow();
Assert.AreEqual(2, ingredientList.Ingredients.Count);
}
public void AddRowMethod_AffectsDomain()
{
var ingredientList = new IngredientListStub();
var facade = new PositionListFacade(new PositionListStub(), new SizeListStub(),
ingredientList);
var controller = new DataGridController(facade);
controller.Position = facade.LoadPositionList()[0];
controller.AddRow(new Consumable(2, "2", 1));
Assert.AreEqual(4, ingredientList.Ingredients.Count);
Assert.AreEqual("2", ingredientList.Ingredients[2].Consumable.Name);
Assert.AreEqual(0, ingredientList.Ingredients[2].Amount);
}
public MainWindow()
{
InitializeComponent();
DataGridController gridController = new DataGridController(TimeTable_DataGrid);
DataGridController examsGridController = new DataGridController(ExamGrid);
DataGridController learningDaysController = new DataGridController(WhatToLearnToday_DataGrid);
gridController.SetDataSourceForSubjects();
examsGridController.SetDataSourceForExams();
learningDaysController.SetDataSourceForLearningDays();
SetWebBrowserSilient();
}
private void OpenInExplorer(object sender, RoutedEventArgs e)
{
FileAndDirAttributes files = (FileAndDirAttributes)DirsAndFiles.SelectedItem;
if (InMyFiles == true)
{
string path = FileData.SelectedVersionPath(files.FileDirectory + "\\" + files.FileName, VersionsList.SelectedIndex);
DataGridController dgc = new DataGridController();
System.Diagnostics.Process.Start(@dgc.GetParent(path));
}
else
{
System.Diagnostics.Process.Start(@files.FileDirectory);
}
}
private void PopulateDataGrid(string path)
{
try
{
DataGridController data = new DataGridController();
ObservableCollection <FileAndDirAttributes> GridData = data.PopulateDataGrid(path);
DirsAndFiles.ItemsSource = GridData;
items.Content = (GridData.Count - 1) + " items";
size.Content = "No file selected.";
}
catch (Exception e)
{
string error = e.ToString();
MessageBox.Show("The process failed: " + error, "Data loading error.");
}
}
private void FindPreviousCommand_Executed(object sender, ExecutedRoutedEventArgs e)
{
DataGridController obj = Target;
if (obj == null)
{
return;
}
if (string.IsNullOrEmpty(comboBoxKeyword.Text))
{
return;
}
bool found = obj.SearchGridTextBackward();
textBlockNotFound.Visibility = found ? Visibility.Hidden : Visibility.Visible;
}
private void UserControl_Initialized(object sender, EventArgs e)
{
DataGridControllerResult = new DataGridController();
DataGridControllerResult.Grid = dataGridResult;
CommandBinding b;
b = new CommandBinding(ApplicationCommands.Find, FindCommand_Executed);
dataGridResult.CommandBindings.Add(b);
b = new CommandBinding(SearchCommands.FindNext, FindNextCommand_Executed);
dataGridResult.CommandBindings.Add(b);
b = new CommandBinding(SearchCommands.FindPrevious, FindPreviousCommand_Executed);
dataGridResult.CommandBindings.Add(b);
b = new CommandBinding(QueryCommands.NormalizeSQL, textBoxConditionCommandNormalizeSql_Executed);
textBoxCondition.CommandBindings.Add(b);
VisibleLevel = HiddenLevel.Hidden;
}
private void loadDetails()
{
DataGridController dataGrid = new DataGridController();
dataGrid.design(dataGridView1);
dataGrid.design(dataGridView2);
dataGridView2.Rows.Clear();
try
{
List <RequestProductViewModel> list = service.GetDetailsOnAll();
if (list != null)
{
dataGridView1.DataSource = list;
dataGridView1.Columns[0].Visible = false;
dataGridView1.Columns[1].HeaderText = "Номер заявки";
dataGridView1.Columns[2].Visible = false;
dataGridView1.Columns[3].Visible = false;
dataGridView1.Columns[4].HeaderText = "Статус";
dataGridView1.Columns[5].HeaderText = "Количество";
dataGridView1.Columns[4].AutoSizeMode =
DataGridViewAutoSizeColumnMode.Fill;
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
dataGridView2.Rows.Add();
if (Convert.ToInt32(dataGridView1.Rows[i].Cells[3].Value.ToString()) == 1)
{
dataGridView2.Rows[i].Cells[1].Value = "Не назначен";
}
else
{
dataGridView2.Rows[i].Cells[1].Value = proService.ProviderNameById(Convert.ToInt32(dataGridView1.Rows[i].Cells[3].Value.ToString()));
}
dataGridView2.Rows[i].Cells[0].Value = prodService.ProductNameById(Convert.ToInt32(dataGridView1.Rows[i].Cells[2].Value.ToString()));
dataGridView2.Columns[0].AutoSizeMode =
DataGridViewAutoSizeColumnMode.Fill;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
public async Task TestGetReturnsOkObkectResult()
{
var dataLoader = new Mock <IDataLoader>();
dataLoader.Setup(d => d.GetDataFromApiAsync())
.ReturnsAsync(new List <User> {
new User(), new User()
});
var dataGridController = new DataGridController(dataLoader.Object);
var response = await dataGridController.Get(new DataSourceLoadOptions());
var result = response as OkObjectResult;
Assert.NotNull(result);
Assert.IsType <LoadResult>(result.Value);
}
private void UpdateComboBoxColumn()
{
DataGridColumn old = comboBoxColumn.SelectedItem as DataGridColumn;
DataGridController obj = Target;
List <DataGridColumn> l = new List <DataGridColumn>();
if (obj != null)
{
l = new List <DataGridColumn>(obj.GetDisplayDataGridColumns());
}
comboBoxColumn.ItemsSource = l;
if (old == null || l.IndexOf(old) == -1)
{
comboBoxColumn.SelectedItem = obj.GetSelectedCell(true)?.Column;
}
else
{
comboBoxColumn.SelectedItem = old;
}
}
private void FindNextCommand_Executed(object sender, ExecutedRoutedEventArgs e)
{
DataGridController obj = Target;
if (obj == null)
{
return;
}
if (string.IsNullOrEmpty(comboBoxKeyword.Text))
{
return;
}
if (checkBoxColumn.IsChecked.HasValue && checkBoxColumn.IsChecked.Value)
{
_selectedColumn = comboBoxColumn.SelectedItem as DataGridColumn;
}
bool found = obj.SearchGridTextForward();
textBlockNotFound.Visibility = found ? Visibility.Hidden : Visibility.Visible;
}
private void AddSubject_Button_Click(object sender, RoutedEventArgs e)
{
var subjectName = this.AddSubjectName_TextBox.Text;
var subjectDate = this.AddSubject_Callendar.SelectedDate;
var subjectTime = this.AddSubject_TimePicker.SelectedTime;
var dateToSend = new DateTime();
try
{
var date = new DateTime(subjectDate.Value.Year, subjectDate.Value.Month, subjectDate.Value.Day,
subjectTime.Value.Hour, subjectTime.Value.Minute, subjectTime.Value.Second);
dateToSend = date;
}
catch (Exception)
{
MessageBox.Show("Prosze podac poprawne dane.");
}
Subjects subject = new Subjects()
{
subjectName = subjectName,
subjectTime = dateToSend
};
SubjectController controller = new SubjectController();
if (controller.SubjectValidation(subject))
{
controller.AddSubject(subject);
MessageBox.Show("Pomyślne dodanie przedmiotu.");
AddSubjectName_TextBox.Text = "";
}
DataGridController gridController = new DataGridController(TimeTable_DataGrid);
gridController.SetDataSourceForSubjects();
}
private void DeleteExam_Button_Click(object sender, RoutedEventArgs e)
{
Exams examToDelete = new Exams();
try
{
var itemToDelete = (Exams)ExamGrid.SelectedValue;
examToDelete = itemToDelete;
}
catch (Exception)
{
MessageBox.Show("Prosze zaznaczyc obiekt");
}
try
{
ExamController controller = new ExamController();
controller.DeleteExam(examToDelete.examId);
try
{
ToLearnController toLearnController = new ToLearnController(examToDelete.examName, 10);
toLearnController.DeleteLearningDayIfExamDeleteClicked();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
DataGridController gridController = new DataGridController(ExamGrid);
gridController.SetDataSourceForExams();
gridController.DataGrid = WhatToLearnToday_DataGrid;
gridController.SetDataSourceForLearningDays();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Wystapil blad.");
}
}
public GridClipboard(DataGridController controller, string text, TextViewFormat format) : this(controller, GetArrayFromText(text, format))
{
}
public DataGridBaseView()
{
InitializeComponent();
Controller = new DataGridController(dataGridView, bindingSource, buttonSave, buttonCancel);
}
private void UserControl_Initialized(object sender, EventArgs e)
{
DataGridControllerResult = new DataGridController();
DataGridControllerResult.Grid = dataGridResult;
}
