private void btnRemoveData_Click(object sender, EventArgs e)
{
pp_dbEntities db = new pp_dbEntities();
if (lblData.Text == "Жанр")
{
int id = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[0].Value.ToString());
genres delete_item = db.genres.Find(id);
db.genres.Remove(delete_item);
db.SaveChanges();
}
else if (lblData.Text == "Страна")
{
int id = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[0].Value.ToString());
country delete_item = db.country.Find(id);
db.country.Remove(delete_item);
db.SaveChanges();
}
else
{
int id = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[0].Value.ToString());
agerating delete_item = db.agerating.Find(id);
db.agerating.Remove(delete_item);
db.SaveChanges();
}
zapis();
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (txtboxName.Text == "" || txtboxPrice.Text == "" || txtboxCount.Text == "")
MessageBox.Show("Название диска, его цена и количество обязательны к заполнению");
else
{
using (pp_dbEntities db = new pp_dbEntities())
{
movies mv = new movies
{
name = txtboxName.Text,
synopsis = rTxtBoxSynopsis.Text,
genres = cmbxGenre.Text,
director = txtboxDirector.Text,
year = txtboxYear.Text,
agerating = cmbxAgerating.Text,
country = cmbxCounrty.Text,
price = Convert.ToInt32(txtboxPrice.Text),
count = Convert.ToInt32(txtboxCount.Text),
};
try
{
if (!add_or_edit)
{
db.movies.Add(mv);
db.SaveChanges();
}
else
{
movies mv2 = db.movies.Where(c => c.name == name2).FirstOrDefault();
mv2.name = txtboxName.Text;
mv2.synopsis = rTxtBoxSynopsis.Text;
mv2.genres = cmbxGenre.Text;
mv2.director = txtboxDirector.Text;
mv2.year = txtboxYear.Text;
mv2.agerating = cmbxAgerating.Text;
mv2.country = cmbxCounrty.Text;
mv2.price = Convert.ToInt32(txtboxPrice.Text);
mv2.count = Convert.ToInt32(txtboxCount.Text);
db.Entry(mv2).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
catch (Exception ex)
{
return;
}
}
this.Close();
}
}
private void AddOrderForm_FormClosed(object sender, FormClosedEventArgs e)
{
if (SpisokDiskov != null && !orderadded)
{
pp_dbEntities db = new pp_dbEntities();
string s = SpisokDiskov;
int id1 = 0;
int id2 = 0;
String[] words = s.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < words.Length - 1; i += 2)
{
int[] array = words[i].Where(x => char.IsNumber(x)).Select(x => x - 48).ToArray();
int[] array2 = words[i + 1].Where(x => char.IsNumber(x)).Select(x => x - 48).ToArray();
for (int j = 0; j < array.Length; j++)
{
id1 = id1 * 10 + array[j];
}
for (int j = 0; j < array2.Length; j++)
{
id2 = id2 * 10 + array2[j];
}
movies mv = db.movies.Where(c => c.Id == id1).FirstOrDefault();
mv.count += id2;
db.Entry(mv).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
}
private void btnAddOrder_Click(object sender, EventArgs e) // Добавление заказа
{
if (cmbxClient.Text == "" || lblRent.Text == "" || !dobavlen)
{
lblbl.Text = '\n' + "Все поля обязательны к заполнению";
}
else
{
using (pp_dbEntities db = new pp_dbEntities())
{
orders ord = new orders
{
client = cmbxClient.Text,
status = "1",
date = DateTime.Now,
rent = DateTime.Now.AddDays(Convert.ToInt32(txtboxRent.Text)),
disklist = SpisokDiskov,
deposit = Convert.ToString(price),
};
try
{
db.orders.Add(ord);
db.SaveChanges();
}
catch (Exception ex)
{
return;
}
}
orderadded = true;
this.Close();
}
}
private void btnAddData_Click(object sender, EventArgs e)
{
pp_dbEntities db = new pp_dbEntities();
if (txtboxData.Text != "")
{
if (lblData.Text == "Жанр")
{
genres gr = new genres
{
name = txtboxData.Text
};
db.genres.Add(gr);
db.SaveChanges();
this.Close();
}
else if (lblData.Text == "Страна")
{
country cr = new country
{
name = txtboxData.Text
};
db.country.Add(cr);
db.SaveChanges();
this.Close();
}
else
{
agerating ar = new agerating
{
name = txtboxData.Text
};
db.agerating.Add(ar);
db.SaveChanges();
this.Close();
}
}
else
{
MessageBox.Show("Поле пустое");
}
}
public void proverka()
{
pp_dbEntities db = new pp_dbEntities(); // Добавление в список просроченных
var Orders = db.orders.Where(c => c.status == "1"); // Ищем только среди действующих заказов.
orders or = Orders.Where(c => c.rent < DateTime.Now).FirstOrDefault();
if (or != null) // Если есть просроченный заказ то меняем статус на 2
{
or.status = 2.ToString();
db.Entry(or).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
if (Orders.Where(c => c.rent < DateTime.Now).FirstOrDefault() != null) // Если есть еще просроченные заказы, то вызываем функцию снова.
{
proverka(); // Рекурсия о_О
}
DateTime D = DateTime.Now; // Добавление в список проваленных
D = D.AddDays(-14);
var Orders2 = db.orders.Where(c => c.status == "2"); // Ищем только среди просроченных заказов.
orders or2 = Orders2.Where(c => c.rent < D).FirstOrDefault();
if (or2 != null) // Если есть проваленный заказ то меняем статус на 3
{
or2.status = 3.ToString();
or2.closed_date = DateTime.Now;
clients cl = db.clients.Where(c => c.id == or2.clid).FirstOrDefault();
cl.blackliststatus = 1;
db.Entry(cl).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
db.Entry(or2).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
if (Orders2.Where(c => c.rent < D).FirstOrDefault() != null) // Если есть еще проваленные заказы, то вызываем функцию снова.
{
proverka(); // Рекурсия о_О
}
}
private void btnRemoveClient_Click(object sender, EventArgs e)
{
pp_dbEntities db = new pp_dbEntities();
try
{
int id = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[4].Value.ToString());
clients delete_item = db.clients.Find(id);
db.clients.Remove(delete_item);
db.SaveChanges();
zapis();
}
catch (Exception ex)
{
return;
}
}
private void btnclose_Click(object sender, EventArgs e)
{
int id2 = Convert.ToInt32(lblid.Text.ToString());
pp_dbEntities db = new pp_dbEntities();
orders or = db.orders.Where(c => c.id == id2).FirstOrDefault();
or.closed_date = DateTime.Now;
if (or.status == "1" || or.status == "2")
{
or.status = 0.ToString();
db.Entry(or).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
this.Close();
}
else
{
MessageBox.Show("Заказ уже закрыт");
}
}
public void btnAddDisk_Click(object sender, EventArgs e) // Добавление дисков в заказ
{
if (txtboxDiskCount.Text == "" || Convert.ToInt32(txtboxDiskCount.Text) == 0)
{
lbldsk.Visible = true;
}
else
{
lbldsklst.Text = "";
dobavlen = true;
lbldsk.Visible = false;
pp_dbEntities db = new pp_dbEntities();
movies mv = db.movies.Where(c => c.name == cmbxDisk.Text).FirstOrDefault();
int cnt = Convert.ToInt32((txtboxDiskCount.Text));
if (mv.count < cnt)
{
lbldskcount.Visible = false;
label8.Text = "Закажите не более " + lbldskcount.Text + " дисков";
}
else
{
mv.count = mv.count - cnt;
db.Entry(mv).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
int ID = Convert.ToInt32(cmbxDisk.SelectedValue.ToString());
movies dsk = db.movies.Where(c => c.Id == ID).FirstOrDefault();
lbldskcount.Text = dsk.count.ToString();
lbldskcount.Visible = true;
label8.Text = "Дисков в наличии:";
bool UsheEst = false;
for (int j = 0; j < i; j++)
{
if (DiskList[j] == dsk.Id)
{
DiskCount[j] = DiskCount[j] + cnt;
UsheEst = true;
price = price + dsk.price * cnt;
break;
}
}
if (!UsheEst)
{
DiskList[i] = dsk.Id;
DiskCount[i] = cnt;
price = price + dsk.price * cnt;
i++;
}
}
if (txtboxRent.Text != "")
{
lblPrice.Text = (price / 20 * Convert.ToDouble(txtboxRent.Text)).ToString();
}
else
{
lblPrice.Text = (price / 20).ToString();
}
lblDeposit.Text = price.ToString();
SpisokDiskov = "";
for (int j = 0; j < i; j++)
{
SpisokDiskov = SpisokDiskov + DiskList[j].ToString() + " " + DiskCount[j].ToString() + " ";
}
string dl = "";
string s = SpisokDiskov;
bool a = true;
int id3 = 0;
String[] words = s.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < words.Length; i++)
{
int[] array = words[i].Where(x => char.IsNumber(x)).Select(x => x - 48).ToArray();
for (int j = 0; j < array.Length; j++)
{
id3 = id3 * 10 + array[j];
}
if (a)
{
dl = "";
movies mv3 = db.movies.Where(c => c.Id == id3).FirstOrDefault();
dl = dl + mv3.name.ToString() + " ";
id3 = 0;
a = false;
}
else
{
dl = dl + id3.ToString() + " шт ";
id3 = 0;
a = true;
lbldsklst.Text = lbldsklst.Text + '\n' + dl;
}
}
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (txtboxAddress.Text == "" || txtBoxname.Text == "" || txtboxphone.Text == "")
{
MessageBox.Show("Все поля обязательны к заполнению");
}
else
{
using (pp_dbEntities db = new pp_dbEntities())
{
SByte chk = 0;
if (chkbxBL.Checked)
{
chk = 1;
}
clients cl = new clients
{
fullname = txtBoxname.Text,
address = txtboxAddress.Text,
contact = txtboxphone.Text,
blackliststatus = chk,
};
try
{
if (!add_or_edit)
{
db.clients.Add(cl);
db.SaveChanges();
}
else
{
clients cl2 = db.clients.Where(c => c.fullname == name2).FirstOrDefault();
cl2.fullname = txtBoxname.Text;
cl2.address = txtboxAddress.Text;
cl2.contact = txtboxphone.Text;
if (chkbxBL.Checked)
{
cl2.blackliststatus = 1;
}
else
{
cl2.blackliststatus = 0;
}
db.Entry(cl2).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
catch (Exception ex)
{
return;
}
}
if (!chkModal)
{
this.Close();
}
else
{
txtboxAddress.Text = null;
txtBoxname.Text = null;
txtboxphone.Text = null;
chkbxBL.Checked = false;
MessageBox.Show("Клиент добавлен");
}
}
}