public DetailedBox(string st, Student s, IManageStudent l) { InitializeComponent(); _link = l; _student = s; _mode = st; boxName.Content = st + " student"; comboBox.ItemsSource = EntityDb.LoadStudies(); comboBox.DisplayMemberPath = "Name"; listBox.ItemsSource = EntityDb.LoadSubjects(); listBox.DisplayMemberPath = "Name"; if (_student != null) { fBox.Text = _student.FirstName; lBox.Text = _student.LastName; iBox.Text = _student.IndexNumber; foreach (Study study in EntityDb.LoadStudies()) { if (study.IdStudies == _student.IdStudies) { comboBox.SelectedItem = study; } } foreach (Student_Subject sb in EntityDb.LoadStudents_Subj()) { if (sb.IdStudent == _student.IdStudent) { listBox.SelectedItem = EntityDb.FindSubject(sb.IdSubject); } } } }
public static TariffViewModel FromTariff(Tariff tariff, EntityDb db) { return(new TariffViewModel { Id = tariff.Id, Since = tariff.Since, Until = tariff.Until, Kind = tariff.Kind, ConsumptionRanges = db.ConsumptionRanges.Select(From).ToList(), }); }
public static bool EditWithoutCommit(T entity) { try { EntityDb <T> .SaveOrUpdate(entity); return(true); } catch (Exception) { throw; } }
public static bool AddNewWithoutCommit(T entity) { try { EntityDb <T> .Save(entity); return(true); } catch (Exception) { throw; } }
public static bool Commit() { try { EntityDb <T> .CommitChanges(); EntityDb <T> .CloseSession(); return(true); } catch (Exception) { throw; } }
private void DeleteButton_Click(object sender, RoutedEventArgs e) { if (MessageBox.Show("Do you realy want to delete?", "Question", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.No) { return; } else { foreach (Student s in StudentsDataGrid.SelectedItems) { EntityDb.DeleteStudent(s); } GetStudents(); } }
public static List <T> PagedGetAllEntities(int start, int pageSize, out int totalCount) { try { List <T> results = new List <T>(); results = EntityDb <T> .PagedGetAll(start, pageSize, out totalCount); EntityDb <T> .CloseSession(); return(results); } catch (Exception) { throw; } }
public static List <T> GetAllEntities() { try { List <T> results = new List <T>(); results = EntityDb <T> .GetAll(); EntityDb <T> .CloseSession(); return(results); } catch (Exception) { throw; } }
public static List <T> PagedGetEntities(System.Linq.Expressions.Expression <Func <T, bool> > query, int start, int pageSize, out int totalCount) { try { List <T> results = new List <T>(); results = EntityDb <T> .PagedGetByLinqQuery(query, start, pageSize, out totalCount); EntityDb <T> .CloseSession(); return(results); } catch (Exception) { throw; } }
public static List <T> GetEntities(Func <T, bool> query) { try { List <T> results = new List <T>(); results = EntityDb <T> .GetByLinqQuery(query); EntityDb <T> .CloseSession(); return(results); } catch (Exception) { throw; } }
public static bool EditEntity(T entity) { try { EntityDb <T> .SaveOrUpdate(entity); EntityDb <T> .CommitChanges(); EntityDb <T> .CloseSession(); return(true); } catch (Exception) { throw; } }
public GetCustomerListResponse Search([FromBody] GetCustomerListRequest request) { const string message = "Could not find customer."; try { var response = new GetCustomerListResponse(); using (var db = new EntityDb()) { var customerList = db.Customers.AsQueryable(); // This is the two lines needed from the Expression Builder project // to build the Lambda query. var search = new SearchFilter <Customer>(); Filter <Customer> filter = search.Filter(request.SearchCriteria); var results = customerList.Where(filter) .Select(c => new CustomerDto { CustomerId = c.CustomerID, CustomerName = c.CustomerName, PhoneNumber = c.PhoneNumber, DeliveryAddressLine1 = c.DeliveryAddressLine1, DeliveryAddressLine2 = c.DeliveryAddressLine2, DeliveryPostalCode = c.DeliveryPostalCode, PostalAddressLine1 = c.PostalAddressLine1, PostalAddressLine2 = c.PostalAddressLine2 }).ToList(); response.CustomerList = results; } response.Success = true; return(response); } catch (Exception) { return(new GetCustomerListResponse { Success = false, Message = message }); } }
public Tariff ToTariff(EntityDb db) { var allRanges = db.ConsumptionRanges.ToList(); var targetRanges = allRanges .Select(r => new { Range = r, Description = From(r) }) .Where(item => ConsumptionRanges?.Contains(item.Description) ?? false) .DistinctBy(item => item.Range.Id) .Select(item => item.Range) .ToList(); var tariff = db.Tariffs.FirstOrDefault(t => t.Id == Id) ?? new Tariff { Id = Id ?? 0 }; tariff.Since = Since; tariff.Until = Until; tariff.Kind = Kind; tariff.Ranges = targetRanges; return(tariff); }
public int verifyData() { if (string.IsNullOrWhiteSpace(lBox.Text) || lBox.Text.Length < 1) { MessageBox.Show("Wrong input in 1 row!"); return(0); } if (string.IsNullOrWhiteSpace(fBox.Text) || fBox.Text.Length < 1) { MessageBox.Show("Wrong input in 2 row!"); return(0); } if (string.IsNullOrWhiteSpace(iBox.Text) || iBox.Text.Length < 2 || !iBox.Text[0].Equals('s') || !int.TryParse(iBox.Text.Substring(1), out int n)) { MessageBox.Show("Wrong index number!(starts with 's' and only numbers after)"); return(0); } if (comboBox.SelectedItem == null) { MessageBox.Show("You should select one study type!"); return(0); } if (listBox.SelectedItems == null) { MessageBox.Show("You should select at least 1 subject!"); return(0); } foreach (Study study in EntityDb.LoadStudies()) { if (((Study)comboBox.SelectedItem).IdStudies == study.IdStudies) { return(study.IdStudies); } } MessageBox.Show("Sth wrong..."); return(0); }
static void Main(string[] args) { try { using (EntityDb context = new EntityDb()) { EntityConnection ec = new EntityConnection(context.ConnectionString); try { ec.Open(); ec.Close(); } catch (Exception ex) { MLogger.Error(ex.ToString()); MessageBox.Show($"Ошибка подключения к базе заданий. Original: EntityException: {ex.Message}", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } } catch (Exception ex) { MLogger.Error(ex.ToString()); MessageBox.Show($"Ошибка подключения к базе заданий. Original: EntityException: {ex.Message}", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } string currentExePath = Application.ExecutablePath; string exeName = Path.GetFileName(currentExePath); if (Path.Combine(MQueryCommand.GetSetting("MonitorSelfUpdatePath").Value, exeName).Trim().ToUpper() == currentExePath.Trim().ToUpper()) { new DialogTimerForm($"Невозможно запустить MagicUpdaterMonitor из общей папки обновления!{Environment.NewLine}Скачайте папку с программой на локальный компьютер.").ShowDialog(); return; } bool forceStart = false; forceStart = args.Length > 0 && args[0] == "force"; if (forceStart) { Process process1 = Process.GetCurrentProcess(); if (process1 != null) { foreach (Process pr in Process.GetProcessesByName(process1.ProcessName)) { if (pr.Id != process1.Id) { pr.Kill(); } } } } MainForm.HwId = HWID.Value(); //Создаем пользователя в базе, если его нет MQueryCommand.CreateUser(Environment.UserName, MainForm.HwId); MainForm.UserId = MQueryCommand.GetUserId(Environment.UserName, MainForm.HwId); if (MainForm.UserId == 0) { MessageBox.Show($"Ошибка получения UserId по имени {Environment.UserName}", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); Environment.Exit(0); } Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); #if !DEBUG && !NO_UPDATE if (SelfUpdate.IsUpdateNeeded()) { SelfUpdate.Update(new UpdatingForm()); } else { StartApplication(); } #endif #if DEBUG || NO_UPDATE StartApplication(); #endif }
public ElectricityCalculator(EntityDb db) { _db = db; }
void IManageStudent.ModifyStudent(Student st, List <Subject> list) { EntityDb.UpdateStud(st, list); GetStudents(); }
void IManageStudent.AddStudent(Student st, List <Subject> list) { EntityDb.CreateStud(st, list); GetStudents(); }
public void GetStudents() { StudentsDataGrid.ItemsSource = EntityDb.LoadStudents(); }
private void AddEditTask() { if (string.IsNullOrEmpty(this.edTaskName.Text)) { MessageBox.Show("Значение поля 'Название задачи' не может быть пустым.", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Warning); this.ActiveControl = this.edTaskName; return; } List <int> selectedComputers = rgvComputersForSheduler.SelectedValues.Select(s => (int)s).ToList(); // Добавление таска this.lbTasks.DisplayMember = "Name"; this.lbTasks.ValueMember = "Id"; var schedulerTask = new ShedulerTask { Name = this._newTaskName, //StartTime = DateTime.Now.AddHours(1) }; // Заполнение списка компьютеров var computersList = selectedComputers.Select(x => new ShedulerTasksComputersList { ComputerId = x }).ToList(); if (this._isAddTaskMode) { var addedIndex = this.lbTasks.Items.Add(schedulerTask); // Добавление новой задачи var addTaskResult = MQueryCommand.TryInsertNewTask(this.edTaskName.Text, cmbTaskModes.SelectedIndex, this.pckrStartDateTime.Value.Add(-_utcOffset), computersList, this.chbEnable.Checked); if (!addTaskResult.IsComplete) { MessageBox.Show($"Ошибка добавления новой задачи{Environment.NewLine}{addTaskResult.Message}", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } // Добавление шагов var stepsWereAdded = stepsTree1.AddSteps(addTaskResult.ReturnedId); if (!stepsWereAdded) { using (EntityDb context = new EntityDb()) { try { var task = context.ShedulerTasks.First(x => x.Id == addTaskResult.ReturnedId); context.ShedulerTasks.Remove(task); context.SaveChanges(); } catch (Exception ex) { MLogger.Error(ex.ToString()); MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } this.lbTasks.Items.Remove(schedulerTask); MessageBox.Show("Невозможно добавление новой задачи без указания операций. Необходимо указать как минимум одну операцию.", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } // Перезагрузка списка задач this.UpdateTasksList(); this.lbTasks.SelectedIndex = addedIndex; this._isAddTaskMode = false; MessageBox.Show($"Задача '{this.edTaskName.Text}' была успешно добавлена", "Информация", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { // Редактирование выбранной задачи var selectedTaskItem = (ShedulerTask)lbTasks.SelectedItem; if (selectedTaskItem == null) { return; } var updateResult = MQueryCommand.TryUpdateTask(selectedTaskItem.Id, this.chbEnable.Checked, this.edTaskName.Text, null, cmbTaskModes.SelectedIndex, this.pckrStartDateTime.Value.Add(-_utcOffset), computersList); if (!updateResult.IsComplete) { MessageBox.Show($"Ошибка при обновлении данных{Environment.NewLine}{updateResult.Message}", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } // Очистка списка шагов //if (!this.stepsTree1.IsEmpty()) //{ // this.ClearSteps(selectedTaskItem.Id); //} //Удаление шагов var stepsWereDeleted = MQueryCommand.TryDeleteSteps(stepsTree1.StepsIdListToDelete); if (!stepsWereDeleted.IsComplete) { MessageBox.Show(stepsWereDeleted.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } // Добавление шагов var stepsWereEdited = stepsTree1.AddSteps(selectedTaskItem.Id); if (!stepsWereEdited) { MessageBox.Show("Невозможно сохраниение изменений для дерева операций. Требуется добавить хотя бы одну операцию.", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } var currentSelectedIndex = this.lbTasks.SelectedIndex; this.UpdateTasksList(); this.lbTasks.SelectedIndex = currentSelectedIndex; MessageBox.Show($"Изменения по задаче '{this.edTaskName.Text}' были успешно сохранены", "Информация", MessageBoxButtons.OK, MessageBoxIcon.Information); } this.toolStripButtonAddTask.Enabled = this.toolStripButtonRemoveTask.Enabled = this.lbTasks.Enabled = true; this.labelEditing.Visible = false; this.btnCancel.Visible = false; }