private void button3_Click(object sender, EventArgs e)
{
saved = true;
Database.GetInstance().Query("SELECT COUNT(*) FROM tbl_companies;");
int countOfCompanyId = (int)Database.GetInstance().ExecuteQuery();
Database.GetInstance().Query("INSERT INTO tbl_companies(c_name, c_address, c_housenumber, c_city, c_contactperson_first_name, " +
"c_contactperson_telephone_number, c_contactperson_faxnumber, c_contactperson_email, c_contactperson_telephone_number2, c_city2, c_zipcode, c_zipcode2, c_address2, c_credit_balance, c_bkr) " +
"VALUES(@c_name, @c_address, @c_housenumber, @c_city, @c_contactperson_first_name, " +
"@c_contactperson_telephone_number, @c_contactperson_faxnumber, @c_contactperson_email, @c_contactperson_telephone_number2, @c_city2, @c_zipcode, @c_zipcode2, @c_address2, @c_credit_balance, @c_bkr)");
Database.GetInstance().AddParameter("@c_name", sales.textBoxCompanyName.Text);
Database.GetInstance().AddParameter("@c_address", sales.textBoxAddress1.Text);
Database.GetInstance().AddParameter("@c_housenumber", sales.textBoxHousenumber.Text);
Database.GetInstance().AddParameter("@c_city", sales.textBoxResidence1.Text);
Database.GetInstance().AddParameter("@c_contactperson_first_name", sales.textBoxContactPerson.Text);
Database.GetInstance().AddParameter("@c_contactperson_telephone_number", sales.textBoxTelephone1.Text);
Database.GetInstance().AddParameter("@c_contactperson_faxnumber", sales.textBoxFaxnumber.Text);
Database.GetInstance().AddParameter("@c_contactperson_telephone_number2", sales.textBoxTelephone2.Text);
Database.GetInstance().AddParameter("@c_contactperson_email", sales.textBoxEmail.Text);
Database.GetInstance().AddParameter("@c_zipcode", sales.textBoxZipcode2.Text);
Database.GetInstance().AddParameter("@c_zipcode2", sales.textBoxZipcode2.Text);
Database.GetInstance().AddParameter("@c_address2", sales.textBoxAddress2.Text);
Database.GetInstance().AddParameter("@c_city2", sales.textBoxResidence2.Text);
Database.GetInstance().AddParameter("@c_credit_balance", 0);
Database.GetInstance().AddParameter("@c_bkr", 0);
Database.GetInstance().ExecuteQuery();
sales.tabControlSales.SelectedTab = sales.tabCustomers;
sales.UpdateInfo();
}
private void btnSaveProject_Click(object sender, EventArgs e)
{
saved = true;
Database.GetInstance().Query("SELECT COUNT(*) FROM tbl_projects");
int countOfProjectId = (int)Database.GetInstance().ExecuteQuery();
Database.GetInstance().Query("INSERT INTO tbl_projects(project_id, p_company_name, p_customer_name, p_name, p_start_date, p_end_date, p_cost, p_terms) " +
"VALUES(@project_id, @p_company_name, @p_customer_name, @p_name, @p_start_date, @p_end_date, @p_cost, @p_terms)");
Database.GetInstance().AddParameter("@project_id", ++countOfProjectId);
Database.GetInstance().AddParameter("@p_company_name", sales.textBoxC_Name.Text);
Database.GetInstance().AddParameter("@p_customer_name", sales.textBoxCustomerName.Text);
Database.GetInstance().AddParameter("@p_name", sales.textBoxP_Name.Text);
Database.GetInstance().AddParameter("@p_start_date", sales.textBoxBeginDate.Text);
Database.GetInstance().AddParameter("@p_end_date", sales.textBoxEndDate.Text);
Database.GetInstance().AddParameter("@p_cost", sales.textBoxCost.Text);
Database.GetInstance().AddParameter("@p_terms", sales.textBoxTerms.Text);
Database.GetInstance().ExecuteQuery();
sales.tabControlSales.SelectedTab = sales.tabTemplateProjects;
sales.UpdateInfo();
}