private void buttonChangeProject_Click(object sender, EventArgs e) { database.Query("UPDATE tbl_projects SET p_active = @p_active WHERE project_id = @project_id;"); database.AddParameter("@project_id", selectedIndexProject); database.AddParameter("@p_active", checkBoxActiveChangeProject.Checked ? 1 : 0); ConfirmBoxBuilder builder = new ConfirmBoxBuilder(); builder.BuildTop("You are about to change the following information:"); builder.BuildCenter("Active: " + checkBoxActiveChangeProject.Checked.ToString()); builder.BuildBottom(tabControlFinance, tabPageProjects, dataGridViewProjects, queryProjects); builder.GetConfirmBox().Show(); }
private void buttonAddQuotationSave_Click(object sender, EventArgs e) { int projectId; bool correct = true; string message = ""; database.Query("SELECT COUNT(*) FROM tbl_projects;"); int countOfProjects = (int)database.ExecuteQuery(); database.Query("INSERT INTO tbl_quotations(project_id, q_status) VALUES(@project_id, @q_status)"); if (int.TryParse(textBoxAddQuotationProjectId.Text, out projectId)) { database.AddParameter("@project_id", textBoxAddQuotationProjectId.Text); if (projectId <= countOfProjects) { database.AddParameter("@project_id", projectId); } else { correct = false; message += "Project ID does not exists. "; } } else { correct = false; message += "Project ID is not a number. "; } database.AddParameter("@q_status", textBoxAddQuotationStatus.Text); if (correct) { ConfirmBoxBuilder builder = new ConfirmBoxBuilder(); builder.BuildTop("You are about to change the following information:"); builder.BuildCenter("Project ID: " + textBoxAddQuotationProjectId.Text + Environment.NewLine + "Status: " + textBoxAddQuotationStatus.Text); builder.BuildBottom(tabControlFinance, tabPageProjects, dataGridViewProjects, queryProjects); builder.GetConfirmBox().Show(); } else { MessageBox.Show(message); } }
private void buttonDeleteInvoice_Click(object sender, EventArgs e) { database.Query("DELETE * FROM tbl_invoices WHERE invoice_id = @id;"); database.AddParameter("@id", selectedIndexInvoice); ConfirmBoxBuilder builder = new ConfirmBoxBuilder(); builder.BuildTop("Are you sure you want to delete the following information: "); builder.BuildCenter("Project id: " + textBoxChangeInvoiceProjectId.Text + Environment.NewLine + "Description: " + textBoxChangeInvoiceDescription.Text + Environment.NewLine + "Price: " + textBoxChangeInvoicePrice.Text); builder.BuildBottom(tabControlFinance, tabPageInvoices, dataGridViewInvoices, "SELECT * FROM tbl_invoices;"); database.ExecuteQuery(); }
private void buttonSaveChangeInvoice_Click(object sender, EventArgs e) { bool correct = true; string message = ""; decimal price; database.Query("UPDATE tbl_invoices SET project_id = @project_id, i_description = @i_description, i_price = @i_price WHERE invoice_id = @id;"); database.AddParameter("@project_id", textBoxChangeInvoiceProjectId.Text); database.AddParameter("@i_description", textBoxChangeInvoiceDescription.Text); if (decimal.TryParse(textBoxChangeInvoicePrice.Text, out price)) { database.AddParameter("@i_price", price); } else { correct = false; message += "Price is not valid datatype."; } database.AddParameter("@id", selectedIndexInvoice); if (correct) { ConfirmBoxBuilder builder = new ConfirmBoxBuilder(); builder.BuildSize(500, 450); builder.BuildTop("You are about to save the following data:"); builder.BuildCenter("Project id: " + textBoxChangeInvoiceProjectId.Text + Environment.NewLine + "Description: " + textBoxChangeInvoiceDescription.Text + Environment.NewLine + "Price: " + textBoxChangeInvoicePrice.Text); builder.BuildBottom(tabControlFinance, tabPageInvoices, dataGridViewInvoices, "SELECT * FROM tbl_invoices;"); builder.GetConfirmBox().Show(); } else { MessageBox.Show(message); } }
private void buttonSaveInvoice_Click(object sender, EventArgs e) { UpdateInfo(); bool correct = true; string message = ""; decimal price; int projectId; database.Query("SELECT COUNT(*) FROM tbl_projects;"); int countOfProjects = (int)database.ExecuteQuery(); database.Query("SELECT COUNT(*) FROM tbl_invoices;"); int countOfInvoicesId = (int)database.ExecuteQuery(); database.Query("INSERT INTO tbl_invoices(invoice_id, project_id, i_description, i_price, i_paid) VALUES " + "(@id, @project_id, @i_description, @i_price, @i_paid);"); database.AddParameter("@id", ++countOfInvoicesId); if (int.TryParse(textBoxProjectId.Text, out projectId)) { if (projectId <= countOfProjects) { database.AddParameter("@project_id", projectId); } else { correct = false; message += "Project ID does not exists. "; } } else { correct = false; message += "Project ID is not a valid number. "; } if (decimal.TryParse(textBoxInvoicePrice.Text, out price)) { database.AddParameter("@i_price", price); } else { correct = false; message += "Price is not valid datatype. "; } database.AddParameter("@id", selectedIndexInvoice); if (correct) { database.AddParameter("@i_description", textBoxInvoiceDescription.Text); database.AddParameter("@i_price", textBoxInvoicePrice.Text); database.AddParameter("@i_paid", checkBoxAddInvoicePaid.Checked ? 1 : 0); ConfirmBoxBuilder builder = new ConfirmBoxBuilder(); builder.BuildSize(400, 500); builder.BuildTop("Are you sure you want to save the following information:"); builder.BuildCenter("Project id: " + countOfInvoicesId.ToString() + Environment.NewLine + "Description: " + textBoxInvoiceDescription.Text + Environment.NewLine + "Price: " + textBoxInvoicePrice.Text + Environment.NewLine + "Paid: " + checkBoxChangeInvoicePaid.Checked.ToString()); builder.BuildBottom(tabControlFinance, tabPageInvoices, dataGridViewInvoices, "SELECT * FROM tbl_invoices;"); builder.GetConfirmBox().Show(); } else { MessageBox.Show(message); } }