private void Delete()
{
using (KPgamenotebookContext db = new KPgamenotebookContext())
{
var obj = db.Reviews;
foreach (Reviews u in obj)
{
if (u.ID_model == Convert.ToInt32(textBox2.Text))
{
db.Reviews.Remove(u);
}
}
db.SaveChanges();
var obj2 = db.Model;
foreach (Model u in obj2)
{
if (u.ID_model == Convert.ToInt32(textBox2.Text))
{
db.Model.Remove(u);
}
}
db.SaveChanges();
ListView.SelectedIndexCollection collection = listView1.SelectedIndices;
if (collection.Count != 0)
{
listView1.Items.RemoveAt(collection[0]);
}
WriteALL();
}
}
private void button7_Click(object sender, EventArgs e)
{
using (KPgamenotebookContext db = new KPgamenotebookContext())
{
string c = Convert.ToString(comboBox2.SelectedItem);
string d = Convert.ToString(comboBox3.SelectedItem);
string p = Convert.ToString(comboBox4.SelectedItem);
Model model = new Model();
int id;
using (StreamReader sr = new StreamReader(@"C:\Users\ReaLBERG\Desktop\3 курс\АИС\createnote.txt"))
{
id = Convert.ToInt32(sr.ReadToEnd());
}
id++;
using (StreamWriter sw = new StreamWriter(@"C:\Users\ReaLBERG\Desktop\3 курс\АИС\createnote.txt", false, System.Text.Encoding.Default))
{
sw.WriteLine(id);
}
model.ID_model = id;
model.Href = "https://www.mvideo.ru/product-list-page-cls?q=%D0%B8%D0%B3%D1%80%D0%BE%D0%B2%D1%8B%D0%B5+%D0%BD%D0%BE%D1%83%D1%82%D0%B1%D1%83%D0%BA%D0%B8®ion_id=2&limit=12";
model.Name = textBox21.Text;
model.Price = textBox20.Text;
model.Rating = textBox19.Text;
model.SSD = textBox18.Text;
model.RAM = Convert.ToInt32(textBox17.Text);
model.ID_CPU = db.CPU.FirstOrDefault(r => r.Name == c).ID_CPU;
model.ID_GC = db.Graphiccard.FirstOrDefault(r => r.Name == d).ID_GC;
model.ID_firm = db.Firm.FirstOrDefault(r => r.Name_firm == p).ID_firm;
db.Model.Add(model);
db.SaveChanges();
WriteALL();
}
}
private void button13_Click(object sender, EventArgs e)
{
using (KPgamenotebookContext db = new KPgamenotebookContext())
{
string a = Convert.ToString(comboBox9.SelectedItem);
int id = db.CPU.FirstOrDefault(r => r.Name == a).ID_CPU;
foreach (Model u in db.Model)
{
if (u.ID_CPU == id)
{
u.ID_CPU = null;
}
}
db.SaveChanges();
foreach (CPU u in db.CPU)
{
if (u.ID_CPU == id)
{
db.CPU.Remove(u);
}
}
db.SaveChanges();
CPU header = new CPU();
header.ID_CPU = id;
header.Name = textBox9.Text;
string name = textBox9.Text;
header.Frequency = textBox11.Text;
db.CPU.Add(header);
db.SaveChanges();
int id2 = db.CPU.FirstOrDefault(r => r.Name == name).ID_CPU;
foreach (Model u in db.Model)
{
if (u.ID_CPU == null)
{
u.ID_CPU = id2;
}
}
db.SaveChanges();
WriteALL();
}
}
private void button12_Click(object sender, EventArgs e)
{
using (KPgamenotebookContext db = new KPgamenotebookContext())
{
string a = Convert.ToString(comboBox8.SelectedItem);
int id = db.Graphiccard.FirstOrDefault(r => r.Name == a).ID_GC;
foreach (Model u in db.Model)
{
if (u.ID_GC == id)
{
u.ID_GC = null;
}
}
db.SaveChanges();
foreach (Graphiccard u in db.Graphiccard)
{
if (u.ID_GC == id)
{
db.Graphiccard.Remove(u);
}
}
db.SaveChanges();
Graphiccard header = new Graphiccard();
header.ID_GC = id;
header.Name = textBox8.Text;
string name = textBox8.Text;
db.Graphiccard.Add(header);
db.SaveChanges();
int id2 = db.Graphiccard.FirstOrDefault(r => r.Name == name).ID_GC;
foreach (Model u in db.Model)
{
if (u.ID_GC == null)
{
u.ID_GC = id2;
}
}
db.SaveChanges();
WriteALL();
}
}
private void button11_Click(object sender, EventArgs e)
{
using (KPgamenotebookContext db = new KPgamenotebookContext())
{
string a = Convert.ToString(comboBox5.SelectedItem);
int id = db.Firm.FirstOrDefault(r => r.Name_firm == a).ID_firm;
foreach (Model u in db.Model)
{
if (u.ID_firm == id)
{
u.ID_firm = null;
}
}
db.SaveChanges();
foreach (Firm u in db.Firm)
{
if (u.ID_firm == id)
{
db.Firm.Remove(u);
}
}
db.SaveChanges();
Firm header = new Firm();
header.ID_firm = id;
header.Name_firm = textBox10.Text;
string name = textBox10.Text;
db.Firm.Add(header);
db.SaveChanges();
int id2 = db.Firm.FirstOrDefault(r => r.Name_firm == name).ID_firm;
foreach (Model u in db.Model)
{
if (u.ID_firm == null)
{
u.ID_firm = id2;
}
}
db.SaveChanges();
WriteALL();
}
}
public async void Parse(string url1, string rateing)
{
//Объект класса
using (KPgamenotebookContext db = new KPgamenotebookContext())
{
Model gameNotebook = new Model();
Firm firm = new Firm();
Graphiccard graphiccard = new Graphiccard();
CPU cPU = new CPU();
//Подключение к HTML-страничке
IConfiguration config = Configuration.Default.WithDefaultLoader();
IBrowsingContext context = BrowsingContext.New(config);
IDocument doc1 = await context.OpenAsync(url1);
int watch = Convert.ToInt32(url1.Substring(url1.Length - 8));
var obj = db.Model;
bool twice = false;
foreach (Model u in obj)
{
if (watch == u.ID_model)
{
twice = true;
}
}
if (twice == false)
{
//Характеристики
IEnumerable <IElement> shortDescriptionParams = doc1.All.Where(block =>
block.LocalName == "span" &&
block.ClassList.Contains("c-specification__value") &&
block.ParentElement.ParentElement.ParentElement.ParentElement.LocalName == "table" &&
block.ParentElement.ParentElement.ParentElement.ParentElement.ClassList.Contains("c-specification__table"));
//
//Вспомогательная переменная
string text;
//Имя
IElement name = doc1.QuerySelector("h1.fl-h1");
text = name.TextContent;
//IElement rating = rate.ToList()[0];
string textttt = text;
// Добавление фирмы
string[] words = text.Split(new char[] { ' ' });
var obj2 = db.Firm;
bool third = false;
foreach (Firm t in obj2)
{
if (words[2] == t.Name_firm)
{
gameNotebook.ID_firm = t.ID_firm;
third = true;
break;
}
}
if (third == false)
{
firm.Name_firm = words[2];
db.Firm.Add(firm);
db.SaveChanges();
gameNotebook.ID_firm = firm.ID_firm;
}
////CPU
IElement cpu = shortDescriptionParams.ToList()[1];
text = cpu.TextContent;
text = DeleteNT(text);
string[] words1 = text.Split(new char[] { ' ' });
string namecpu = words1[0] + " " + words1[1] + " " + words1[2] + " " + words1[3];
string freauq = words1[4] + " " + words1[5];
var obj4 = db.CPU;
bool fifth = false;
foreach (CPU t in obj4)
{
if (namecpu == t.Name)
{
gameNotebook.ID_CPU = t.ID_CPU;
fifth = true;
}
}
if (fifth == false)
{
//cPU.ID_CPU = count;
//count++;
cPU.Name = namecpu;
cPU.Frequency = freauq;
db.CPU.Add(cPU);
db.SaveChanges();
gameNotebook.ID_CPU = cPU.ID_CPU;
}
var obj3 = db.Graphiccard;
bool fourth = false;
IElement graphiccard1 = shortDescriptionParams.ToList()[3];
text = graphiccard1.TextContent;
text = DeleteNT(text);
foreach (Graphiccard t in obj3)
{
if (text == t.Name)
{
gameNotebook.ID_GC = t.ID_GC;
fourth = true;
}
}
if (fourth == false)
{
graphiccard.Name = text;
db.Graphiccard.Add(graphiccard);
db.SaveChanges();
gameNotebook.ID_GC = graphiccard.ID_GC;
}
gameNotebook.Href = url1;
gameNotebook.ID_model = watch;
string text1 = textttt.Remove(0, 23);
gameNotebook.Name = DeleteNT(text1);
//Оценка
gameNotebook.Rating = rateing;
//Цена
IElement price = doc1.QuerySelector("div.fl-pdp-price__current");
string text2 = price.TextContent;
gameNotebook.Price = text2.Replace("₽", "RUB");
//Бонусы*
IElement bonuses = doc1.QuerySelector("span.u-color-red.wrapper-text__rouble");
if (bonuses == null)
{
gameNotebook.Bonuses = null;
}
else
{
string text3 = bonuses.TextContent;
gameNotebook.Bonuses = text3;
}
////Diagonal
//IElement diagonal = shortDescriptionParams.ToList()[0];
//text = diagonal.TextContent;
//gameNotebook. = DeleteNT(text);
//Ядра
//string url3 = url1 + "/specification";
//IDocument doc3 = await context.OpenAsync(url3);
//IEnumerable<IElement> elements = doc3.All.Where(block =>
// block.LocalName == "div"
// && block.ClassList.Contains("product-details-specification-column")
//);
//RAM
IElement ram = shortDescriptionParams.ToList()[2];
text = DeleteNT(text);
text = ram.TextContent;
string NoGB = DeleteNT(text);
gameNotebook.RAM = StringTOint(NoGB);
//SSD
IElement ssd = shortDescriptionParams.ToList()[4];
text = ssd.TextContent;
gameNotebook.SSD = DeleteNT(text);
//Отзывы
string url2 = url1 + "/reviews";
IDocument doc2 = await context.OpenAsync(url2);
//IElement rate = doc2.QuerySelector("span.text-cutter-wrapper");
//Текст
IEnumerable <IElement> opinion = doc2.All.Where(block =>
block.LocalName == "p" &&
block.OuterHtml.Contains("<p itemprop=\"description\">") == true &&
block.Children.All(u => u.LocalName == "span"));
//Оценка
IEnumerable <IElement> points = doc2.All.Where(block =>
block.LocalName == "span" &&
block.OuterHtml.Contains("<span itemprop=\"ratingValue\">") == true);
for (int i = 0; i < opinion.Count(); i++)
{
Reviews reviews = new Reviews();
bool sixth = false;
IElement element = opinion.ToList()[i];
IElement element1 = points.ToList()[i];
var obj5 = db.Reviews;
foreach (Reviews re in obj5)
{
if (element.TextContent == re.Review_text)
{
sixth = true;
}
}
if (sixth == false)
{
reviews.Review_text = element.TextContent;
reviews.Rating = element1.TextContent;
reviews.ID_model = watch;
db.Reviews.Add(reviews);
}
reviews.Review_text = element.TextContent;
}
db.Model.Add(gameNotebook);
db.SaveChanges();
}
else
{
db.SaveChanges();
}
}
}
private void Redact()
{
using (KPgamenotebookContext db = new KPgamenotebookContext())
{
try
{
string[] vs = new string[10];
vs[0] = textBox2.Text;
int ID = Convert.ToInt32(vs[0]);
vs[1] = textBox3.Text;
vs[2] = textBox4.Text;
vs[3] = textBox5.Text;
vs[4] = textBox6.Text;
vs[5] = textBox7.Text;
string stsix = Convert.ToString(comboBox1.SelectedItem);
int six = db.CPU.FirstOrDefault(r => r.Name == stsix).ID_CPU;
string stsev = Convert.ToString(comboBox6.SelectedItem);
int seven = db.Graphiccard.FirstOrDefault(r => r.Name == stsev).ID_GC;
string steig = Convert.ToString(comboBox7.SelectedItem);
int eight = db.Firm.FirstOrDefault(r => r.Name_firm == steig).ID_firm;
vs[9] = db.Model.FirstOrDefault(r => r.ID_model == ID).Href;
foreach (Reviews u in db.Reviews)
{
if (u.ID_model == ID)
{
u.ID_model = null;
}
}
db.SaveChanges();
var obj2 = db.Model;
foreach (Model u in obj2)
{
if (u.ID_model == Convert.ToInt32(textBox2.Text))
{
db.Model.Remove(u);
}
}
db.SaveChanges();
Model model = new Model();
model.ID_model = ID;
model.Href = vs[9];
model.Name = vs[1];
model.Price = vs[2];
model.Rating = vs[3];
model.SSD = vs[4];
model.RAM = Convert.ToInt32(vs[5]);
model.ID_CPU = six;
model.ID_GC = seven;
model.ID_firm = eight;
db.Model.Add(model);
db.SaveChanges();
foreach (Reviews u in db.Reviews)
{
if (u.ID_model == null)
{
u.ID_model = ID;
}
}
db.SaveChanges();
WriteALL();
}
catch
{
MessageBox.Show("Пожалуйста, перепроверьте данные");
textBox3.Clear();
textBox4.Clear();
textBox5.Clear();
textBox6.Clear();
textBox7.Clear();
}
//Model model = db.Model.FirstOrDefault(r => r.ID_model ==ou);
//model.Name = textBox3.Text;
//model.Price = textBox4.Text;
//model.Rating = textBox5.Text;
//model.SSD = textBox6.Text;
//model.RAM = Convert.ToInt32(textBox7.Text);
db.SaveChanges();
}
}
