private Dish dishGetFromForm()//при внесении новых блюд изменяем БД { Dish newDish = new Dish(); if (string.IsNullOrWhiteSpace(textBoxDishChange.Text) || string.IsNullOrEmpty(textBoxDishChange.Text)) { ErrorlabelCom.Text = "Ошибка:\r\nПоле \"Название блюда\" должно быть обязательно заполнено."; throw new System.ArgumentNullException(); } else { newDish.title = textBoxDishChange.Text; } if (string.IsNullOrWhiteSpace(textBoxNumDishChange.Text) || string.IsNullOrEmpty(textBoxNumDishChange.Text)) { ErrorlabelCom.Text = "Ошибка:\r\nПоле \"Цена блюда\" должно быть обязательно заполнено."; throw new System.ArgumentNullException(); } else { newDish.quantily = Convert.ToInt32(textBoxNumDishChange.Text); } newDish.cafe = Cafe.Get(cafeId); return(newDish); }
private void ButtonChangeAdd_Click(object sender, EventArgs e) { FormChangeComposition winArray; try { if (menuDGV.SelectedRows.Count > 0) { winArray = new FormChangeComposition((int)menuDGV.SelectedRows[0].Cells["Column16"].Value, (int)menuDGV.SelectedRows[0].Cells["cafe_idcafe"].Value); winArray.Show(); menuDGV_FirstReload(); } else { int k = 0; cafeList = Cafe.Get(); while (comboBoxCafe.Text != cafeList[k].address) { ++k; } winArray = new FormChangeComposition(cafeList[k].idcafe); winArray.Show(); menuDGV_FirstReload(); } } catch { ErrorlabelMenu.Text = "Ошибка:\r\nВы не выбрали кафе."; } }
//-------------------------------CAFE TABLE------------------------------- private void cafeDGV_FirstReload() { cafeDGV.Rows.Clear(); cafeList = Cafe.Get(); foreach (Cafe cafe in cafeList) { cafeDGV.Rows.Add(cafe.idcafe, cafe.owner, cafe.title, cafe.address, cafe.phone, cafe.rating); } for (int i = 0; i < cafeDGV.RowCount; ++i) { cafeDGV.Rows[i].Selected = false; } textBox1.Text = ""; textBox2.Text = ""; textBox3.Text = ""; textBox4.Text = ""; textBox5.Text = ""; choosenIndexCafe = -1; }
public void menuDGV_FirstReload()//заполняем таблицу блюдами { int k = 0; menuDGV.Rows.Clear(); Cafe tmp = new Cafe(); dishList = Dish.Get(); cafeList = Cafe.Get(); while (comboBoxCafe.Text != cafeList[k].address) { ++k; } tmp.idcafe = cafeList[k].idcafe; foreach (Dish dish in dishList) { if (GetCafeDish(tmp, dish) != "0") { menuDGV.Rows.Add(dish.iddish, tmp.idcafe, dish.title, dish.quantily); } } for (int i = 0; i < menuDGV.RowCount; ++i) { menuDGV.Rows[i].Selected = false; } choosenIndexDish = -1; }
private Serve serveGetFromForm() { int i = 0; Serve newServe = new Serve(); if (string.IsNullOrWhiteSpace(textBoxName.Text) || string.IsNullOrEmpty(textBoxName.Text)) { ErrorlabelServe.Text = "Ошибка:\r\nПоле \"ФИО сотрудника\" должно быть обязательно заполнено."; throw new System.ArgumentNullException(); } else { newServe.name = textBoxName.Text; } if (string.IsNullOrWhiteSpace(textBoxPassport.Text) || string.IsNullOrEmpty(textBoxPassport.Text)) { ErrorlabelServe.Text = "Ошибка:\r\nПоле \"Паспортные данные\" должно быть обязательно заполнено."; throw new System.ArgumentNullException(); } else { newServe.passport = Convert.ToInt32(textBoxPassport.Text); } newServe.education = textBoxEducation.Text; if (string.IsNullOrWhiteSpace(textBoxExperience.Text) || string.IsNullOrEmpty(textBoxExperience.Text)) { ErrorlabelServe.Text = "Ошибка:\r\nПоле \"Опыт работы\" должно быть обязательно заполнено."; throw new System.ArgumentNullException(); } else { newServe.experience = Convert.ToInt32(textBoxExperience.Text); } if (string.IsNullOrWhiteSpace(comboBoxServeCafe.Text) || string.IsNullOrEmpty(comboBoxServeCafe.Text)) { ErrorlabelServe.Text = "Ошибка:\r\nПоле \"Адрес кофейни\" должно быть обязательно заполнено."; throw new System.ArgumentNullException(); } else { while (comboBoxServeCafe.Text != cafeList[i].address) { ++i; } newServe.cafe = Cafe.Get(cafeList[i].idcafe); } return(newServe); }
private void DGVCount_FirstReload() { DGVCount.Rows.Clear(); cafeList = Cafe.Get(); foreach (Cafe cafe in cafeList) { if (GetCafeServ(cafe) == true) { DGVCount.Rows.Add(cafe.idcafe, cafe.address, Cafe.GetCountServe(cafe.idcafe), Cafe.GetPostCafe(cafe.idcafe)); } } for (int i = 0; i < DGVCount.RowCount; ++i) { DGVCount.Rows[i].Selected = false; } choosenIndexCafe = -1; }
private void supDGV_FirstReload() { supDGV.Rows.Clear(); cafeList = Cafe.Get(); supList = Supplier.Get(); comboBoxSupCafe.Items.Clear(); foreach (Supplier supplier in supList) { foreach (Cafe cafe in cafeList) { if (GetCafeSup(cafe, supplier) != "0") { supDGV.Rows.Add(supplier.idsupplier, supplier.title, supplier.product, supplier.FrequencyOfDeliveries, supplier.VolumeOfDeliveries, cafe.address); } } } for (int i = 0; i < supDGV.RowCount; ++i) { supDGV.Rows[i].Selected = false; } foreach (Cafe cafe in cafeList) { comboBoxSupCafe.Items.Add(cafe.address); } comboBoxSupCafe.SelectedIndex = -1; textBoxSupTitle.Text = ""; textBoxSupProduct.Text = ""; textBoxSupFOD.Text = ""; textBoxSupVOD.Text = ""; comboBoxSupCafe.Text = null; choosenIndexSupplier = -1; }
private void servDGV_FirstReload() { servDGV.Rows.Clear(); cafeList = Cafe.Get(); serveList = Serve.Get(); comboBoxServeCafe.Items.Clear(); foreach (Serve serve in serveList) { foreach (Cafe cafe in cafeList) { if (GetCafeServe(cafe, serve) != "0") { servDGV.Rows.Add(serve.idserve, serve.name, serve.passport, serve.education, serve.experience, cafe.address); } } } for (int i = 0; i < servDGV.RowCount; ++i) { servDGV.Rows[i].Selected = false; } foreach (Cafe cafe in cafeList) { comboBoxServeCafe.Items.Add(cafe.address); } comboBoxServeCafe.SelectedIndex = -1; textBoxName.Text = ""; textBoxPassport.Text = ""; textBoxEducation.Text = ""; textBoxExperience.Text = ""; comboBoxServeCafe.Text = null; choosenIndexServe = -1; }
private Supplier supGetFromForm() { int i = 0; Supplier newSupplier = new Supplier(); if (string.IsNullOrWhiteSpace(textBoxSupTitle.Text) || string.IsNullOrEmpty(textBoxSupTitle.Text)) { ErrorlabelSup.Text = "Ошибка:\r\nПоле \"Название фирмы\" должно быть обязательно заполнено."; throw new System.ArgumentNullException(); } else { newSupplier.title = textBoxSupTitle.Text; } if (string.IsNullOrWhiteSpace(textBoxSupProduct.Text) || string.IsNullOrEmpty(textBoxSupProduct.Text)) { ErrorlabelSup.Text = "Ошибка:\r\nПоле \"Поставляемая продукция\" должно быть обязательно заполнено."; throw new System.ArgumentNullException(); } else { newSupplier.product = textBoxSupProduct.Text; } newSupplier.FrequencyOfDeliveries = Convert.ToInt32(textBoxSupFOD.Text); newSupplier.VolumeOfDeliveries = Convert.ToInt32(textBoxSupVOD.Text); while (comboBoxSupCafe.Text != cafeList[i].address) { ++i; } newSupplier.cafe = Cafe.Get(cafeList[i].idcafe); return(newSupplier); }
public static bool export(string f_name) { XmlDocument doc = new XmlDocument(); XmlElement cafeElement, SupElemnt, root; XmlDeclaration declaration; XmlAttribute attribute; doc.Schemas.Add(targetNamespace, xds); declaration = doc.CreateXmlDeclaration("1.0", "UTF-8", null); root = doc.CreateElement("BDCafe"); doc.AppendChild(root); List <Cafe> cafeList; cafeList = Cafe.Get(); List <Supplier> supList; supList = Supplier.Get(); foreach (Cafe cafe in cafeList) { cafeElement = doc.CreateElement("Cafe"); //attribute = doc.CreateAttribute("idcafe"); //attribute.Value = cafe.idcafe.ToString(); //cafeElement.Attributes.Append(attribute); attribute = doc.CreateAttribute("owner"); attribute.Value = cafe.owner; cafeElement.Attributes.Append(attribute); attribute = doc.CreateAttribute("title"); attribute.Value = cafe.title; cafeElement.Attributes.Append(attribute); attribute = doc.CreateAttribute("address"); attribute.Value = cafe.address; cafeElement.Attributes.Append(attribute); attribute = doc.CreateAttribute("phone"); attribute.Value = cafe.phone.ToString(); cafeElement.Attributes.Append(attribute); attribute = doc.CreateAttribute("rating"); attribute.Value = cafe.rating.ToString(); cafeElement.Attributes.Append(attribute); foreach (Supplier supplier in supList) { if (GetCafeSup(cafe, supplier) == true) { SupElemnt = doc.CreateElement("Supplier"); //attribute = doc.CreateAttribute("idsupplier"); //attribute.Value = supplier.idsupplier.ToString(); //SupElemnt.Attributes.Append(attribute); attribute = doc.CreateAttribute("title"); attribute.Value = supplier.title; SupElemnt.Attributes.Append(attribute); attribute = doc.CreateAttribute("product"); attribute.Value = supplier.product; SupElemnt.Attributes.Append(attribute); attribute = doc.CreateAttribute("Frequencyofdeliveries"); attribute.Value = supplier.FrequencyOfDeliveries.ToString(); SupElemnt.Attributes.Append(attribute); attribute = doc.CreateAttribute("Volumeofdeliveries"); attribute.Value = supplier.VolumeOfDeliveries.ToString(); SupElemnt.Attributes.Append(attribute); attribute = doc.CreateAttribute("cafeAddress"); attribute.Value = supplier.cafe.address; //ID SupElemnt.Attributes.Append(attribute); cafeElement.AppendChild(SupElemnt); } } root.AppendChild(cafeElement); } doc.Save(f_name); try { doc.DocumentElement.SetAttribute("xmlns", targetNamespace); doc.Validate(null); return(true); } catch { return(false); } }
static public void import(string f_name) { XmlDocument doc = new XmlDocument(); doc.Load(f_name); XmlElement root = doc.DocumentElement; doc.Schemas.Add(targetNamespace, xds); if (string.IsNullOrEmpty(doc.DocumentElement.NamespaceURI)) { doc.DocumentElement.SetAttribute("xmlns", targetNamespace); doc.LoadXml(doc.InnerXml); } //try //{ // doc.DocumentElement.SetAttribute("xmlns", targetNamespace); // doc.Validate(null); //} //catch //{ // MessageBox.Show("Документ не соответсвует схеме", "Информация", MessageBoxButtons.OKCancel); // return; //} foreach (XmlNode n in root) { Cafe c = new Cafe(); List <Cafe> cafeList; cafeList = Cafe.Get(); //c.idcafe = Int32.Parse(n.Attributes["idcafe"].Value); c.owner = n.Attributes["owner"].Value; c.title = n.Attributes["title"].Value; c.address = n.Attributes["address"].Value; c.phone = Int32.Parse(n.Attributes["phone"].Value); c.rating = Int32.Parse(n.Attributes["rating"].Value); Cafe np = new Cafe(); np = np.search(c.address); if (np == null) { c.add(c); cafeList = Cafe.Get(); c.idcafe = cafeList.LastOrDefault().idcafe; } else { c.change(np.idcafe, c);//обновляет c.idcafe = np.idcafe; } foreach (XmlNode t in n) { Supplier s = new Supplier(); if (t.Attributes["cafeAddress"].Value != c.address) { break; } //s.idsupplier = Int32.Parse(t.Attributes["idsupplier"].Value); s.title = t.Attributes["title"].Value; s.product = t.Attributes["product"].Value; s.FrequencyOfDeliveries = Int32.Parse(t.Attributes["Frequencyofdeliveries"].Value); s.VolumeOfDeliveries = Int32.Parse(t.Attributes["Volumeofdeliveries"].Value); s.cafe = Cafe.Get(c.idcafe); Supplier sp = new Supplier(); sp = sp.search(s.title); if (sp == null) { s.add(s); } else { s.change(sp.idsupplier, s); } } } }