/// <summary>
///
/// </summary>
/// <returns></returns>
public static List <CustomerOrders> LoadOrders()
{
List <CustomerOrders> customerOrders = new List <CustomerOrders>();
using (SqlConnection con = SQLDBManager.GetCustomerConnection())
{
using (SqlCommand command = con.CreateCommand())
{
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
command.CommandType = CommandType.Text;
command.CommandText = "SELECT * FROM Customer";
var reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
var order = new CustomerOrders
{
Customer = new Customer
{
Name = reader["Name"].ToString(),
Country = reader["Country"].ToString(),
DateOfBirth = Convert.ToDateTime(reader["DateOfBirth"].ToString())
}
};
order.Orders.AddRange(orderRepository.LoadOrders(Convert.ToInt32(reader["CustomerId"].ToString())).Result);
customerOrders.Add(order);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
con.Close();
}
}
}
return(customerOrders);
}
/// <summary>
///
/// </summary>
/// <param name="customerId"></param>
/// <returns></returns>
public static Customer Load(int customerId)
{
using (SqlConnection con = SQLDBManager.GetCustomerConnection())
{
try
{
using (SqlCommand command = con.CreateCommand())
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
command.CommandType = CommandType.Text;
command.CommandText = "SELECT * FROM Customer WHERE CustomerId = " + customerId;
var reader = command.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
var customer = new Customer
{
Name = reader["Name"].ToString(),
DateOfBirth = DateTime.Parse(reader["DateOfBirth"].ToString()),
Country = reader["Country"].ToString()
};
return(customer);
}
else
{
return(null);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(null);
}
finally
{
con.Close();
}
}
}
/// <summary>
///
/// </summary>
/// <param name="customerId"></param>
/// <returns></returns>
public async Task <List <Order> > LoadOrders(int customerId)
{
List <Order> customerOrders = new List <Order>();
using (SqlConnection con = SQLDBManager.GetOrderConnection())
{
using (SqlCommand command = con.CreateCommand())
{
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
command.CommandType = CommandType.Text;
command.CommandText = "SELECT * FROM Orders WHERE CustomerId = " + customerId;
var reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
customerOrders.Add(new Order
{
OrderId = Convert.ToInt32(reader["OrderId"].ToString()),
Amount = Convert.ToDouble(reader["Amount"].ToString()),
VAT = Convert.ToDouble(reader["VAT"].ToString())
});
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
return(customerOrders);
}
IEnumerator SavePlayerData()
{
WWWForm form = new WWWForm();
form.AddField("name", SQLDBManager.username);
form.AddField("score", SQLDBManager.score);
WWW www = new WWW("http://localhost/sqlconnect/savedata.php", form);
yield return(www);
if (www.text[0] == '0')
{
Debug.Log("Game Saved .");
}
else
{
Debug.Log("Save failed. Error #" + www.text);
}
SQLDBManager.LogOut();
UnityEngine.SceneManagement.SceneManager.LoadScene("SQLMainMenu");
}
/// <summary>
/// Saves customer order details
/// </summary>
/// <param name="order"></param>
/// <returns></returns>
public async Task <bool> Save(Order order, int customerId)
{
using (SqlConnection con = SQLDBManager.GetOrderConnection())
{
try
{
using (SqlCommand command = con.CreateCommand())
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
command.CommandType = CommandType.Text;
command.CommandText = "INSERT INTO Orders VALUES (@OrderId, @CustomerId, @Amount, @VAT)";
command.Parameters.AddWithValue("@OrderId", order.OrderId);
command.Parameters.AddWithValue("@CustomerId", customerId);
command.Parameters.AddWithValue("@Amount", order.Amount);
command.Parameters.AddWithValue("@VAT", order.VAT);
//implement async
command.ExecuteNonQuery();
}
return(true);
}
catch (System.Exception ex)
{
return(false);
}
finally
{
con.Close();
}
}
}
