private void add_Click(object sender, EventArgs e)
{
AddEmployeeForm addEmployeeForm = new AddEmployeeForm();
int maxId;
if (addEmployeeForm.ShowDialog() == DialogResult.OK)
{
try
{
Employee employee = new Employee();
IEnumerable <int> employeeIdQuery = from employeeItem in context.Employees select employeeItem.EmployeeId;
maxId = employeeIdQuery.Max();
employee.EmployeeId = maxId + 1;
employee.EmployeeName = addEmployeeForm.EmployeeName;
employee.Birthdate = Convert.ToDateTime(addEmployeeForm.Birthdate);
employee.Position = addEmployeeForm.Position;
employee.Address = addEmployeeForm.Address;
employee.Telephone = addEmployeeForm.Telephone;
employee.Salary = Math.Round(Convert.ToDouble(addEmployeeForm.Salary), 2);
context.Employees.Add(employee);
context.SaveChanges();
var employeeQuery = from employeeItem in context.Employees orderby employeeItem.EmployeeName select employeeItem;
var employeePositionQuery = from employeeItem in context.Employees select employeeItem.Position;
employeesView.DataSource = employeeQuery.ToList();
if (employeesView.Rows.Count > 0)
{
employeesView.RowHeadersVisible = employeesView.ColumnHeadersVisible = edit.Enabled = delete.Enabled = true;
}
for (int i = 0; i < employeesView.Rows.Count; i++)
{
if (Convert.ToInt32(employeesView.Rows[i].Cells[0].Value) == maxId + 1)
{
employeesView.Rows[i].Cells[1].Selected = true;
}
}
positionChoice.Items.Clear();
foreach (var p in employeePositionQuery.Distinct())
{
positionChoice.Items.Add(p);
}
if (positionChoice.Items.Count > 0)
{
positionChoice.SelectedIndex = 0;
}
}
catch (Exception)
{
MessageBox.Show("Ошибка добавления данных!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void add_Click(object sender, EventArgs e)
{
AddHiringOutForm addHiringOutForm = new AddHiringOutForm(context);
int maxId;
bool occupy = true;
if (addHiringOutForm.ShowDialog() == DialogResult.OK)
{
try
{
if (addHiringOutForm.HasClient)
{
occupy = MessageBox.Show("Данный номер уже забронирован на этот период! Желаете всё равно заселить клиента?", "Заселение клиентов", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes;
}
if (occupy)
{
RoomsHiringOut roomsHiringOut = new RoomsHiringOut();
IEnumerable <int> hiringOutIdQuery = from hiringOutItem in context.RoomsHiringOut select hiringOutItem.RoomsHiringOutId;
maxId = hiringOutIdQuery.Max();
roomsHiringOut.RoomsHiringOutId = maxId + 1;
roomsHiringOut.RoomId = addHiringOutForm.Room;
roomsHiringOut.ClientId = addHiringOutForm.Client;
roomsHiringOut.BeginningDate = Convert.ToDateTime(addHiringOutForm.BeginningDate);
roomsHiringOut.DaysCount = Convert.ToInt32(addHiringOutForm.DaysCount);
context.RoomsHiringOut.Add(roomsHiringOut);
context.SaveChanges();
var hiringOutQuery = from hiringOutItem in context.RoomsHiringOut orderby hiringOutItem.BeginningDate select new { HiringId = hiringOutItem.RoomsHiringOutId, RoomId = hiringOutItem.RoomId, RoomNumber = hiringOutItem.Room.RoomNumber, ClientId = hiringOutItem.ClientId, ClientName = hiringOutItem.Client.ClientName, BeginningDate = hiringOutItem.BeginningDate, DaysCount = hiringOutItem.DaysCount, Sum = hiringOutItem.Room.Price * hiringOutItem.DaysCount };
roomsHiringOutView.DataSource = hiringOutQuery.ToList();
if (roomsHiringOutView.Rows.Count > 0)
{
roomsHiringOutView.RowHeadersVisible = roomsHiringOutView.ColumnHeadersVisible = edit.Enabled = delete.Enabled = true;
}
for (int i = 0; i < roomsHiringOutView.Rows.Count; i++)
{
if (Convert.ToInt32(roomsHiringOutView.Rows[i].Cells[0].Value) == maxId + 1)
{
roomsHiringOutView.Rows[i].Cells[2].Selected = true;
}
}
}
}
catch (Exception)
{
MessageBox.Show("Ошибка добавления данных!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void add_Click(object sender, EventArgs e)
{
AddClientForm addClientForm = new AddClientForm();
int maxId;
if (addClientForm.ShowDialog() == DialogResult.OK)
{
try
{
Client client = new Client();
IEnumerable <int> clientIdQuery = from clientItem in context.Clients select clientItem.ClientId;
maxId = clientIdQuery.Max();
client.ClientId = maxId + 1;
client.ClientName = addClientForm.ClientName;
client.Sex = addClientForm.Sex;
client.Birthdate = Convert.ToDateTime(addClientForm.Birthdate);
client.PassportData = addClientForm.PassportData;
client.Address = addClientForm.Address;
client.Telephone = addClientForm.Telephone;
client.Nationality = addClientForm.Nationality;
context.Clients.Add(client);
context.SaveChanges();
var clientQuery = from clientItem in context.Clients orderby clientItem.ClientName select clientItem;
clientsView.DataSource = clientQuery.ToList();
if (clientsView.Rows.Count > 0)
{
clientsView.RowHeadersVisible = clientsView.ColumnHeadersVisible = edit.Enabled = delete.Enabled = true;
}
for (int i = 0; i < clientsView.Rows.Count; i++)
{
if (Convert.ToInt32(clientsView.Rows[i].Cells[0].Value) == maxId + 1)
{
clientsView.Rows[i].Cells[1].Selected = true;
}
}
}
catch (Exception)
{
MessageBox.Show("Ошибка добавления данных!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void add_Click(object sender, EventArgs e)
{
AddRoomForm addRoomForm = new AddRoomForm(context);
int maxId;
if (addRoomForm.ShowDialog() == DialogResult.OK)
{
try
{
Room room = new Room();
IEnumerable <int> roomIdQuery = from roomItem in context.Rooms select roomItem.RoomId;
maxId = roomIdQuery.Max();
room.RoomId = maxId + 1;
room.RoomNumber = Convert.ToInt32(addRoomForm.RoomNumber);
room.Floor = Convert.ToInt32(addRoomForm.Floor);
room.Category = addRoomForm.Category;
room.PlacesCount = Convert.ToInt32(addRoomForm.PlacesCount);
room.Price = Math.Round(Convert.ToDouble(addRoomForm.Price), 2);
room.EmployeeId = addRoomForm.Employee;
context.Rooms.Add(room);
context.SaveChanges();
var roomQuery = from roomItem in context.Rooms orderby roomItem.RoomNumber select new { RoomId = roomItem.RoomId, RoomNumber = roomItem.RoomNumber, Floor = roomItem.Floor, Category = roomItem.Category, PlacesCount = roomItem.PlacesCount, Price = roomItem.Price, EmployeeId = roomItem.EmployeeId, EmployeeName = roomItem.Employee.EmployeeName };
roomsView.DataSource = roomQuery.ToList();
if (roomsView.Rows.Count > 0)
{
roomsView.RowHeadersVisible = roomsView.ColumnHeadersVisible = edit.Enabled = delete.Enabled = true;
}
for (int i = 0; i < roomsView.Rows.Count; i++)
{
if (Convert.ToInt32(roomsView.Rows[i].Cells[0].Value) == maxId + 1)
{
roomsView.Rows[i].Cells[1].Selected = true;
}
}
}
catch (Exception)
{
MessageBox.Show("Ошибка добавления данных!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void add_Click(object sender, EventArgs e)
{
AddExpenseForm addExpenseForm = new AddExpenseForm();
int maxId;
if (addExpenseForm.ShowDialog() == DialogResult.OK)
{
try
{
Expense expense = new Expense();
IEnumerable <int> expenseIdQuery = from expenseItem in context.Expenses select expenseItem.ExpenseId;
maxId = expenseIdQuery.Max();
expense.ExpenseId = maxId + 1;
expense.ExpenseName = addExpenseForm.ExpenseName;
expense.ExpenseDate = Convert.ToDateTime(addExpenseForm.ExpenseDate);
expense.ExpenseSum = Convert.ToDouble(addExpenseForm.ExpenseSum);
context.Expenses.Add(expense);
context.SaveChanges();
var expenseQuery = from expenseItem in context.Expenses orderby expenseItem.ExpenseDate select expenseItem;
expensesView.DataSource = expenseQuery.ToList();
if (expensesView.Rows.Count > 0)
{
expensesView.RowHeadersVisible = expensesView.ColumnHeadersVisible = edit.Enabled = delete.Enabled = true;
}
for (int i = 0; i < expensesView.Rows.Count; i++)
{
if (Convert.ToInt32(expensesView.Rows[i].Cells[0].Value) == maxId + 1)
{
expensesView.Rows[i].Cells[1].Selected = true;
}
}
}
catch (Exception)
{
MessageBox.Show("Ошибка добавления данных!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void add_Click(object sender, EventArgs e)
{
AddUserForm addUserForm = new AddUserForm();
int maxId;
if (addUserForm.ShowDialog() == DialogResult.OK)
{
try
{
User user = new User();
IEnumerable <int> userIdQuery = from userItem in context.Users select userItem.UserId;
maxId = userIdQuery.Max();
user.UserId = maxId + 1;
user.UserName = addUserForm.UserName;
user.UserPassword = addUserForm.UserPassword;
user.AdminRights = addUserForm.AdminRights;
context.Users.Add(user);
context.SaveChanges();
var userQuery = from userItem in context.Users orderby userItem.UserName select userItem;
usersView.DataSource = userQuery.ToList();
if (usersView.Rows.Count > 0)
{
usersView.RowHeadersVisible = usersView.ColumnHeadersVisible = edit.Enabled = delete.Enabled = true;
}
for (int i = 0; i < usersView.Rows.Count; i++)
{
if (Convert.ToInt32(usersView.Rows[i].Cells[0].Value) == maxId + 1)
{
usersView.Rows[i].Cells[1].Selected = true;
}
}
}
catch (Exception)
{
MessageBox.Show("Ошибка добавления данных!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
