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