private void buttonRepeat_Click(object sender, EventArgs e) { List <int> orderLines = new List <int>(); double sum = 0; var lines = (from line in ctx.HISTORY_LINES where line.HL_ORDER_HEADER == history_header select line).ToList(); foreach (var line in lines) { var x = new ORDER_LINES { OL_ITEM = line.HL_ITEM, OL_QUANTITY = line.HL_QUANTITY }; var item = (from i in ctx.ITEMS where i.I_ID == x.OL_ITEM select i).First(); sum += (double)item.I_PRICE * x.OL_QUANTITY; ctx.ORDER_LINES.Add(x); ctx.SaveChanges(); orderLines.Add(x.OL_ID); } FormOrderHeader orderHeader = new FormOrderHeader(orderLines, user_id, sum); orderHeader.ShowDialog(this); orderHeader.Dispose(); this.Close(); }
private void buttonOrderDone_Click(object sender, EventArgs e) { int header = (int)dataGridViewOrderHeaders.CurrentRow.Cells["oHIDDataGridViewTextBoxColumn"].Value; var lines = (from line in ctx.ORDER_LINES where line.OL_ORDER_HEADER == header select line).ToList(); foreach (var line in lines) { ctx.ORDER_LINES.Remove(line); ctx.SaveChanges(); } oRDERHEADERSBindingSource.RemoveCurrent(); }
private void buttonOK_Click(object sender, EventArgs e) { if (!checkBoxApprove.Checked) { MessageBox.Show("Необхідна згода з вимогами публічної пропозиції!", "Увага!"); return; } if (textBoxCard1.Text == "" || textBoxCard2.Text == "" || textBoxCard3.Text == "" || textBoxCard4.Text == "" || textBoxCVV.Text == "" || comboBoxYear.Text == "" || comboBoxMonth.Text == "" || textBoxCard2.Text == null || textBoxCard3.Text == null || textBoxCard4.Text == null || textBoxCVV.Text == null || textBoxCard1.Text == null || comboBoxMonth.Text == null || comboBoxYear.Text == null) { MessageBox.Show("Заповнення усіх полів необхідне!", "Помилка"); return; } if (textBoxCard1.Text.Length != 4 || textBoxCard2.Text.Length != 4 || textBoxCard3.Text.Length != 4 || textBoxCard4.Text.Length != 4) { MessageBox.Show("Вказаний номер картки не є коректним", "Помилка"); return; } if (textBoxCVV.Text.Length != 3) { MessageBox.Show("Некоректний формат CVV"); return; } DateTime date = new DateTime(Convert.ToInt32("20" + comboBoxYear.Text), Convert.ToInt32(comboBoxMonth.Text), 1); var transaction = new TRANSACTIONS { T_DATE = System.DateTime.Now, T_EXPIRE_DATE = date, T_RRN = textBoxCard1.Text + textBoxCard2.Text + textBoxCard3.Text + textBoxCard4.Text }; ctx.TRANSACTIONS.Add(transaction); ctx.SaveChanges(); transaction_id = transaction.T_ID; finished = true; MessageBox.Show("Транзакцію успішно виконано!"); this.Close(); }
private void AddUser() { var quantity = (from u in ctx.USERS select u).Count(); string modifier = "U"; if (quantity == 0) { modifier = "A"; } var user = new USERS { U_LOGIN = login, U_MODIFIER = modifier, U_PASSWORD = password }; ctx.USERS.Add(user); ctx.SaveChanges(); var customer = new CUSTOMERS { C_EMAIL = email, C_NAME = name, C_PHONE = phoneNumber, C_USERID = user.U_ID }; ctx.CUSTOMERS.Add(customer); ctx.SaveChanges(); MessageBox.Show(user.U_MODIFIER == "A" ? "Адміністраторa" : "Користувачa" + " успішно зареєстровано!"); this.Close(); }
private void FormPizzaOrder_FormClosing(object sender, FormClosingEventArgs e) { if (finished == false) { var query = (from line in ctx.ORDER_LINES where orderLines.Contains(line.OL_ID) select line); foreach (var line in query) { ctx.ORDER_LINES.Remove(line); } ctx.SaveChanges(); } }
private void buttonAdd_Click(object sender, EventArgs e) { var line = new ORDER_LINES { OL_ITEM = item_id, OL_QUANTITY = quantity }; ctx.ORDER_LINES.Add(line); ctx.SaveChanges(); orderLines.Add(line.OL_ID); this.Close(); }
private void button1_Click(object sender, EventArgs e) { var line = new ORDER_LINES { OL_ITEM = (int)dataGridViewSizes.CurrentRow.Cells["iIDDataGridViewTextBoxColumn"].Value, OL_QUANTITY = quantity }; ctx.ORDER_LINES.Add(line); ctx.SaveChanges(); orderLines.Add(line.OL_ID); this.Close(); }
private void button1_Click(object sender, EventArgs e) { if (richTextBox1.Text != null && richTextBox1.Text != "") { var review = new REVIEWS { R_DATE = System.DateTime.Now, R_CUSTOMERID = customer_id, R_TEXT = richTextBox1.Text }; ctx.REVIEWS.Add(review); ctx.SaveChanges(); this.Close(); } else { MessageBox.Show("Порожній відгук не буде опубліковано!", "Увага"); return; } }
private async void buttonAdd_Click(object sender, EventArgs e) { if (textBoxAddress.Text == null || textBoxAddress.Text == "" || textBoxCity.Text == null || textBoxAddress.Text == "") { MessageBox.Show("Заповнення усіх полів обов'язкове!", "Увага"); return; } var store = new STORES { S_CITY = textBoxCity.Text, S_ADDRESS = textBoxAddress.Text }; string address = store.S_CITY + ", " + store.S_ADDRESS; (store.S_LATITUDE, store.S_LONGITUDE) = await LocationFromAddress(address); ctx.STORES.Add(store); ctx.SaveChanges(); this.Close(); }
private void buttonAdd_Click(object sender, EventArgs e) { const int logo_id = 70; if (comboBoxCategory.Text == "" || comboBoxCategory.Text == null || textBoxName.Text == "" || textBoxName.Text == null || textBoxS.Text == null || textBoxS.Text == "" || (comboBoxCategory.SelectedIndex == 0 && (textBoxM.Text == null || textBoxM.Text == "" || textBoxL.Text == null || textBoxL.Text == ""))) { MessageBox.Show("Усі поля є обов'язковими для заповнення!", "Увага"); return; } category = comboBoxCategory.Text; name = textBoxName.Text; var item1 = new ITEMS { I_DESCRIPTION = richTextBoxDescription.Text, I_CATEGORY = comboBoxCategory.Text, I_PRICE = Decimal.Parse(textBoxS.Text, CultureInfo.InvariantCulture), I_NAME = textBoxName.Text, I_IMAGE = logo_id }; if (comboBoxCategory.SelectedIndex == 0) { var item2 = new ITEMS { I_DESCRIPTION = richTextBoxDescription.Text, I_CATEGORY = comboBoxCategory.Text, I_PRICE = Decimal.Parse(textBoxM.Text, CultureInfo.InvariantCulture), I_NAME = textBoxName.Text, I_SIZE = "M", I_IMAGE = logo_id }; var item3 = new ITEMS { I_DESCRIPTION = richTextBoxDescription.Text, I_CATEGORY = comboBoxCategory.Text, I_PRICE = Decimal.Parse(textBoxL.Text, CultureInfo.InvariantCulture), I_NAME = textBoxName.Text, I_SIZE = "L", I_IMAGE = logo_id }; item1.I_SIZE = "S"; ctx.ITEMS.Add(item2); ctx.ITEMS.Add(item3); ctx.SaveChanges(); } ctx.ITEMS.Add(item1); try { ctx.SaveChanges(); } catch (Exception) { MessageBox.Show("Помилка при додаванні нової страви!", "Увага"); this.Close(); } this.Close(); }
private async void buttonOK_Click(object sender, EventArgs e) { if (comboBoxPayment.Text == null || textBoxHouse.Text == null || textBoxApp.Text == null || textBoxCity.Text == null || textBoxHouse.Text == "" || textBoxCity.Text == "" || textBoxApp.Text == "" || comboBoxPayment.Text == "") { MessageBox.Show("Заповніть обов'язкові поля!"); return; } var cityPresence = (from c in ctx.STORES where c.S_CITY.Equals(textBoxCity.Text.Trim()) select c).Count(); if (cityPresence == 0) { MessageBox.Show("На жаль, доставка Dominos в місто " + textBoxCity.Text + " неможлива!"); return; } string address = textBoxCity.Text + ", вул. " + textBoxStreet.Text + " " + textBoxHouse.Text + " кв." + textBoxApp.Text; var customer = (from c in ctx.CUSTOMERS where c.C_USERID == user select c).First(); var header = new ORDER_HEADERS { OH_CUSTOMER = customer.C_ID, OH_ADDRESS = address, OH_STORE = 1, //////// OH_DATE = System.DateTime.Now, OH_SUM = sum }; var history_header = new HISTORY_HEADERS { HH_DATE = System.DateTime.Now, HH_PAYMENT_TYPE = comboBoxPayment.Text, HH_CUSTOMER = header.OH_CUSTOMER }; if (comboBoxPayment.Text.Equals("Карткою онлайн")) { FormTransaction transaction = new FormTransaction(sum); transaction.ShowDialog(this); if (transaction.finished) { history_header.HH_TRANSACTION = transaction.transaction_id; } else { MessageBox.Show("Транзакцію не було завершено!"); transaction.Dispose(); return; } transaction.Dispose(); } LoadingWindow loadingWindow = new LoadingWindow(); loadingWindow.Show(); int store_id = await GetNearestStore(address); var storeOH = (from s in ctx.STORES where s.S_ID == store_id select s).First(); loadingWindow.Close(); MessageBox.Show("Замовлення буде виконано з ресторану за адресою: \n" + storeOH.S_CITY.Trim() + ", " + storeOH.S_ADDRESS); //FormMaps maps = new FormMaps(store_id, address); //maps.ShowDialog(this); //maps.Dispose(); header.OH_STORE = store_id; ctx.ORDER_HEADERS.Add(header); ctx.SaveChanges(); ctx.HISTORY_HEADERS.Add(history_header); ctx.SaveChanges(); var lines = (from line in ctx.ORDER_LINES where orderLines.Contains(line.OL_ID) select line).ToList(); foreach (var line in lines) { line.OL_ORDER_HEADER = header.OH_ID; var x = new HISTORY_LINES { HL_ITEM = line.OL_ITEM, HL_ORDER_HEADER = history_header.HH_ID, HL_QUANTITY = line.OL_QUANTITY }; ctx.HISTORY_LINES.Add(x); ctx.SaveChanges(); } finished = true; MessageBox.Show("Дякуємо за покупку! \nОчікуйте СМС-повідомлення."); //https://control.txtlocal.co.uk/settings/apikeys/ //settings -> API -> Create New API string apiKey = "123abc"; //replace this with your ApiKey string number = "+38" + customer.C_PHONE; string message = "Hello, it's Dominos! Your order #" + header.OH_ID + " will be delievered in an hour."; //"Замовлення №" + header.OH_ID + " буде доставлено протягом години. "; sendSMS sms = new sendSMS(); string result = sms.sendMessage(apiKey, number, message); //MessageBox.Show(result); this.Close(); }