public void dbInsertShoppingCart(ShoppingCartDetails shoppingCart)
{
var groceryAmount = dbShopingCartExicst(shoppingCart);
if (groceryAmount != -1)
{
float proslediAmount = shoppingCart.Amount + groceryAmount;
dbUpdateShoppingCart(proslediAmount, shoppingCart.Grocery.Name, shoppingCart.GroupID);
}
else
{
if (con.State != System.Data.ConnectionState.Open)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("INSERT INTO [ShoppingCart] (Amount,GroceryName,GroupID) VALUES(@Amount,@GroceryName,@GroupID)", con);
cmd.Parameters.Add("@Amount", SqlDbType.Float).Value = shoppingCart.Amount;
cmd.Parameters.Add("@GroceryName", SqlDbType.VarChar).Value = shoppingCart.Grocery.Name;
cmd.Parameters.Add("@GroupID", SqlDbType.VarChar).Value = shoppingCart.GroupID;
int test = cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
}
con.Close();
}
public float dbShopingCartExicst(ShoppingCartDetails shoppingCart)
{
if (con.State != System.Data.ConnectionState.Open)
{
con.Open();
}
SqlCommand command = new SqlCommand("SELECT * FROM [ShoppingCart] WHERE GroceryName=@GroceryName AND GroupID=@GroupID", con);
command.Parameters.Add("@GroceryName", SqlDbType.VarChar).Value = shoppingCart.Grocery.Name;
command.Parameters.Add("@GroupID", SqlDbType.VarChar).Value = shoppingCart.GroupID;
SqlDataReader reader = command.ExecuteReader();
if (reader.Read() == true)
{
float prosledi = float.Parse(reader.GetValue(0).ToString());
reader.Close();
command.Dispose();
con.Close();
return(prosledi);
}
reader.Close();
command.Dispose();
con.Close();
return(-1);
}
public List <ShoppingCartDetails> dbGetShoppingCart(string id)
{
if (con.State != System.Data.ConnectionState.Open)
{
con.Open();
}
List <ShoppingCartDetails> listShoppingCartDetails = new List <ShoppingCartDetails>();
SqlCommand cmd = new SqlCommand("SELECT * FROM [ShoppingCart] INNER JOIN [Groceries] ON ShoppingCart.GroceryName=Groceries.Name WHERE GroupID=@id", con);
cmd.Parameters.Add("@id", System.Data.SqlDbType.VarChar).Value = id;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ShoppingCartDetails shoppingCart = new ShoppingCartDetails();
GroceryDetails grocery = new GroceryDetails();
shoppingCart.Amount = float.Parse(reader.GetValue(0).ToString());
shoppingCart.GroupID = reader.GetValue(2).ToString();
grocery.Name = reader.GetValue(3).ToString();
grocery.Image = null;
grocery.Unit = reader.GetValue(5).ToString();
grocery.Category = reader.GetValue(6).ToString();
shoppingCart.Grocery = grocery;
listShoppingCartDetails.Add(shoppingCart);
}
reader.Close();
cmd.Dispose();
con.Close();
return(listShoppingCartDetails);
}