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)); } }