public Orders()
{
InitializeComponent();
this.context = new BarbershopDBContext();
var orders = (from order in context.Orders
where order.IsCanceled == false
join client in context.Clients on order.ClientId equals client.Id
join orderDetail in context.OrderDetails on order.Id equals orderDetail.OrderId
join master in context.Masters on orderDetail.MasterId equals master.Id
select new
{
orderId = order.Id,
clientName = client.Name,
clientPhone = client.Phone,
masterName = master.Name,
orderDate = order.Date
}).Distinct().ToList();
this.dataGridView1.Columns.Add("0", "ID Записи");
this.dataGridView1.Columns.Add("1", "Клиент");
this.dataGridView1.Columns.Add("2", "Телефон клиента");
this.dataGridView1.Columns.Add("3", "Мастер");
this.dataGridView1.Columns.Add("4", "Дата записи");
for (int i = 0; i < orders.Count; i++)
{
this.dataGridView1.Rows.Add();
this.dataGridView1.Rows[i].Cells[0].Value = orders[i].orderId;
this.dataGridView1.Rows[i].Cells[1].Value = orders[i].clientName;
this.dataGridView1.Rows[i].Cells[2].Value = orders[i].clientPhone;
this.dataGridView1.Rows[i].Cells[3].Value = orders[i].masterName;
this.dataGridView1.Rows[i].Cells[4].Value = orders[i].orderDate;
}
}
private void LoginButton_Click(object sender, EventArgs e)
{
if (this.loginBox.Text == "" || this.passwordBox.Text == "")
{
MessageBox.Show("Введите все данные");
}
BarbershopDBContext context = new BarbershopDBContext();
var administartor = context.Administrators.FirstOrDefault(admin => admin.Login == this.loginBox.Text);
if (administartor == null)
{
MessageBox.Show("Неверные данные");
}
else
{
if (GetPasswordHash(this.passwordBox.Text, administartor.Salt) == administartor.Password)
{
this.Hide();
Form form = Application.OpenForms.Cast <Form>().Where <Form>((Func <Form, bool>)(x => x.Name == "Menu")).FirstOrDefault <Form>();
(!(form is Menu) ? (Control) new Menu(administartor) : (Control)form).Show();
}
else
{
MessageBox.Show("Неверные данные");
}
}
}
public ChangeShedule()
{
InitializeComponent();
this.context = new BarbershopDBContext();
this.dataGridView1.DataSource = context.Masters.ToList();
this.dataGridView1.Columns.GetLastColumn(DataGridViewElementStates.Visible, DataGridViewElementStates.None).Visible = false;
for (int i = 0; i < 3; i++)
{
this.dataGridView1.Columns[i].ReadOnly = true;
}
}
public Records(DateTime start, DateTime end)
{
InitializeComponent();
string[] records = { "Общий", "Мастера", "Услуги" };
this.comboBox1.Items.AddRange(records);
this.comboBox1.SelectedItem = this.comboBox1.Items[0];
this.comboBox1.SelectedIndexChanged += comboBox1_SelectedIndexChanged;
this.start = start;
this.end = end;
context = new BarbershopDBContext();
LoadMainRecord();
}
public CreateOrder()
{
InitializeComponent();
this.context = new BarbershopDBContext();
var clients = context.Clients.ToList();
this.comboBox1.DataSource = clients;
this.comboBox1.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
this.comboBox1.AutoCompleteSource = AutoCompleteSource.ListItems;
dateTimePicker1.Format = DateTimePickerFormat.Custom;
dateTimePicker1.CustomFormat = "dd/MM/yyyy HH:mm";
dateTimePicker1.MinDate = DateTime.Today;
var masters = context.Masters.ToList();
this.listBox1.DataSource = masters;
var services = context.Services.ToList();
this.checkedListBox1.DataSource = services;
}
public CreateRecordData()
{
InitializeComponent();
var context = new BarbershopDBContext();
}