public void Delete() { if (SelectedDataItem != null) { if (MessageBox.Show("Are you sure you want to delete all selected Groups??", "Delete", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.Yes) { IsInProgress = true; new Thread(() => { foreach (var item in DataGridSource) { if (item.IsChecked) { try { DataAccess.DeleteGroup(item.GId); DataAccess.DeleteGroupRoles(item.GId); } catch { MessageBox.Show("could not open connection with server!\nCheck your internet connection or server is connected", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning); } } } DataGridSource.ReFill(DataGridSource.Where(x => !x.IsChecked).ToList()); IsInProgress = false; }) { IsBackground = true }.Start(); GroupRolesSource.Clear(); } } }
public MainWindowVM() { for (var i = 0; i < 100; ++i) { DataGridSource.Add(new ItemVM()); } }
public void Add() { VPersonAdd add = new VPersonAdd(PersonsTypes, CommTypes); if (add.ShowDialog() == true) { var dataContext = (add.DataContext as VMPersonAdd); PersonsCommunication.AddRange(dataContext.AddedCommunication); PersonsAddress.AddRange(dataContext.AddedAddress); var AddedPerson = dataContext.AddedPerson; var adress = PersonsAddress.Where(x => x.PeAdPerIdFk == AddedPerson.PeId).FirstOrDefault(); if (adress != null) { AddedPerson.PeAddress = $"{adress.PeAdCity.Trim()} - {adress.PeAdStreetName.Trim()}"; } AddedPerson.Type = PersonsTypes.Where(x => x.CId == AddedPerson.PeType).FirstOrDefault().CName; var communication = PersonsCommunication.Where(x => x.CoPeIdFk == AddedPerson.PeId); AddedPerson.PhoneNo = communication.Where(x => x.CoNameCfk.Equals(SystemValues.Communications.Phone)).FirstOrDefault()?.CoValue; AddedPerson.MobileNo = communication.Where(x => x.CoNameCfk.Equals(SystemValues.Communications.Mobile)).FirstOrDefault()?.CoValue; AddedPerson.Email = communication.Where(x => x.CoNameCfk.Equals(SystemValues.Communications.Emial)).FirstOrDefault()?.CoValue; Persons.Add(AddedPerson); DataGridSource.Add(dataContext.AddedPerson); } }
private void ExecuteStartCommand(object x) { if (serialPort == null) { serialPort = new SerialPort(SelectedComPort.DeviceID, 9600, Parity.None, 8, StopBits.One); // 改行コードまでUIに反映されないよう、システムの改行コードを設定しておく serialPort.NewLine = Environment.NewLine; } serialPort.Open(); serialPort.DataReceived += (s, e) => { var readData = serialPort.ReadLine(); // ViewModelBaseのDispatcherプロパティを使って、UIスレッドに値を渡す Dispatcher.Invoke(new Action(() => { if (DataGridSource == null) { DataGridSource = new ObservableCollection <SerialPortModel>(); } DataGridSource.Add(new SerialPortModel() { ReadData = readData }); })); }; UpdateStatus(); }
protected void SelectedConstantChanging(CodesModel newValue) { IsInProgress = true; if (newValue != null) { DataGridSource.ReFill(SystemConstants.Where(x => x.CMasterId == newValue.CId)); } IsInProgress = false; }
public void Refresh() { new Thread(() => { Thread inProgress = new Thread(() => { IsInProgress = true; try { Persons = DataAccess.PersonsData(); PersonsAddress = DataAccess.PersonsAddressData(); PersonsCommunication = DataAccess.PersonsCommunicationData(); PersonsTypes = DataAccess.CodesData(SystemValues.MasterSystemConstants.PersonType); CommTypes = DataAccess.CodesData(SystemValues.MasterSystemConstants.CommunicationType); } catch { MessageBox.Show("could not open connection with server!\nCheck your internet connection or server is connected", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning); } foreach (var item in Persons) { var adress = PersonsAddress.Where(x => x.PeAdPerIdFk == item.PeId).FirstOrDefault(); if (adress != null) { item.PeAddress = $"{adress.PeAdCity.Trim()} - {adress.PeAdStreetName.Trim()}"; } var communication = PersonsCommunication.Where(x => x.CoPeIdFk == item.PeId); item.Type = PersonsTypes.Where(x => x.CId == item.PeType).FirstOrDefault()?.CName; item.PhoneNo = communication.Where(x => x.CoNameCfk.Equals(SystemValues.Communications.Phone)).FirstOrDefault()?.CoValue; item.MobileNo = communication.Where(x => x.CoNameCfk.Equals(SystemValues.Communications.Mobile)).FirstOrDefault()?.CoValue; item.Email = communication.Where(x => x.CoNameCfk.Equals(SystemValues.Communications.Emial)).FirstOrDefault()?.CoValue; } }) { IsBackground = true }; inProgress.Start(); while (inProgress.IsAlive) { if (RotateAngle > 360) { RotateAngle = 0; } RotateAngle += 18.25; Thread.Sleep(50); } while (RotateAngle > 0 && RotateAngle < 365) { RotateAngle += 18.25; Thread.Sleep(50); } RotateAngle = 0; DataGridSource.ReFill(Persons); IsInProgress = false; }) { IsBackground = true }.Start(); }
private void Form2_Load(object sender, EventArgs e) { List <string> displayColumns = new List <string>(); displayColumns.Add("id"); displayColumns.Add("Name"); displayColumns.Add("Fruit"); displayColumns.Add("BoughtFrom"); displayColumns.Add("Date"); List <GroupColumn> groupColumns = new List <GroupColumn>(); groupColumns.Add(new GroupColumn("Quantity", GroupTypeEnum.Sum)); String connectionString = SolarDataManager.Properties.Settings.Default.SolarConnectionString; SqlConnection connection = new SqlConnection(connectionString); connection.Open(); SqlDataAdapter dataAdapter = new SqlDataAdapter( "SELECT * from dbo.prospect", connection); DataTable dtResult1 = new DataTable(); dataAdapter.Fill(dtResult1); dataAdapter = new SqlDataAdapter( "select * from dbo.account", connection); DataTable dtResult2 = new DataTable(); dataAdapter.Fill(dtResult2); DataSet dsResults = new DataSet("Results"); dsResults.Tables.Add(dtResult1); dsResults.Tables.Add(dtResult2); DataRelation relation1 = new DataRelation( "relation1", dtResult1.Columns["prospect_id"], dtResult2.Columns["prospect_id"]); dsResults.Relations.Add(relation1); DataGridSource newGridSource = new DataGridSource( dtResult1.DataSet, displayColumns, groupColumns); hierarchicalGridView1.DataSource = newGridSource; }
public void Refresh() { refrechThread = new Thread(() => { List <UsersModel> Users = new List <UsersModel>(); Thread inProgress = new Thread(() => { try { Groups = DataAccess.GroupsData(); Users = DataAccess.UsersData(); GroupRoles = DataAccess.GroupRolesData(); UserGroups = DataAccess.UserGroupsData(); Roles = DataAccess.RolesData(); SystemConstants = DataAccess.CodesData(); Persons = DataAccess.PersonsData(); PersonsAddress = DataAccess.PersonsAddressData(); PersonCommunications = DataAccess.PersonsCommunicationData(); } catch { MessageBox.Show("could not open connection whith server!\nCheck your internet connection or server is connected", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning); return; } }) { IsBackground = true }; inProgress.Start(); while (inProgress.IsAlive) { if (RotateAngle > 360) { RotateAngle = 0; } RotateAngle += 18.25; Thread.Sleep(50); } while (RotateAngle > 0 && RotateAngle < 365) { RotateAngle += 18.25; Thread.Sleep(50); } RotateAngle = 0; DataGridSource.ReFill(Users); }) { IsBackground = true }; refrechThread.Start(); }
public void Refresh() { GroupRoles.Clear(); new Thread(() => { List <GroupsModel> dataSource = null; Thread inProgress = new Thread(() => { IsInProgress = true; try { dataSource = DataAccess.GroupsData(); GroupRoles = DataAccess.GroupRolesData(); Roles = DataAccess.RolesData(); } catch { MessageBox.Show("could not open connection with server!\nCheck your internet connection or server is connected", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning); } }) { IsBackground = true }; inProgress.Start(); while (inProgress.IsAlive) { if (RotateAngle > 360) { RotateAngle = 0; } RotateAngle += 18.25; Thread.Sleep(50); } while (RotateAngle > 0 && RotateAngle < 365) { RotateAngle += 18.25; Thread.Sleep(50); } RotateAngle = 0; DataGridSource.ReFill(dataSource); IsInProgress = false; }) { IsBackground = true }.Start(); GroupRolesSource.Clear(); }
public void loadData() { for (int i = 1; i < 20; i++) { DataGridSource.Add(new Person() { ID = i.ToString(), Firstname = "Firstname " + i.ToString(), Lastname = "Lastname " + i.ToString(), Age = rnd.Next(20, 60).ToString(), }); } foreach (Person item in DataGridSource) { item.PropertyChanged += onPropertyChanged; } }
public void Edit() { if (SelectedDataItem != null) { var item = SelectedDataItem; for (int i = 0; i < Roles.Count; i++) { var role = GroupRolesSource.Where(x => x.RoleId == Roles[i].RoleId).FirstOrDefault(); if (role != null) { var groupRoles = GroupRoles.Where(x => x.GrolrRoleIdFk == Roles[i].RoleId && x.GrolrGIdFk == item.GId).FirstOrDefault(); Roles[i].IsChecked = true; Roles[i].GroleAdd = groupRoles.GroleAdd; Roles[i].GroleEdit = groupRoles.GroleEdit; Roles[i].GroleDelete = groupRoles.GroleDelete; Roles[i].GroleExport = groupRoles.GroleExport; Roles[i].GrolePrint = groupRoles.GrolePrint; Roles[i].GroleView = groupRoles.GroleView; } else { Roles[i].IsChecked = false; Roles[i].GroleAdd = false.ToIntState(); Roles[i].GroleEdit = false.ToIntState(); Roles[i].GroleDelete = false.ToIntState(); Roles[i].GroleExport = false.ToIntState(); Roles[i].GrolePrint = false.ToIntState(); Roles[i].GroleView = false.ToIntState(); } } VGroupsEdit edit = new VGroupsEdit(Roles, item); if (edit.ShowDialog() == true) { var dataContext = edit.DataContext as VMGroupsEdit; DataGridSource.Remove(SelectedDataItem); DataGridSource.Add(dataContext.EditGroup); GroupRoles.RemoveAll(x => x.GrolrGIdFk == item.GId); GroupRoles.AddRange(dataContext.DataGridSource.Where(x => x.RoleSelected()).Select(x => x.ToGroupRoles(item.GId))); } GroupRolesSource.Clear(); } }
private void OnNewOpenFileDialog() { var dlg = new OpenFileDialogViewModel { Title = "Select a file (I won't actually do anything with it)", Filter = "All files (*.xml)|*.xml", Multiselect = false }; if (dlg.Show(this.Dialogs) && dlg.FileName != null) { if (DataGridSource != null && DataGridSource.Count > 0) { DataGridSource.Clear(); } dbReaderWriter.ReadDatabase(dlg.FileName); RestoreFromDB(); } }
public void Edit() { var person = new PersonsModel() { PeId = SelectedDataItem.PeId, PeAddress = SelectedDataItem.PeAddress, IsChecked = SelectedDataItem.IsChecked, PeIdentity = SelectedDataItem.PeIdentity, PeName = SelectedDataItem.PeName, PeType = SelectedDataItem.PeType, }; VPersonEdit edit = new VPersonEdit(person, PersonsTypes, CommTypes, PersonsCommunication.Where(x => x.CoPeIdFk == person.PeId).ToList()); if (edit.ShowDialog() == true) { var dataContext = edit.DataContext as VMPersonEdit; Persons.Remove(SelectedDataItem); DataGridSource.Remove(SelectedDataItem); PersonsCommunication.RemoveAll(x => x.CoPeIdFk == dataContext.EditedPerson.PeId); PersonsCommunication.AddRange(dataContext.AddedCommunication); PersonsAddress.RemoveAll(x => x.PeAdPerIdFk == dataContext.EditedPerson.PeId); PersonsAddress.AddRange(dataContext.AddedAddress); var adress = PersonsAddress.Where(x => x.PeAdPerIdFk == dataContext.EditedPerson.PeId).FirstOrDefault(); if (adress != null) { dataContext.EditedPerson.PeAddress = $"{adress.PeAdCity} - {adress.PeAdStreetName}"; } dataContext.EditedPerson.Type = PersonsTypes.Where(x => x.CId == dataContext.EditedPerson.PeType).FirstOrDefault().CName; var communication = PersonsCommunication.Where(x => x.CoPeIdFk == dataContext.EditedPerson.PeId); dataContext.EditedPerson.PhoneNo = communication.Where(x => x.CoNameCfk.Equals(SystemValues.Communications.Phone)).FirstOrDefault()?.CoValue; dataContext.EditedPerson.MobileNo = communication.Where(x => x.CoNameCfk.Equals(SystemValues.Communications.Mobile)).FirstOrDefault()?.CoValue; dataContext.EditedPerson.Email = communication.Where(x => x.CoNameCfk.Equals(SystemValues.Communications.Emial)).FirstOrDefault()?.CoValue; Persons.Add(dataContext.EditedPerson); DataGridSource.Add(dataContext.EditedPerson); SelectedDataItem = dataContext.EditedPerson; } }
public void Delete() { if (SelectedDataItem != null) { if (MessageBox.Show("Are you sure you want to delete all selected Persons??", "Delete", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.Yes) { foreach (var item in DataGridSource) { if (item.IsChecked) { DataAccess.DeletePerson(item.PeId); DataAccess.DeletePersonCommunication(item.PeId); DataAccess.DeletePersonAddress(item.PeId); } } DataGridSource.ReFill(DataGridSource.Where(x => !x.IsChecked).ToList()); } } }
public void Delete() { if (SelectedDataItem != null) { if (MessageBox.Show("Are you sure you want to delete all selected Users??", "Delete", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.Yes) { IsInProgress = true; new Thread(() => { foreach (var item in DataGridSource) { if (item.IsChecked) { try { DataAccess.DeleteUserGroups((int)item.UPIdFk); DataAccess.DeletePersonAddress((int)item.UPIdFk); DataAccess.DeletePersonCommunication((int)item.UPIdFk); DataAccess.DeletePerson((int)item.UPIdFk); DataAccess.DeleteUser((int)item.UPIdFk); } catch { MessageBox.Show($"could not open connection with server while deleting {item.UUserName}!\nCheck your internet connection or server is connected", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning); } } } DataGridSource.ReFill(DataGridSource.Where(x => !x.IsChecked).ToList()); IsInProgress = false; }) { IsBackground = true }.Start(); } } }
public void Add() { foreach (var item in Roles) { item.IsChecked = false; item.GroleAdd = false.ToIntState(); item.GroleEdit = false.ToIntState(); item.GroleDelete = false.ToIntState(); item.GroleExport = false.ToIntState(); item.GrolePrint = false.ToIntState(); item.GroleView = false.ToIntState(); } VGroupsAdd add = new VGroupsAdd(Roles); if (add.ShowDialog() == true) { DataGridSource.Add((add.DataContext as VMGroupsAdd).AddedGroup); foreach (var item in (add.DataContext as VMGroupsAdd).AddedGroupRoles) { GroupRoles.Add(item); } } GroupRolesSource.Clear(); }
private void RestoreFromDB() { EventObjectModel tempModel = new EventObjectModel(); foreach (EventObjectModel eo in dbReaderWriter.eventObjects) { foreach (ResponseObjectModel rom in eo.ResponseCollection) { if (rom.ResponseObject is TelegramMessageObjectModel) { var botListQuery = DataGridSource.SelectMany( u => u.ResponseCollection.Where( v => v.ResponseObject is TelegramMessageObjectModel).Select( w => w.ResponseObject as TelegramMessageObjectModel).Select(x => x.Bot2Use).ToList() ).ToList(); var selectedBotQuery = DataGridSource.SelectMany( u => u.ResponseCollection.Where( v => v.ResponseObject is TelegramMessageObjectModel).Select( w => w.ResponseObject as TelegramMessageObjectModel).Select( x => x.Bot2Use) ).ToList(); if ((rom.ResponseObject is TelegramMessageObjectModel) && !(botListQuery.Select(y => y.Token).Contains((rom.ResponseObject as TelegramMessageObjectModel).Bot2Use.Token))) { try{ (rom.ResponseObject as TelegramMessageObjectModel).Bot2Use.CreateBot(); } catch (Exception e) { if (e.InnerException.GetType().ToString() == "System.Net.Http.HttpRequestException") { LogWriter.CreateLogEntry(string.Format("{0}\n{1}", e.Message, e.InnerException != null ? e.InnerException.Message : "")); this.Dialogs.Add(new CustomDialogViewModel { Message = e.InnerException.InnerException.Message, Caption = "Error", OnOk = (sender2) => { sender2.Close(); }, OnCancel = (sender2) => { sender2.Close(); }, OnCloseRequest = (sender2) => { sender2.Close(); } }); } } } else if (botListQuery.Select(y => y.Token).Contains((rom.ResponseObject as TelegramMessageObjectModel).Bot2Use.Token)) { (rom.ResponseObject as TelegramMessageObjectModel).Bot2Use = selectedBotQuery.Where(z => z.Token == (rom.ResponseObject as TelegramMessageObjectModel).Bot2Use.Token).FirstOrDefault(); } } else if (rom.ResponseObject is EMailResponseObjectModel) { } } DataGridSource.Add(eo); SelectedDataGridItem = eo; SelectedResponse = SelectedDataGridItem.ResponseCollection.FirstOrDefault(); } }
public VMGroupsAdd(List <RolesModel> roles) { DataGridSource.ReFill(roles); }
private void AddNewEvent() { this.Dialogs.Add(new EventEditorDialogViewModel(DataGridSource, SelectedDataGridItem) { OnOk = (sender) => { //TODO: Test for Duplicate entrys / Overwrite or create new? if (sender.HasConfiguration && sender.ObjectModel.EventType == sender.SelectedGeneralEventType) { if (selectedDataGridItem == null) { if (DataGridSource.Contains(sender.ObjectModel)) { if (new MessageBoxViewModel { Caption = resLoader.getResource("messageBoxEventAlreadyExistCaption"), Message = resLoader.getResource("messageBoxEventAlreadyExistMessage"), Buttons = MessageBoxButton.OK, Image = MessageBoxImage.Information } .Show(this.Dialogs) == MessageBoxResult.OK) { return; } } else { DataGridSource.Add(sender.ObjectModel); } } else { SelectedDataGridItem.EventName = sender.EventName; SelectedDataGridItem.EventDescription = sender.EventDescription; } sender.Close(); } else { new MessageBoxViewModel { Caption = resLoader.getResource("messageBoxMissingConfigCaption"), Message = resLoader.getResource("messageBoxMissingConfigMessage"), Buttons = MessageBoxButton.OK, Image = MessageBoxImage.Information } .Show(this.Dialogs); } RaisePropertyChanged("DataGridSource"); }, OnCancel = (sender) => { sender.Close(); }, OnCloseRequest = (sender) => { sender.Close(); } }); }
public VMGroupsEdit(List <RolesModel> roles, GroupsModel group) { Group = group; PresentGroup(group); DataGridSource.ReFill(roles); }
private void DeleteRow() { DataGridSource.Remove(selectedDataGridItem); }