private void AddInternalOrders_Load(object sender, EventArgs e) { dateBox.Text = Helper.getDate().ToString("dd.MM.yyyy"); List <string> list = Helper.getFieldListFromDataTable(DatabaseAPI.getTeamsWithouOrders()); teamComboBox.DataSource = list; }
private void buttonAdd_Click(object sender, EventArgs e) { int ID = int.Parse(teamComboBox.SelectedValue.ToString()); int code = DatabaseAPI.checkByID(ID, "orders"); if (Convert.ToBoolean(code)) { MessageBox.Show("Заказ с таким ID уже существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { int customersID = int.Parse(customerComboBox.SelectedValue.ToString()); string dateStr = dateBox.Text; try { int dayCount = int.Parse(durationBox.Text); if (dayCount <= 0) { throw new Exception(); } string deadline = date.AddDays(dayCount).ToString("dd.MM.yyyy"); DatabaseAPI.addExternalOrders(ID, dateStr, deadline, customersID); this.Close(); main.FillGrids(); } catch { MessageBox.Show("Длительность должна быть положительным числом", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void Report_Load(object sender, EventArgs e) { this.dt = DatabaseAPI.getExOrderById(ID); string date = dt.Rows[0].ItemArray[1].ToString(); string deadline = dt.Rows[0].ItemArray[2].ToString(); string sum = dt.Rows[0].ItemArray[3].ToString(); reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameterID", ID.ToString())); reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameterDate", date)); reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameterDeadLine", deadline)); reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameterSum", sum)); bool font = Convert.ToBoolean(DatabaseAPI.checkAvailability(this.ID, 1)); bool logo = Convert.ToBoolean(DatabaseAPI.checkAvailability(this.ID, 2)); bool cup = Convert.ToBoolean(DatabaseAPI.checkAvailability(this.ID, 3)); bool clothes = Convert.ToBoolean(DatabaseAPI.checkAvailability(this.ID, 4)); bool cover = Convert.ToBoolean(DatabaseAPI.checkAvailability(this.ID, 5)); reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameterFont", font.ToString())); reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameterLogo", logo.ToString())); reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameterCup", cup.ToString())); reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameterCover", cover.ToString())); reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameterClothes", clothes.ToString())); this.reportViewer1.RefreshReport(); }
private void AddExternalOrders_Load(object sender, EventArgs e) { customerComboBox.DataSource = Helper.getFieldList("customers", "ID"); List <string> list = Helper.getFieldListFromDataTable(DatabaseAPI.getTeamsWithouOrders()); teamComboBox.DataSource = list; dateBox.Text = date.ToString("dd.MM.yyyy");; }
private void addLogosFromForm(bool updateStatus) { if (logoImageLinkBox.Text.Length == 0 && logoDescriptionBox.Text.Length == 0) { throw new Exception(); } DatabaseAPI.addLogos(id, logoImageLinkBox.Text, logoDescriptionBox.Text, logoTextBox.Text, updateStatus); }
private void addFontsFromForm(bool updateStatus) { if (fontMarkBox.Text.Length == 0 && fontWidthBox.Text.Length == 0) { throw new Exception(); } DatabaseAPI.addFonts(id, fontSerifBox.Checked, fontMarkBox.Text, fontWidthBox.Text, fontBoldBox.Checked, updateStatus); }
public void FillGrids() { DatabaseAPI.GenerateGrid(individualsDataGrid, "individuals"); DatabaseAPI.GenerateGrid(legalEntitiesDataGrid, "legal entities"); renderExOrders(externalOrdersDataGrid, "external orders"); renderIntOrders(internalOrdersDataGrid, "internal orders"); DatabaseAPI.GenerateGrid(developmentTeamsDataGrid, "development teams"); DatabaseAPI.GenerateGrid(designersDataGrid, "designers"); DatabaseAPI.GenerateGrid(employeesDataGrid, "employees"); translateHeaders(); }
public static List <string> getFieldList(string tableName, string fieldName) { DataTable data = DatabaseAPI.getTableField(tableName, fieldName); List <string> list = new List <string>(); foreach (DataRow row in data.Rows) { list.Add(row.ItemArray[0].ToString()); } return(list); }
private void addCoversFromForm(bool updateStatus) { if ( coverTypeBox.Text.Length == 0 && coverColorBox.Text.Length == 0 && coverDeviceBox.Text.Length == 0 ) { throw new Exception(); } DatabaseAPI.addCovers(id, coverTypeBox.Text, coverColorBox.Text, coverDeviceBox.Text, updateStatus); }
private void addClothesFromForm(bool updateStatus) { if ( clothesTypeBox.Text.Length == 0 && clothesColorBox.Text.Length == 0 && clothesSizeBox.Text.Length == 0 ) { throw new Exception(); } DatabaseAPI.addClothes(id, clothesTypeBox.Text, clothesColorBox.Text, clothesSizeBox.Text, clothesTextBox.Text, updateStatus); }
private void buttonAdd_Click(object sender, EventArgs e) { bool flag = true; string name = ""; string suname = ""; string patronymic = ""; float passportID = 0; float phoneNumber = 0; int ID = 0; try { ID = int.Parse(IDBox.Text); name = nameBox.Text; suname = sunameBox.Text; patronymic = patronymicBox.Text; passportID = float.Parse(PIDBox.Text); phoneNumber = float.Parse(numberBox.Text); } catch { Helper.reportWrongFieldFormat(); flag = false; } if (passportID < 9) { MessageBox.Show("Номер паспорта должен содержать 9 символов!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); flag = false; } if (phoneNumber < 6) { MessageBox.Show("Номер должен содержать минимум 6 символов", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); flag = false; } if (flag) { int code = DatabaseAPI.checkByID(ID, "customers"); if (Convert.ToBoolean(code)) { MessageBox.Show("Заказчик с таким ID уже существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { DatabaseAPI.addIndividualas(ID, passportID, name, suname, patronymic, phoneNumber); this.Close(); main.FillGrids(); } } }
private void renderIntOrders(DataGridView grid, string name) { if (radioButtonIntUndone.Checked == true) { DatabaseAPI.GenerateGrid(grid, "getUndoneInOrders", true); intOrderBtnControl(true, false, true); } else { DatabaseAPI.GenerateGrid(grid, "getDoneInOrders", true); intOrderBtnControl(false, true, false); } }
private void internalOrdersMarkButton_Click(object sender, EventArgs e) { int id = Helper.getDataGridSelectedKey(internalOrdersDataGrid, 0); if (id >= 0) { DatabaseAPI.markInOrder(id); renderIntOrders(internalOrdersDataGrid, "internal orders"); } else { Helper.reportTheAbsenceOfAKey(); } }
private void externalOrdersDeleteButton_Click(object sender, EventArgs e) { int id = Helper.getDataGridSelectedKey(externalOrdersDataGrid, 0); if (id >= 0) { DatabaseAPI.deleteOrderById(id); Helper.generateDelete(externalOrdersDataGrid, "external orders", "orders"); } else { Helper.reportTheAbsenceOfAKey(); } }
public static int deleteAdapter(int id, string tableName) { int code; code = DatabaseAPI.checkByID(id, tableName); if (code == 0) { return(1); } code = DatabaseAPI.deleteByID(id, tableName); if (code == 1) { return(2); } return(0); }
bool ContactTheDB(bool flag) { bool chekintConnection; DatabaseAPI.CreateConnection(); try { if (flag) { DatabaseAPI.ConnectionOpen(); MessageBox.Show("База данных подключена", "Успешное выполнение", MessageBoxButtons.OK, MessageBoxIcon.Information); FillGrids(); } else { DatabaseAPI.ConnectionClose(); MessageBox.Show("База данных отключена", "Успешное выполнение", MessageBoxButtons.OK, MessageBoxIcon.Information); } chekintConnection = true; } catch (SqlException ex) { string title; switch (ex.Number) { case -1: title = "Неправильное имя сервера"; break; case 4060: title = "Неправильное имя базы"; break; default: title = "Ошибка"; break; } MessageBox.Show(ex.Message, title, MessageBoxButtons.OK, MessageBoxIcon.Error); chekintConnection = false; } return(chekintConnection); }
private void buttonAdd_Click(object sender, EventArgs e) { int ID = int.Parse(teamComboBox.SelectedValue.ToString()); int code = DatabaseAPI.checkOrdersID(ID); if (Convert.ToBoolean(code)) { MessageBox.Show("Заказ с таким ID уже существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { string date = dateBox.Text; DatabaseAPI.addInternalOrders(ID, date); this.Close(); main.FillGrids(); } }
public static void generateDelete(DataGridView grid, string tableName, string parentTableName) { int id = getDataGridSelectedKey(grid, 0); if (id == -1) { reportTheAbsenceOfAKey(); } else { int code = deleteAdapter(id, tableName, parentTableName); if (code == 0) { DatabaseAPI.GenerateGrid(grid, tableName); } callDeleteMessage(code, id); } }
private void buttonAdd_Click(object sender, EventArgs e) { bool flag = true; string name = ""; float inn = 0; int ID = 0; try { ID = int.Parse(IDBox.Text); name = nameBox.Text; inn = float.Parse(innBox.Text); if (ID <= 0) { throw new Exception(); } } catch { Helper.reportWrongFieldFormat(); flag = false; } if (inn < 12) { MessageBox.Show("ИНН должен содержать 12 символов", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); flag = false; } if (flag) { int code = DatabaseAPI.checkByID(ID, "customers"); if (Convert.ToBoolean(code)) { MessageBox.Show("Заказчик с таким ID уже существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { DatabaseAPI.addLegalEntities(ID, name, inn); this.Close(); main.FillGrids(); } } }
private void buttonAdd_Click(object sender, EventArgs e) { int teamLeaders = int.Parse(leadersComboBox.SelectedValue.ToString()); int ID = 0; bool flag = true; try { ID = int.Parse(IDBox.Text); if (ID <= 0) { throw new Exception(); } } catch { Helper.reportWrongFieldFormat(); flag = false; } if (flag) { int code = DatabaseAPI.checkDevelopmentTeamID(ID); if (Convert.ToBoolean(code)) { MessageBox.Show("Команда с таким ID уже существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { string date = dateBox.Text; DatabaseAPI.addDevelopmentTeams(ID, teamLeaders, date); this.Close(); main.FillGrids(); } } }
private void buttonAdd_Click(object sender, EventArgs e) { DatabaseAPI.sendToTheTeam(this.PN, int.Parse(teamsComboBox.SelectedValue.ToString())); main.FillGrids(); this.Close(); }
private void buttonOK_Click(object sender, EventArgs e) { DatabaseAPI.markExOrder(this.ID, int.Parse(textBoxSum.Text)); main.FillGrids(); this.Close(); }
private void compositionOrder_Load(object sender, EventArgs e) { DataTable dt; dt = DatabaseAPI.getProductsByID(id, 1); try { fontSerifBox.Checked = dt.Rows[0].Field <bool>(1); fontMarkBox.Text = dt.Rows[0].Field <String>(2); fontWidthBox.Text = dt.Rows[0].Field <String>(3); fontBoldBox.Checked = dt.Rows[0].Field <bool>(4); fontStatus = true; } catch { } finally { Helper.useButtons(fontStatus, fontsDeleteButton, fontsAddButton, fontsSaveButton); } dt = DatabaseAPI.getProductsByID(id, 2); try { logoImageLinkBox.Text = dt.Rows[0].Field <String>(1); logoDescriptionBox.Text = dt.Rows[0].Field <String>(2); logoTextBox.Text = dt.Rows[0].Field <String>(3); logoStatus = true; } catch { } finally { Helper.useButtons(logoStatus, logosDeleteButton, logosAddButton, logosSaveButton); } dt = DatabaseAPI.getProductsByID(id, 4); try { clothesTypeBox.Text = dt.Rows[0].Field <String>(1); clothesColorBox.Text = dt.Rows[0].Field <String>(2); clothesSizeBox.Text = dt.Rows[0].Field <String>(3); clothesTextBox.Text = dt.Rows[0].Field <String>(4); clothesStatus = true; } catch { } finally { Helper.useButtons(clothesStatus, clothesDeleteButton, clothesAddButton, clothesSaveButton); } dt = DatabaseAPI.getProductsByID(id, 5); try { coverTypeBox.Text = dt.Rows[0].Field <String>(1); coverColorBox.Text = dt.Rows[0].Field <String>(2); coverDeviceBox.Text = dt.Rows[0].Field <String>(3); coverStatus = true; } catch { } finally { Helper.useButtons(coverStatus, coversDeleteButton, coversAddButton, coversSaveButton); } dt = DatabaseAPI.getProductsByID(id, 3); try { cupColorBox.Text = dt.Rows[0].Field <String>(2); cupVolumeBox.Text = dt.Rows[0].Field <int>(3).ToString(); cupStatus = true; } catch { } finally { Helper.useButtons(cupStatus, cupsDeleteButton, cupsAddButton, cupsSaveButton); } }
private void addCupsFromForm(bool updateStatus) { DatabaseAPI.addCups(id, cupColorBox.Text, int.Parse(cupVolumeBox.Text), updateStatus); }