//takes a order obj and put it in the database
public void CustumerOrder(ClassLibrary.Order order)
{
var client = new RestClient(localHost);
var request = new RestRequest("api/values/{id}", Method.POST);
request.AddJsonBody(order);
client.Execute(request);
//Vad gör den här raden? - inget
}
public void AddOrder(ClassLibrary.Order order)
{
int Id = 0;
string cmdEmailExist = @"select * From Person where Email='" + order.person.Email + "'";
string selectIdFomEmail = @"select id From Person where Email='" + order.person.Email + "'";
string insertPerson = @"insert into Person(FirstName,LastName,Adress,[Zip-Code],City,Email) Values (";
string createOrder = @"insert into WebOrder(CustumerID,DeliveryDate,CommentOnDelivery)";
string joinProdOrder = @"insert into JoinProductOrder(ProductId,WebOderId,Amount) Values ";
string items = "";
using (var connection = new SqlConnection(connectionString))
{
connection.Open();
if (connection.Query <ClassLibrary.Person>(cmdEmailExist).ToList().Count() > 0)
{
var Personid = connection.Query <int>(selectIdFomEmail).ToList();
Id = int.Parse(Personid[0].ToString());
connection.Query <int>(createOrder + "Values('" + Id + "','" + order.delivery.DeliveryDate + "','" + order.delivery.CommentOnDelivery + "')");
var WebOrderId = connection.Query <int>("SELECT IDENT_CURRENT ('WebOrder') AS Current_Identity").First();
for (int i = 0; i < order.cart.Count; i++)
{
items += "(" + order.cart[i].Product.Id + "," + WebOrderId.ToString() + "," + order.cart[i].Amount + "),";
}
connection.Query <int>(joinProdOrder + items.Substring(0, items.Length - 1));
}
else
{
connection.Query(insertPerson + "'" + order.person.FirstName + "','" + order.person.LastName + "','" + order.person.Adress + "','" +
order.person.ZipCode + "','" + order.person.City + "','" + order.person.Email + "')");
var Personid = connection.Query <int>(selectIdFomEmail).ToList();
Id = int.Parse(Personid[0].ToString());
connection.Query <int>(createOrder + "Values('" + Id + "','" + order.delivery.DeliveryDate + "','" + order.delivery.CommentOnDelivery + "')");
var WebOrderId = connection.Query <int>("SELECT IDENT_CURRENT ('WebOrder') AS Current_Identity").First();
for (int i = 0; i < order.cart.Count; i++)
{
items += "(" + order.cart[i].Product.Id + "," + WebOrderId.ToString() + "," + order.cart[i].Amount + "),";
}
connection.Query <int>(joinProdOrder + items.Substring(0, items.Length - 1));
}
}
}
public void Post([FromBody] ClassLibrary.Order order)
{
db.AddOrder(order);
}
