public Procedure(procedure_schedule procedure_schedule)
{
InitializeComponent();
button1.Text = "Изменить";
this.procedure_schedule = procedure_schedule;
dataView.ShowClientListForEdit(comboBox1, procedure_schedule);
dataView.ShowServiceListForEdit(comboBox2, procedure_schedule);
dateTimePicker1.MinDate = DateTime.Now.AddDays(1);
dateTimePicker1.MaxDate = DateTime.Now.AddDays(5);
i++;
}
public void removeProcedure(procedure_schedule procedure_schedule)
{
try
{
procedure_schedule procedure_schedule1;
using (var cn = new Model1())
{
procedure_schedule1 = cn.procedure_schedule.Where(w => w.id_procedure == procedure_schedule.id_procedure).FirstOrDefault();
cn.procedure_schedule.Remove(procedure_schedule1);
cn.SaveChanges();
}
}
catch
{
MessageBox.Show("Невозможно произвести удаление");
}
}
private void button2_Click(object sender, EventArgs e)// Изменить
{
if (comboBox1.SelectedIndex == 0)
{
List <client> query = (from client in db.client
select client).ToList();
client item = query.First(w => w.id_client.ToString() ==
dataGridView1.SelectedCells[0].OwningRow.Cells[0].Value.ToString());
EditUser editUser = new EditUser(item);
editUser.Owner = this;
editUser.Show();
}
if ((comboBox1.SelectedIndex == 1) || (comboBox1.SelectedIndex == 2))
{
List <employee> query = (from employee in db.employee
select employee).ToList();
employee item = query.First(w => w.id_employee.ToString() ==
dataGridView1.SelectedCells[0].OwningRow.Cells[0].Value.ToString());
EditUser editUser = new EditUser(item);
editUser.Owner = this;
editUser.Show();
}
if (comboBox1.SelectedIndex == 3)
{
List <service> query = (from service in db.service
select service).ToList();
service item = query.First(w => w.name.ToString() ==
dataGridView1.SelectedCells[0].OwningRow.Cells[0].Value.ToString());
EditService editUser = new EditService(item);
editUser.Owner = this;
editUser.Show();
}
if (comboBox1.SelectedIndex == 4)
{
List <procedure_schedule> query = (from procedure_schedule in db.procedure_schedule
select procedure_schedule).ToList();
procedure_schedule item = query.First(w => w.date.ToString() ==
dataGridView1.SelectedCells[0].OwningRow.Cells[0].Value.ToString());
Procedure procedure = new Procedure(item);
procedure.Show();
}
}
public void ShowServiceListForEdit(ComboBox comboBox, procedure_schedule procedure_schedule1)
{
List <string> infoClient = new List <string>();
List <service> services = (from service in db.service select service).ToList();
string s = "не удалось";
var query = (from service in services
select service.name).Distinct();
foreach (string r in query)
{
infoClient.Add(r);
}
foreach (string w in infoClient)
{
comboBox.Items.Add(w);
}
service service1 = db.service.SingleOrDefault(w => w.id_service == procedure_schedule1.id_service);
comboBox.SelectedItem = service1.name;
}
public void ShowClientListForEdit(ComboBox comboBox, procedure_schedule procedure_schedule1)
{
List <string> infoClient = new List <string>();
List <service> services = (from service in db.service select service).ToList();
string s = "не удалось";
var query = (from service in services
join procedure_schedule in db.procedure_schedule on service.id_service equals procedure_schedule.id_service
join client in db.client on procedure_schedule.id_client equals client.id_client
where procedure_schedule.id_procedure == procedure_schedule1.id_procedure
select s = (client.surname + " " + client.name + " " + client.lastlename)).Distinct();
foreach (string r in query)
{
infoClient.Add(r);
}
foreach (string w in infoClient)
{
comboBox.Items.Add(w);
}
}
private void button3_Click(object sender, EventArgs e)// remove
{
RemoveInfo removeInfo = new RemoveInfo();
switch (comboBox1.SelectedIndex)
{
case 0:
{
List <client> query = (from client in db.client
select client).ToList();
client item = query.First(w => w.id_client.ToString() ==
dataGridView1.SelectedCells[0].OwningRow.Cells[0].Value.ToString());
removeInfo.removeClient(item);
dw.ShowInfoToAdmin(dataGridView1, comboBox1);
}
break;
case 1:
{
List <employee> query = (from employee in db.employee
select employee).ToList();
employee item = query.First(w => w.id_employee.ToString() ==
dataGridView1.SelectedCells[0].OwningRow.Cells[0].Value.ToString());
if (admin == item)
{
MessageBox.Show("Нельзя удалить самого себя");
}
else
{
removeInfo.removeemployee(item.id_employee);
dw.ShowInfoToAdmin(dataGridView1, comboBox1);
}
}
break;
case 2:
{
List <employee> query = (from employee in db.employee
select employee).ToList();
employee item = query.First(w => w.id_employee.ToString() ==
dataGridView1.SelectedCells[0].OwningRow.Cells[0].Value.ToString());
if (admin == item)
{
MessageBox.Show("Нельзя удалить самого себя");
}
else
{
removeInfo.removeemployee(item.id_employee);
dw.ShowInfoToAdmin(dataGridView1, comboBox1);
}
}
break;
case 3:
{
List <service> query = (from service in db.service
select service).ToList();
service item = query.First(w => w.name.ToString() ==
dataGridView1.SelectedCells[0].OwningRow.Cells[0].Value.ToString());
removeInfo.removeService(item);
dw.ShowInfoToAdmin(dataGridView1, comboBox1);
}
break;
case 4:
{
List <procedure_schedule> query = (from procedure_schedule in db.procedure_schedule
select procedure_schedule).ToList();
procedure_schedule item = query.First(w => w.date.ToString() ==
dataGridView1.SelectedCells[0].OwningRow.Cells[0].Value.ToString());
removeInfo.removeProcedure(item);
dw.ShowInfoToAdmin(dataGridView1, comboBox1);
}
break;
}
}
public EditInfo(procedure_schedule procedure_Schedule, Procedure procedure)
{
this.procedure_Schedule = procedure_Schedule;
this.procedure = procedure;
}
