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;
}
