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);
}
}
