private void addButton_Click(object sender, EventArgs e)
{
string[] text = addText.Text.Split(' ');
string[] FIO = new string[3];
for (int i = 0; i < text.Length; ++i)
{
FIO[i] = text[i];
}
switch (table)
{
case Tables.Genre:
Genre genre = new Genre()
{
Name = addText.Text
};
db.Genres.Add(genre);
break;
case Tables.Country:
Country country = new Country()
{
CountryName = addText.Text
};
db.Countrys.Add(country);
break;
case Tables.Actor:
Actor actor = new Actor()
{
FirstName = FIO[1],
LastName = FIO[2],
SecondName = FIO[3]
};
db.Actors.Add(actor);
break;
case Tables.Producer:
Producer producer = new Producer()
{
FirstName = FIO[1],
LastName = FIO[2],
SecondName = FIO[3]
};
db.Producers.Add(producer);
break;
default:
break;
}
db.SaveChanges();
}
public void AddDisk(string name, string format, int copy, int cost)
{
using (Contex db = new Contex())
{
Disk disk = new Disk
{
Name = name,
cost = cost,
format = format,
copy = copy,
};
//diskGl = disk;
db.Disks.Add(disk);
db.SaveChanges();
/*using (Contex My = new Contex())
* {*/
for (int i = 0; i < ArrayMoviesDisk.movies.Count; i++)
{
//var movie = ArrayMoviesDisk.movies[i];
int movieId = Convert.ToInt32(ArrayMoviesDisk.arrayList[i]);
//int movieId = movie.Id;
//Movie movie2 = My.Movies.Include(s => s.).First
//MessageBox.Show(movie2.Name);
Movie movie2 = db.Movies.First(s => s.Id == movieId);
//Movie movie = My.Movies.Where(k => k.Id == movieId).FirstOrDefault();
//Movie movie1 = movie;
int diskId = disk.Id;
MovieDisk movieDisk = new MovieDisk
{
MovieId = movieId,
DiskId = diskId,
};
db.MovieDisks.Add(movieDisk);
}
db.SaveChanges();
//}
}
}
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;
}
}