public void updateTableService() { DateTime date = DateTime.Now; if (dtStartDate.Value.Date <= dtEndDate.Value.Date && dtStartDate.Value.Date >= date) { Helper helper = new Helper(); ActionWithDB api = new ActionWithDB(); SqlDataReader reader = api.addServices(); if (tbClubCard.Text != "") { int Ccard = Int32.Parse(tbClubCard.Text); int discont = api.getDiscont(Ccard); helper.clearDataGridView(dGVServices); int i = 0; while (reader.Read()) { dGVServices.RowCount++; dGVServices.Rows[i].Cells[0].Value = reader[0].ToString(); dGVServices.Rows[i].Cells[1].Value = reader[1].ToString(); dGVServices.Rows[i].Cells[2].Value = reader[2].ToString(); dGVServices.Rows[i].Cells[3].Value = discont; dGVServices.Rows[i].Cells[4].Value = api.getTotalCost(discont, dGVServices.Rows[i].Cells[2].Value.ToString()); i++; } } } else { Helper helper = new Helper(); helper.clearDataGridView(dGVFreePlace); } }
private void btnGetService_Click(object sender, EventArgs e) { if (cbChoosePassrport.Text.Length != 0) { string nRecords = ""; string str = cbChoosePassrport.Text; string passport = str.Substring(0, 10); ActionWithDB api = new ActionWithDB(); SqlDataReader reader = api.searchRecord(passport); while (reader.Read()) { nRecords = reader[0].ToString(); } int NRecord = int.Parse(nRecords); int index = dGVServices.CurrentRow.Index; string nService = dGVServices.Rows[index].Cells[0].Value.ToString(); int NService = int.Parse(nService); api.addRecordOfService(NService, NRecord); MessageBox.Show("Услуги приобретена успешно!", "Успешно", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Выберите паспорт", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnBuy_Click(object sender, EventArgs e) { ActionWithDB api = new ActionWithDB(); api.addRecordInHotel(number, login, document, discount, cCard, dateBegin, dateEnd, price, priceInDiscount); MessageBox.Show("Номер успешно куплен на дату с " + dateBegin.Date.ToString() + " по " + dateEnd.Date.ToString(), "Успешно", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); }
private void добавитьПаспортToolStripMenuItem1_Click(object sender, EventArgs e) { DocumentAdd documentAdd = new DocumentAdd(loginUser); documentAdd.ShowDialog(); cbChoosePassrport.Items.Clear(); ActionWithDB api = new ActionWithDB(); SqlDataReader reader = api.enterDocument(loginUser); while (reader.Read()) { cbChoosePassrport.Items.Add(reader[0].ToString()); } }
private void cbChoosePassrport_SelectedIndexChanged(object sender, EventArgs e) { ActionWithDB api = new ActionWithDB(); string str = cbChoosePassrport.Text; string passport = str.Substring(0, 10); SqlDataReader reader = api.seachDocument(passport); while (reader.Read()) { lbSurname.Text = "Surname(Фамилия): " + reader[1]; lbName.Text = "Name(Имя): " + reader[0]; lbSName.Text = "Second Name(Отчество): " + reader[2]; } }
private void UserForm_Load(object sender, EventArgs e) { dGVFreePlace.RowHeadersVisible = false; this.Text = "Вы зашли под логином - " + loginUser; ActionWithDB api = new ActionWithDB(); if (!api.isChekingUserDocument(loginUser)) { MessageBox.Show("Отсутстует паспорт у пользователя - " + loginUser, "Добавьте паспорт", MessageBoxButtons.OK, MessageBoxIcon.Information); } SqlDataReader reader = api.enterDocument(loginUser); while (reader.Read()) { cbChoosePassrport.Items.Add(reader[0].ToString() + " "); } }
private void btnCheckAndBuy_Click(object sender, EventArgs e) { DateTime date = DateTime.Now; if (dtStartDate.Value.Date < dtEndDate.Value.Date && dtStartDate.Value.Date >= date) { if (cbChoosePassrport.Text.Length != 0) { string name = ""; string SName = ""; string surname = ""; string str = cbChoosePassrport.Text; string passport = str.Substring(0, 10); int Ccard = Int32.Parse(tbClubCard.Text); ActionWithDB api = new ActionWithDB(); SqlDataReader reader = api.seachDocument(passport); while (reader.Read()) { surname = reader[1].ToString(); name = reader[0].ToString(); SName = reader[2].ToString(); } int index = dGVFreePlace.CurrentRow.Index; string price = dGVFreePlace.Rows[index].Cells[2].Value.ToString(); string discount = dGVFreePlace.Rows[index].Cells[3].Value.ToString(); string priceDiscount = dGVFreePlace.Rows[index].Cells[4].Value.ToString(); string typeNumber = dGVFreePlace.Rows[index].Cells[1].Value.ToString(); string numberHostel = dGVFreePlace.Rows[index].Cells[0].Value.ToString(); RecordCheck recordCheck = new RecordCheck(loginUser, surname, name, SName, Double.Parse(price), int.Parse(discount), Double.Parse(priceDiscount), passport, typeNumber, int.Parse(numberHostel), dtStartDate.Value.Date, dtEndDate.Value.Date, Ccard); recordCheck.ShowDialog(); updateTable(); } else { MessageBox.Show("Выберите паспорт", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Выбранная дата некорректна", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnRegister_Click(object sender, EventArgs e) { if (tbLogin.Text.Length != 0 && tbPassword.Text.Length != 0 && tbRePassword.Text.Length != 0) { if (!tbLogin.Text.Contains("@")) { ActionWithDB api = new ActionWithDB(); if (api.checkingUser(tbLogin.Text) == 0) { if (tbPassword.Text == tbRePassword.Text) { api.addUser(tbLogin.Text, tbPassword.Text); Helper helper = new Helper(); helper.clearAllTextBox(tbLogin, tbPassword, tbRePassword); MessageBox.Show("Регистрация прошла успешна", "Успех!", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Пароли не совпадают", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Пользователь с таким логином зарегестрирован", "Ошибка" , MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Имееться спец символ '@'", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Введите все данные", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void StartForm_Load(object sender, EventArgs e) { tbLogin.Text = "123"; tbPassword.Text = "123"; string addStr; ActionWithDB api = new ActionWithDB(); bool flagConect = api.isVerificationConnect(); if (flagConect) { addStr = "активно"; btnAdit.Enabled = true; регистрацияToolStripMenuItem.Enabled = true; } else { addStr = "не активно"; btnAdit.Enabled = false; регистрацияToolStripMenuItem.Enabled = false; } lbConnection.Text += " " + addStr; }
private void btAdd_Click(object sender, EventArgs e) { if (tbFirstName.Text.Length != 0 && tbLastName.Text.Length != 0 && tbPassport.Text.Length != 0) { ActionWithDB api = new ActionWithDB(); if (!api.ischeckingDocumentForPassport(tbLastName.Text, tbPassport.Text)) { api.addDocument(login, tbLastName.Text, tbFirstName.Text, tbSecondName.Text, tbPassport.Text); Helper helper = new Helper(); helper.clearAllTextBox(tbLastName, tbFirstName, tbSecondName, tbPassport); MessageBox.Show("Добавлено", "Успешно", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); this.Close(); } else { MessageBox.Show("Ошибка", "Такие данные существуют", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Ошибка", "Не заполненные поля ввода", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnAdit_Click(object sender, EventArgs e) { if (!(tbLogin.Text.Length == 0 && tbPassword.Text.Length == 0)) { Helper helper = new Helper(); ActionWithDB api = new ActionWithDB(); if (api.verificationLoginAdnPassword(tbLogin.Text, tbPassword.Text) == 1) { UserForm userForm = new UserForm(tbLogin.Text); userForm.Show(); this.Hide(); } else { MessageBox.Show("Неправльный логин или пароль", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Введите логин и пароль", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } }