private void AddressForm_Load(object sender, EventArgs e)
{
var userList = MongoRepositoryUsers.GetAll();
foreach (var user in userList)
{
comboBox_users.Items.Add(new ComboBoxItem(user.Name, user.Id));
}
comboBox_users.SelectedIndex = 0;
if (Address == null)
{
return;
}
textBox_street.Text = Address.Street;
textBox_house.Text = Address.House;
textBox_biulding.Text = Address.Building;
textBox_apartment.Text = Address.Apartment;
comboBox_users.SelectedItem = comboBox_users.Items.IndexOf(new ComboBoxItem(string.Empty, Address.UserId));
foreach (var people in PeopleList)
{
dataGridView1.Rows.Add(people.Id, people.LastName, people.FirstName, people.SurName, people.Phone);
}
}
private void button_search_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(textBox1.Text))
{
dataGridView1.Rows.Clear();
var addressList = MongoRepositoryAddresses.GetAll();
var userList = MongoRepositoryUsers.GetAll();
foreach (var address in addressList)
{
var user = userList.First(f => f.Id == address.UserId);
dataGridView1.Rows.Add(address.Id, address.Street, address.House, address.Building,
address.Apartment, user.Name);
}
}
else
{
dataGridView1.Rows.Clear();
var addressList = MongoRepositoryAddresses.Search(textBox1.Text);
var userList = MongoRepositoryUsers.GetAll();
foreach (var address in addressList)
{
var user = userList.First(f => f.Id == address.UserId);
dataGridView1.Rows.Add(address.Id, address.Street, address.House, address.Building,
address.Apartment, user.Name);
}
}
}
private void button2_Click(object sender, EventArgs e)
{
var startTicks = dateTimePicker21.Value.Date.Ticks;
var endTicks = dateTimePicker22.Value.Date.AddDays(1).Ticks;
var eventList = MongoRepositoryOrgEvent.GetByDate(startTicks, endTicks,
new List <EventType>
{
EventType.DISASSEMBLY,
EventType.INSTALL,
EventType.REVISION,
EventType.VERIFICATION
});
var userList = MongoRepositoryUsers.GetAll();
var addressIdList = eventList.Select(s => s.AddressId).Distinct().ToList();
var addressList = MongoRepositoryAddresses.GetMany(addressIdList);
foreach (var orgEvent in eventList)
{
orgEvent.AddressId = addressList.First(f => f.Id == orgEvent.AddressId).UserId;
}
Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
Workbook xlWorkBook = xlApp.Workbooks.Open(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Templates\\template_report_events_controller.xls"), 0, true, 5, "", "", true, XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
_Worksheet xlWorksheet = (_Worksheet)xlWorkBook.Sheets[1];
xlWorksheet.Cells[4, 2] = dateTimePicker21.Value.Date.ToString("D");
xlWorksheet.Cells[4, 5] = dateTimePicker22.Value.Date.ToString("D");
var startRow = 7;
var grouped = eventList.GroupBy(g => g.AddressId).ToDictionary(d => d.Key);
foreach (var keyValue in grouped)
{
var val = keyValue.Value;
var userName = userList.First(f => f.Id == keyValue.Key).Name;
xlWorksheet.Cells[startRow, 1] = userName;
xlWorksheet.Cells[startRow, 2] = val.Count(w => w.EventType == EventType.INSTALL);
xlWorksheet.Cells[startRow, 3] = val.Count(w => w.EventType == EventType.VERIFICATION);
xlWorksheet.Cells[startRow, 4] = val.Count(w => w.EventType == EventType.REVISION);
xlWorksheet.Cells[startRow, 5] = val.Count(w => w.EventType == EventType.DISASSEMBLY);
var startCell = xlWorksheet.Cells[startRow, 1];
var endCell = xlWorksheet.Cells[startRow, 5];
var range = xlWorksheet.Range[startCell, endCell];
range.Style.HorizontalAlignment = XlHAlign.xlHAlignCenter;
range.Style.VerticalAlignment = XlVAlign.xlVAlignCenter;
range.Borders.LineStyle = XlLineStyle.xlContinuous;
var start = xlWorksheet.Cells[startRow, 1];
var end = xlWorksheet.Cells[startRow, 1];
xlWorksheet.Range[start, end].Font.Bold = true;
xlWorksheet.Range[start, end].Borders.Weight = XlBorderWeight.xlMedium;
startRow++;
}
xlApp.Visible = true;
}
private void button_remove_Click(object sender, EventArgs e)
{
int selectedrowindex = dataGridView1.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = dataGridView1.Rows[selectedrowindex];
string a = Convert.ToString(selectedRow.Cells["Id"].Value);
var id = Guid.Parse(a);
MongoRepositoryUsers.Remove(id);
}
private void VerificationListForm_Load(object sender, EventArgs e)
{
var userList = MongoRepositoryUsers.GetAll();
foreach (var user in userList)
{
comboBox1.Items.Add(new ComboBoxItem(user.Name, user.Id));
}
}
private void AdminForm_Activated(object sender, EventArgs e)
{
dataGridView1.Rows.Clear();
var userList = MongoRepositoryUsers.GetAll();
foreach (var user in userList)
{
dataGridView1.Rows.Add(user.Id, user.Name, user.Password, user.IsAdmin);
}
}
private void button_update_Click(object sender, EventArgs e)
{
int selectedrowindex = dataGridView1.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = dataGridView1.Rows[selectedrowindex];
string a = Convert.ToString(selectedRow.Cells["Id"].Value);
var id = Guid.Parse(a);
var user = MongoRepositoryUsers.Get(id);
new UserForm(user).ShowDialog();
}
private void AddressesForm_Activated(object sender, EventArgs e)
{
dataGridView1.Rows.Clear();
var addressList = MongoRepositoryAddresses.GetAll();
var userList = MongoRepositoryUsers.GetAll();
foreach (var address in addressList)
{
var user = userList.First(f => f.Id == address.UserId);
dataGridView1.Rows.Add(address.Id, address.Street, address.House, address.Building,
address.Apartment, user.Name);
}
}
private void button_ok_Click(object sender, EventArgs e)
{
var user = new User
{
Id = User?.Id ?? Guid.NewGuid(),
Name = textBox1.Text,
Password = (User != null && User?.Password == textBox2.Text) ? User.Password : Helpers.sha256_hash(textBox2.Text),
IsAdmin = checkBox1.Checked,
IsDeleted = false
};
MongoRepositoryUsers.Upsert(user);
Close();
}
private void button_ok_Click(object sender, EventArgs e)
{
var name = textBox_name.Text;
var password = Helpers.sha256_hash(textBox_password.Text);
User = MongoRepositoryUsers.Login(name, password);
if (User != null)
{
DialogResult = DialogResult.OK;
Close();
}
else
{
if (TryCount == 0)
{
Application.Exit();
}
MessageBox.Show("Неверные даныне для входа!");
TryCount--;
DialogResult = DialogResult.Cancel;
}
}
