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