public static bool CancelCart(int UserID)
{
var isCartDeleted = false;
DataSet result;
int ShoppingCartID = -1;
String query = "SELECT * from dbo.UserShoppingCart where UserID =" + UserID;
using (var db = DataAccessFactory.GetDAL(ConnectionString, "SQL"))
{
try
{
result = db.ExecuteSelectQuery(query);
ShoppingCartID = UserAccessViewModel.GetOrderPendingShoppingCartID(result.Tables[0]);
query = "DELETE from dbo.UserShoppingCart Where UserID =" + UserID + " and ShoppingCartID=" + ShoppingCartID;
db.ExecuteNonQuery(query);
query = "DELETE from dbo.ShoppingCartDetails Where ShoppingCartID=" + ShoppingCartID;
db.ExecuteNonQuery(query);
isCartDeleted = true;
}
catch (Exception)
{
isCartDeleted = false;
}
}
return(isCartDeleted);
}
public static ShoppingCart GetUserCartInfo(int UserID)
{
int ShoppingCartID = -1;
DataSet result, allProducts;
var UserShoppingCart = new ShoppingCart();
String query = "SELECT * from dbo.UserShoppingCart where UserID =" + UserID;
String allProductQuery = "SELECT * from dbo.JeevomProduct";
using (var db = DataAccessFactory.GetDAL(ConnectionString, "SQL"))
{
try
{
result = db.ExecuteSelectQuery(query);
allProducts = db.ExecuteSelectQuery(allProductQuery);
ShoppingCartID = UserAccessViewModel.GetOrderPendingShoppingCartID(result.Tables[0]);
UserShoppingCart.ShoppingCartId = ShoppingCartID;
if (ShoppingCartID != -1)
{
query = "SELECT * from dbo.ShoppingCartDetails where ShoppingCartID =" + ShoppingCartID;
result = db.ExecuteSelectQuery(query);
var CartProductInfo = from cartProduct in result.Tables[0].AsEnumerable()
join
productDetails in allProducts.Tables[0].AsEnumerable()
on Convert.ToInt32(cartProduct["ProductID"]) equals Convert.ToInt32(productDetails["ProductID"])
select new Product
{
ProductID = Convert.ToInt32(cartProduct["ProductID"]),
ProductName = Convert.ToString(productDetails["ProductName"]),
Price = Convert.ToDecimal(productDetails["Price"]),
UnitCount = Convert.ToInt32(cartProduct["UnitCount"])
};
UserShoppingCart.CartItems = CartProductInfo.ToList();
UserShoppingCart.CartTotalPrice = CartProductInfo.Sum(p => p.UnitCount * p.Price);
}
}
catch (Exception ex)
{
}
}
return(UserShoppingCart);
}
//public static void PlaceOrder(int UserID) {
// DataSet result;
// int ShoppingCartID = -1;
// String query = "SELECT * from dbo.UserShoppingCart where UserID =" + UserID;
// using (var db = DataAccessFactory.GetDAL(ConnectionString, "SQL"))
// {
// try
// {
// result = db.ExecuteSelectQuery(query);
// ShoppingCartID = UserAccessViewModel.GetOrderPendingShoppingCartID(result.Tables[0]);
// query = "UPDATE dbo.UserShoppingCart SET IsOrderPlaced = 'true' Where UserID =" + UserID + " and ShoppingCartID=" + ShoppingCartID;
// db.ExecuteNonQuery(query);
// }
// catch (Exception)
// {
// //
// }
// }
//}
public static bool PlaceOrder(int UserID)
{
var isOrderPlaced = false;
DataSet result;
int ShoppingCartID = -1;
String query = "UPDATE dbo.UserShoppingCart SET IsOrderPlaced = 'true' Where UserID =" + UserID + " and IsOrderPlaced='false'"; // it should be based on shoping cart id
using (var db = DataAccessFactory.GetDAL(ConnectionString, "SQL"))
{
try
{
result = db.ExecuteSelectQuery(query);
ShoppingCartID = UserAccessViewModel.GetOrderPendingShoppingCartID(result.Tables[0]);
db.ExecuteNonQuery(query);
isOrderPlaced = true;
}
catch (Exception)
{
isOrderPlaced = false;
}
return(isOrderPlaced);
}
}