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(); } }