public bool UpdateQuantityInCart(ProductCartModel productCartModel)
{
var productCartEntity = new ProductCartDTO();
var productCartRepository = new ProductCartRepository();
AutoMapper.Mapper.Map(productCartModel, productCartEntity);
var status = productCartRepository.UpdateQuantityInCart(productCartEntity);
return status;
}
public bool InsertProductCart(ProductCartModel productCartModel)
{
var productCartEntity = new ProductCartDTO();
var productCartRepository = new ProductCartRepository();
AutoMapper.Mapper.Map(productCartModel, productCartEntity);
bool status = productCartRepository.InsertProductCart(productCartEntity);
return status;
}
public bool InsertProductCart(ProductCartDTO productCart)
{
SqlParameter[] _sqlParams = new SqlParameter[]
{
new SqlParameter("@Id", productCart.Id),
new SqlParameter("@ProductId", productCart.ProductId),
new SqlParameter("@Quantity", productCart.Quantity),
new SqlParameter("@CartId", productCart.CartId),
new SqlParameter("@ReturnValue", SqlDbType.SmallInt)
};
_sqlParams[4].Direction = ParameterDirection.Output;
SqlHelper.ExecuteNonQuery(ConnectionClass.OpenConnection(), CommandType.StoredProcedure,
AppConstants.INSERTPRODUCTCART, _sqlParams);
Int16 returnValue = Convert.ToInt16(_sqlParams[4].Value);
bool status = returnValue > 0 ? true : false;
return status;
}
private ProductCartDTO PopulateCartItems(IDataRecord dataRecord)
{
ProductCartDTO productCart = new ProductCartDTO();
productCart.Id = Convert.ToInt32(dataRecord["Id"]);
productCart.ProductId = Convert.ToInt32(dataRecord["ProductId"]);
productCart.CartId = new Guid(Convert.ToString(dataRecord["CartId"]));
productCart.CategoryName = Convert.ToString(dataRecord["CategoryName"]);
productCart.ImageUrl = Convert.ToString(dataRecord["ImageURL"]);
productCart.Quantity = Convert.ToInt32(dataRecord["Quantity"]);
productCart.UnitPrice = Convert.ToDecimal(dataRecord["UnitPrice"]);
productCart.Price = Convert.ToDecimal(dataRecord["Price"]);
return productCart;
}