public void UpdateTable()
{
switch (table)
{
case Tables.Client:
dataAll.DataSource = My.Clients.ToList <Client>();
LogicClient logicCl = new LogicClient();
logicCl.getDataClient(dataAll);
break;
case Tables.Disk:
dataAll.DataSource = My.Disks.ToList <Disk>();
break;
case Tables.Movie:
dataAll.DataSource = My.Movies.ToList <Movie>();
break;
case Tables.Order:
dataAll.DataSource = My.Orders.ToList <Order>();
break;
case Tables.Employee:
dataAll.DataSource = My.Employees.ToList <Employee>();
LogicEmployees logicEmp = new LogicEmployees();
logicEmp.getDataEmployee(dataAll);
break;
default:
DialogResult result = MessageBox.Show(
"В процессе разработки!",
"Сообщение",
MessageBoxButtons.OK,
MessageBoxIcon.Information,
MessageBoxDefaultButton.Button1,
MessageBoxOptions.ServiceNotification);
break;
}
}
public object UpdateEmployees([FromBody] employees value)
{
ModelResponse modeloRpta = new ModelResponse();
LogicEmployees asas = new LogicEmployees();
try
{
// objResult = asas.SaveEmployees(value);
modeloRpta.bEstado = true;
modeloRpta.obj = asas.UpdateEmployees(value);
}
catch (Exception ex)
{
modeloRpta.bEstado = false;
modeloRpta.sRpta = ex.ToString();
}
return(modeloRpta);//
}
public object GetAllEmployees()
{
ModelResponse modeloRpta = new ModelResponse();
//object objResult = null;
LogicEmployees asas = new LogicEmployees();
try {
//objResult = asas.GetAllEmployees();
modeloRpta.bEstado = true;
modeloRpta.obj = asas.GetAllEmployees();
}
catch (Exception ex)
{
modeloRpta.bEstado = false;
modeloRpta.sRpta = ex.ToString();
}
return(modeloRpta);// return JsonConvert.SerializeObject(objResult);
}
private void button2_Click(object sender, EventArgs e)
{
if (dataAll.SelectedRows.Count == 0)
{
return;
}
Form1 from1 = new Form1();
DialogResult result = MessageBox.Show(
"Вы уверены в этом?",
"Сообщение",
MessageBoxButtons.YesNo,
MessageBoxIcon.Information,
MessageBoxDefaultButton.Button1,
MessageBoxOptions.ServiceNotification
);
from1.MaximizeBox = true;
switch (table)
{
case Tables.Movie:
if (result == DialogResult.Yes)
{
foreach (DataGridViewRow row in dataAll.SelectedRows)
{
Movie movie = row.DataBoundItem as Movie;
if (movie == null)
{
continue;
}
Movie dbMovie = My.Movies.Find(movie.Id);
My.Movies.Remove(dbMovie);
}
My.SaveChanges();
UpdateTable();
}
break;
case Tables.Client:
if (result == DialogResult.Yes)
{
LogicClient LogCl = new LogicClient();
int idClient = Convert.ToInt32(dataAll[0, dataAll.CurrentCell.RowIndex].Value);
int idPassCL = Convert.ToInt32(dataAll[9, dataAll.CurrentCell.RowIndex].Value);
LogCl.RemoveClient(idClient, idPassCL);
UpdateTable();
//ObjectContext objectContext = (new Contex() as IObjectContextAdapter).ObjectContext;
//SqlConnection connection = new SqlConnection(@"Data source=.\SQLEXPRESS;InitialCatalog=Kinosoft4");
//ObjectQuery<DbDataRecord> disk = objectContext.CreateQuery<DbDataRecord>("SELECT * FROM Client, Passport");
//dataAll.DataSource = disk.ToList();
}
break;
case Tables.Disk:
if (result == DialogResult.Yes)
{
foreach (DataGridViewRow row in dataAll.SelectedRows)
{
Disk disk = row.DataBoundItem as Disk;
if (disk == null)
{
continue;
}
Disk dbDisk = My.Disks.Find(disk.Id);
My.Disks.Remove(dbDisk);
}
My.SaveChanges();
UpdateTable();
}
break;
case Tables.Employee:
LogicEmployees logEmp = new LogicEmployees();
int idEmployee = Convert.ToInt16(dataAll[0, dataAll.CurrentCell.RowIndex].Value);
int idPassEmp = Convert.ToInt16(dataAll[8, dataAll.CurrentCell.RowIndex].Value);
logEmp.RemoveEmployee(idEmployee, idPassEmp);
UpdateTable();
//if (result == DialogResult.Yes)
//{
// foreach (DataGridViewRow row in dataAll.SelectedRows)
// {
// Employee employee = new Employee();
// if (employee == null)
// continue;
// Employee dbEmployee = My.Employees.Find(employee.Id);
// My.Employees.Remove(dbEmployee);
// }
// My.SaveChanges();
// UpdateTable();
//}
break;
case Tables.Order:
if (result == DialogResult.Yes)
{
foreach (DataGridViewRow row in dataAll.SelectedRows)
{
Order order = row.DataBoundItem as Order;
if (order == null)
{
continue;
}
Order dborder = My.Orders.Find(order.Id);
My.Orders.Remove(dborder);
}
My.SaveChanges();
UpdateTable();
}
break;
default:
break;
}
}