public string UpdateCartProductQuantity()
{
int productId = -1;
String productColor = "";
String productSize = "";
int quantity = -1;
MemoryStream stream = new MemoryStream();
Request.Body.CopyTo(stream);
stream.Position = 0;
using (StreamReader reader = new StreamReader(stream))
{
string requestBody = reader.ReadToEnd();
if (requestBody.Length > 0)
{
var obj = JsonConvert.DeserializeObject <PostData>(requestBody);
if (obj != null)
{
productId = int.Parse(obj.productId);
productColor = obj.productColor;
productSize = obj.productSize;
quantity = int.Parse(obj.quantity);
}
}
}
double newPrice = CartProductManager.updateCartProductQuantity(productId, productColor, productSize, quantity);
return(newPrice + "-" + CartProductManager.getTotalPrice());
}
public string RemoveCartProduct()
{
int productId = -1;
string productColor = "";
string productSize = "";
MemoryStream stream = new MemoryStream();
Request.Body.CopyTo(stream);
stream.Position = 0;
using (StreamReader reader = new StreamReader(stream))
{
string requestBody = reader.ReadToEnd();
if (requestBody.Length > 0)
{
var obj = JsonConvert.DeserializeObject <PostData>(requestBody);
if (obj != null)
{
productId = int.Parse(obj.productId);
productColor = obj.productColor;
productSize = obj.productSize;
}
}
}
CartProductManager.removeProduct(productId, productColor, productSize);
double totalPrice = CartProductManager.getTotalPrice();
if (CartProductManager.getCount() == 0)
{
return("empty");
}
else
{
return("" + totalPrice);
}
}
public string Checkout()
{
string userid = HttpContext.Session.GetString("userid");
string shippingTo = "";
string orderNote = "";
MemoryStream stream = new MemoryStream();
Request.Body.CopyTo(stream);
stream.Position = 0;
using (StreamReader reader = new StreamReader(stream))
{
string requestBody = reader.ReadToEnd();
if (requestBody.Length > 0)
{
var obj = JsonConvert.DeserializeObject <PostData>(requestBody);
if (obj != null)
{
shippingTo = obj.shippingTo;
orderNote = obj.notetext;
}
}
}
double totalPrice = CartProductManager.getTotalPrice();
string dateString = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string orderStatus = "Paid";
List <CartProduct> products = CartProductManager.getCartProducts();
string orderid = "";
MySqlConnection connection = DBManager.getManager().getConnection();
MySqlCommand command = new MySqlCommand();
command.CommandText = "INSERT INTO orders(userid,totalprice,shippingto,orderdate,orderstatus,ordernote) VALUES(" + userid + "," + totalPrice + ",'" + shippingTo + "','" + dateString + "','" + orderStatus + "','" + orderNote + "');";
command.Connection = connection;
command.CommandType = System.Data.CommandType.Text;
int rows = command.ExecuteNonQuery();
if (rows <= 0)
{
return("false");
}
command.CommandText = "SELECT orderid FROM orders WHERE userid=" + userid + " AND orderdate='" + dateString + "'";
MySqlDataReader dataReader = command.ExecuteReader();
if (dataReader.Read())
{
orderid = dataReader.GetString("orderid");
dataReader.Close();
}
else
{
dataReader.Close();
return("false");
}
foreach (CartProduct cartProduct in products)
{
string productColor = "";
if (cartProduct.getProductColor() == "null")
{
productColor = "";
}
else
{
productColor = cartProduct.getProductColor();
}
string productSize = "";
if (cartProduct.getProductSize() == "null")
{
productSize = "";
}
else
{
productSize = cartProduct.getProductSize();
}
command.CommandText = "INSERT INTO order_product(orderid,productid,quantity,selectedcolor,selectedsize) VALUES(" + orderid + "," + cartProduct.getProductId() + "," + cartProduct.getQuantity() + ",'" + productColor + "','" + productSize + "');";
rows = command.ExecuteNonQuery();
if (rows <= 0)
{
return("false");
}
}
CartProductManager.clear();
return(orderid + "-" + totalPrice);
}