public CartDataModel GetCartById(int Id)
{
CartDataModel obj_CF = new CartDataModel();
List <KeyValuePair <string, string> > getByID_Parameters = new List <KeyValuePair <string, string> >();
getByID_Parameters.Add(new KeyValuePair <string, string>("@Id", Convert.ToString(Id)));
obj_CF = JsonConvert.DeserializeObject <CartDataModel>(obj_Cart_DAL.GetByID(getByID_Parameters));
return(obj_CF);
}
public static int CloseCart(int userId)
{
CartDataModel model = GetOpenCart(userId);
if (model != null) //Adding products to open cart
{
string sql = "UPDATE [dbo].[Cart] SET [IsOpen] = 0 WHERE [UserId]=@UserId";
return(SQLDataAccess.SaveData(sql, model));
}
else
{
return(0);
}
}
public string InsertCart(string UserId, CartDataModel C_Model)
{
string result = "";
List <KeyValuePair <string, string> > insert_Parameters = new List <KeyValuePair <string, string> >();
insert_Parameters.Add(new KeyValuePair <string, string>("@Customer_ID", Convert.ToString(UserId)));
insert_Parameters.Add(new KeyValuePair <string, string>("@Product_ID", Convert.ToString(C_Model.Product_ID)));
insert_Parameters.Add(new KeyValuePair <string, string>("@ProductSku_ID", Convert.ToString(C_Model.ProductSku_ID)));
insert_Parameters.Add(new KeyValuePair <string, string>("@Unit", Convert.ToString(C_Model.Unit)));
insert_Parameters.Add(new KeyValuePair <string, string>("@Quantity", Convert.ToString(C_Model.Quantity)));
insert_Parameters.Add(new KeyValuePair <string, string>("@Amount", Convert.ToString(C_Model.Amount)));
insert_Parameters.Add(new KeyValuePair <string, string>("@Discount", Convert.ToString(C_Model.Discount)));
result = obj_Cart_DAL.Insert(insert_Parameters);
return(result);
}
public static List <CartProductsDataModel> LoadCartProducts(int userId)
{
CartDataModel model = GetOpenCart(userId);
if (model != null) //Adding products to open cart
{
string sql = @"SELECT TOP (1000) [Id]
,[CartId]
,[ProductId]
,[ProductQty]
,[ProductPrice]
,[AddedDate]
FROM [dbo].[CartProducts] where [CartId]=" + model.Id;
return(SQLDataAccess.LoadData <CartProductsDataModel>(sql));
}
else
{
return(null);
}
}
public static int DeleteProductFromCart(int productId, int userId)
{
CartDataModel model = GetOpenCart(userId);
if (model != null) //Adding products to open cart
{
CartProductsDataModel data = new CartProductsDataModel
{
ProductId = productId,
CartId = model.Id
};
string sql = @"delete FROM [dbo].[CartProducts] where CartId=@CartId and ProductId=@ProductId";
return(SQLDataAccess.SaveData(sql, data));
}
else
{
return(0);
}
}
public static int CreateNewOrder(int UserId, string Name, string CompanyName, string Address,
string City, string State, string Zip, DateTime DateCreated)
{
//Saving Order Header
OrderDataModel orderDataModel = new OrderDataModel
{
UserId = UserId,
Name = Name,
CompanyName = CompanyName,
Address = Address,
City = City,
State = State,
Zip = Zip,
DateCreated = DateCreated
};
string sql = @"INSERT INTO [dbo].[Order]
([UserId]
,[Name]
,[CompanyName]
,[Address]
,[City]
,[State]
,[Zip]
,[DateCreated])
VALUES
(@UserId
,@Name
,@CompanyName
,@Address
,@City
,@State
,@Zip
,@DateCreated)";
SQLDataAccess.SaveData(sql, orderDataModel);
OrderDataModel newOrder = GetOrder(UserId);
CartDataModel openCart = CartProcessor.GetOpenCart(UserId);
List <CartProductsDataModel> cartProducts = CartProcessor.LoadCartProducts(UserId);
//Saving order details
foreach (var product in cartProducts)
{
OrderProductsDataModel orderProducts = new OrderProductsDataModel
{
OrderId = newOrder.Id,
ProductId = product.ProductId,
ProductDescription = ProductProcessor.GetProduct(product.ProductId).Description,
ProductQty = product.ProductQty,
ProductPrice = product.ProductPrice,
ProductImagePath = ProductProcessor.GetProduct(product.ProductId).ImagePath,
ProductCode = ""
};
sql = @"INSERT INTO [dbo].[OrderProducts]
([OrderId]
,[ProductId]
,[ProductCode]
,[ProductDescription]
,[ProductImagePath]
,[ProductQty]
,[ProductPrice])
VALUES
(@OrderId
,@ProductId
,@ProductCode
,@ProductDescription
,@ProductImagePath
,@ProductQty
,@ProductPrice)";
SQLDataAccess.SaveData(sql, orderProducts);
}
//Closing user cart
CartProcessor.CloseCart(UserId);
return(newOrder.Id);
}
public Cart_ViewModel()
{
cart_DataModel = new CartDataModel();
lst_CartDataModel = new List <CartDataModel>();
}
public static int AddProductToCart(int userId, int productId, int productQty, float productPrice)
{
CartDataModel model = GetOpenCart(userId);
if (model != null) //Adding products to open cart
{
CartProductsDataModel data = new CartProductsDataModel
{
CartId = model.Id,
ProductId = productId,
ProductQty = productQty,
ProductPrice = productPrice,
AddedDate = DateTime.Now
};
string sql = @"INSERT INTO [dbo].[CartProducts]
([CartId]
,[ProductId]
,[ProductQty]
,[ProductPrice]
,[AddedDate])
VALUES
(@CartId
,@ProductId
,@ProductQty
,@ProductPrice
,@AddedDate)";
return(SQLDataAccess.SaveData(sql, data));
}
else //Saving New Cart
{
CartDataModel cartData = new CartDataModel
{
UserId = userId,
IsOpen = true,
DateCreated = DateTime.Now
};
string sql = @"INSERT INTO [dbo].[Cart]
([UserId]
,[IsOpen]
,[DateCreated])
VALUES
(@UserId
,@IsOpen
,@DateCreated)";
SQLDataAccess.SaveData(sql, cartData);
CartDataModel newCart = GetOpenCart(userId);
CartProductsDataModel data = new CartProductsDataModel
{
CartId = newCart.Id,
ProductId = productId,
ProductQty = productQty,
ProductPrice = productPrice,
AddedDate = DateTime.Now
};
sql = @"INSERT INTO [dbo].[CartProducts]
([CartId]
,[ProductId]
,[ProductQty]
,[ProductPrice]
,[AddedDate])
VALUES
(@CartId
,@ProductId
,@ProductQty
,@ProductPrice
,@AddedDate)";
return(SQLDataAccess.SaveData(sql, data));
}
}
