//returns list with all characters from db
public static List <Taxation> GetTaxations(MySqlConnection _connection)
{
_connection.Open();
//retrieve from db
MySqlCommand command = _connection.CreateCommand();
command.CommandText = "SELECT * FROM `taxation`";
MySqlDataReader data = command.ExecuteReader();
List <Taxation> taxations = new List <Taxation>();
List <Enterprise> enterprises = EnterpriseDAO.GetEnterprises(_connection);
//read data from dataReader and form list of Character instances
while (data.Read())
{
Int64 id = Convert.ToInt64(data["id"]);
int taxation_group = Convert.ToInt32(data["taxation_group"]);
decimal max_revenue = Convert.ToDecimal(data["max_revenue"]);
int max_employee = Convert.ToInt32(data["max_employee"]);
double VAT = Convert.ToDouble(data["VAT"]);
double income_duty = Convert.ToDouble(data["income_duty"]);
Taxation taxation = new Taxation(id, taxation_group, max_revenue, max_employee,
VAT, income_duty);
Debug.Log("Get taxation " + id);
taxations.Add(taxation);
}
_connection.Close();
return(taxations);
}
public void RetrieveData()
{
ConnectionManager connectionManager = new ConnectionManager();
SellerDAO sellerDAO = new SellerDAO();
EnterpriseDAO enterpriseDAO = new EnterpriseDAO();
DirectorDAO directorDAO = new DirectorDAO();
NpgsqlConnection conn = connectionManager.getConnection();
enterpriseDAO.readAll(conn);
sellerDAO.readAll(conn);
directorDAO.readAll(conn);
sellerDAO.setEnterprisesToSellers(enterpriseDAO);
directorDAO.setEnterprisesToDirectors(enterpriseDAO);
listEnterprises = sellerDAO.readEmpresasInUse(listEnterprises);
listEnterprises = directorDAO.readEmpresasInUse(listEnterprises);
listDirectors = directorDAO.listDirectors;
listSellers = sellerDAO.listSellers;
conn.Close();
conn.Dispose();
}
private void button9_Click(object sender, EventArgs e)
{
try
{
if (textBox5.Text.Length > 0 && textBox6.Text.Length > 0)
{
EnterpriseDAO.addbusiness(textBox5.Text, textBox6.Text);
MessageBox.Show("¡Empresa agregad exitosamente!",
"CEGE APP", MessageBoxButtons.OK, MessageBoxIcon.Information);
textBox5.Clear();
textBox6.Clear();
actualizarControles();
}
else
{
MessageBox.Show("No deje espacios en blanco",
"CEGE APP", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
catch (Exception)
{
MessageBox.Show("El producto que ha digitado, no se encuentra disponible.",
"CEGE APP", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void actualizarControles()
{
List <Usuario> usu = UsuarioDAO.getLista();
List <Address> addr = AddressDAO.addresslist();
List <Order> ord = OrderDAO.orderlist();
List <Enterprise> ent = EnterpriseDAO.businesslist();
List <Product> prod = ProductDAO.productlist();
List <Address> propaddress = AddressDAO.idaddresslist(usuario.iduser);
List <Order> proporder = OrderDAO.iduserorder(usuario.iduser);
dataGridView1.DataSource = null;
dataGridView1.DataSource = propaddress;
dataGridView2.DataSource = null;
dataGridView2.DataSource = proporder;
comboBox1.DataSource = null;
comboBox1.DisplayMember = "idaddress";
comboBox1.DataSource = addr;
comboBox2.DataSource = null;
comboBox2.DisplayMember = "idaddress";
comboBox2.DataSource = addr;
comboBox3.DataSource = null;
comboBox3.DisplayMember = "idproduct";
comboBox3.DataSource = prod;
comboBox4.DataSource = null;
comboBox4.DisplayMember = "idorder";
comboBox4.DataSource = ord;
comboBox5.DataSource = null;
comboBox5.DisplayMember = "idbusiness";
comboBox5.DataSource = ent;
comboBox6.DataSource = null;
comboBox6.DisplayMember = "idbusiness";
comboBox6.DataSource = ent;
comboBox7.DataSource = null;
comboBox7.DisplayMember = "idproduct";
comboBox7.DataSource = prod;
comboBox8.DataSource = null;
comboBox8.DisplayMember = "idaddress";
comboBox8.DataSource = addr;
comboBox9.DataSource = null;
comboBox9.DisplayMember = "iduser";
comboBox9.DataSource = usu;
}
// Use this for initialization
void Start()
{
string source = "Server=localhost;" +
"Database=sts;" +
"User ID=root;" +
"Pooling=false;" +
"Password="******"tab1");
/*
* Project project = ProjectDAO.GetProjects(connection)[0];
* project.MakeProgress(connection, new DateTime(2014,05,15));
*/
/*AssetTest (connection);
* CharacterTest (connection);
* CompanyTest (connection);
* CompetitorTest (connection);
* DocumentTest (connection);
* EmployeeTest (connection);
* EnterpriseTest (connection);*/
/*Enterprise_docsTest (connection);
*
*
* Enterprise_equipmentTest (connection);
* EquipmentTest (connection);
* Human_resourcesTest (connection);
* ProductTest (connection);
* ProjectTest (connection);
* Project_stageTest (connection);
* PurchaseTest (connection);
* RevenueTest (connection);
* RoleTest (connection);
* Salary_paymentTest (connection);
* ServiceTest (connection);
* TaxationTest (connection);
* Team_memberTest (connection);*/
Enterprise e = new Enterprise(8, "MyEnterprise", 500.23M, 2.5, 0, 1);
Enterprise e1 = new Enterprise(9, "MyEnterprise", 500.23M, 2.5, 1, 1);
EnterpriseDAO.InsertEnterprises(connection, new List <Enterprise>()
{
e, e1
});
e.CompleteDocuments(connection);
e1.CompleteDocuments(connection);
}
private void button10_Click(object sender, EventArgs e)
{
if (MessageBox.Show("¿Seguro que desea eliminar la empresa" + comboBox5.Text + "?",
"CEGE APP", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
EnterpriseDAO.eliminar(comboBox5.Text);
MessageBox.Show("¡Empresa eliminada exitosamente!",
"CEGE APP", MessageBoxButtons.OK, MessageBoxIcon.Information);
actualizarControles();
}
}
void EnterpriseTest(MySqlConnection connection)
{
List <Enterprise> enterprises = new List <Enterprise>();
enterprises.Add(new Enterprise(2, "MyEnterprise", 500.23M, 2.5, 4, 1));
EnterpriseDAO.InsertEnterprises(connection, enterprises);
List <Enterprise> enterprises2 = EnterpriseDAO.GetEnterprises(connection);
enterprises2[1].Title = "NewInterpise";
EnterpriseDAO.UpdateEnterprises(connection, enterprises2);
enterprises2 = EnterpriseDAO.GetEnterprises(connection);
EnterpriseDAO.DeleteEnterprises(connection, enterprises);
enterprises2 = EnterpriseDAO.GetEnterprises(connection);
}
