public static OnlineCosmeticShop constructXMLObject(IFormCollection formData) { OnlineCosmeticShop onlineCosmeticShop = new OnlineCosmeticShop(); onlineCosmeticShop.Name = formData["name"]; onlineCosmeticShop.Employees = new Employee[1]; Address address = new Address(formData["country"], formData["city"], formData["street"], Int16.Parse(formData["number"])); Employee employee = new Employee(formData["gender"], formData["employeeName"], address, Int16.Parse(formData["age"]), formData["position"], float.Parse(formData["salary"], CultureInfo.InvariantCulture.NumberFormat), formData["employeeEmail"], formData["employeePhone"]); onlineCosmeticShop.Employees[0] = employee; // TODO: implement functionality for adding more than one object: onlineCosmeticShop.Orders = new Order[1]; Order order = new Order(); onlineCosmeticShop.Orders[0] = order; Product product = new Product(Int16.Parse(formData["count"]), formData["customerName"], Int16.Parse(formData["code"]), formData["category"], formData["description"], float.Parse(formData["price"])); onlineCosmeticShop.Orders[0].Products = new Product[1]; onlineCosmeticShop.Orders[0].Products[0] = product; onlineCosmeticShop.Contacts = new Contact[1]; Contact contact = new Contact(formData["email"], formData["phone"], Int32.Parse(formData["fax"])); onlineCosmeticShop.Contacts[0] = contact; return(onlineCosmeticShop); }
public static bool fillDatabase(OnlineCosmeticShop onlineCosmeticShop) { try { using (SqlConnection sqlConnection = new SqlConnection("Server=localhost;Database=onlineshop;Trusted_Connection=True")) { sqlConnection.Open(); using (SqlCommand sqlCommand = new SqlCommand(getQueryString(onlineCosmeticShop.shopId, onlineCosmeticShop.Name))) { sqlCommand.Connection = sqlConnection; sqlCommand.ExecuteNonQuery(); } foreach (var employee in onlineCosmeticShop.Employees) { using (SqlCommand sqlCommand = new SqlCommand(getQueryString(employee))) { sqlCommand.Connection = sqlConnection; sqlCommand.ExecuteNonQuery(); } } foreach (var order in onlineCosmeticShop.Orders) { using (SqlCommand sqlCommand = new SqlCommand(getQueryString(order))) { sqlCommand.Connection = sqlConnection; sqlCommand.ExecuteNonQuery(); } foreach (var product in order.Products) { using (SqlCommand sqlCommand2 = new SqlCommand(getQueryString(product))) { sqlCommand2.Connection = sqlConnection; sqlCommand2.ExecuteNonQuery(); } using (SqlCommand sqlCommand1 = new SqlCommand(getQueryString(order.OrderId, product))) { sqlCommand1.Connection = sqlConnection; sqlCommand1.ExecuteNonQuery(); } } } foreach (var contact in onlineCosmeticShop.Contacts) { using (SqlCommand sqlCommand = new SqlCommand(getQueryString(contact))) { sqlCommand.Connection = sqlConnection; sqlCommand.ExecuteNonQuery(); } } } } catch (SqlException e) { Console.WriteLine(e); return(false); } return(true); }