public bool CartItemsInsertProduct(DataCartItems cartItems)
{
bool noError = true;
try
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open();
using (SqlCommand command = new SqlCommand("dbo.sp_CartItemsInsertProduct", connection))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue("@UserID", cartItems.UserID);
command.Parameters.AddWithValue("@ProductID", cartItems.ProductID);
command.Parameters.AddWithValue("@Quantity", cartItems.CartItemQuantity);
command.ExecuteNonQuery();
connection.Close();
connection.Dispose();
}
}
}
catch (Exception exception)
{
Logger.LogError(exception);
noError = false;
}
return(noError);
}
public List <DataCartItems> Map(List <ModelCart> modelCartItems)
{
List <DataCartItems> dCartItems = new List <DataCartItems>();
foreach (ModelCart mItems in modelCartItems)
{
DataCartItems DataItem = new DataCartItems();
DataItem.ProductID = mItems.ProductID;
DataItem.SupplierID = mItems.SupplierID;
DataItem.BrandID = mItems.BrandID;
DataItem.UserID = mItems.UserID;
DataItem.InStockQuantity = mItems.InStockQuantity;
DataItem.CartItemQuantity = mItems.CartItemQuantity;
DataItem.RetailPrice = mItems.RetailPrice;
DataItem.WholeSalePrice = mItems.WholeSalePrice;
DataItem.ProductName = mItems.ProductName;
DataItem.BrandName = mItems.BrandName;
DataItem.SupplierName = mItems.SupplierName;
DataItem.ProductPhotoURL = mItems.ProductPhotoURL;
DataItem.Description = mItems.Description;
DataItem.OnSale = mItems.OnSale;
dCartItems.Add(DataItem);
}
return(dCartItems);
}
public List <DataCartItems> GetCartItems(int UserID)
{
List <DataCartItems> cartItems = new List <DataCartItems>();
try
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open();
using (SqlCommand command = new SqlCommand("dbo.sp_CartItemsGetAllByUserID", connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@UserID", UserID);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
DataCartItems dCartItem = new DataCartItems();
dCartItem.ProductID = reader.GetInt32(0);
dCartItem.ProductName = reader.GetString(1);
dCartItem.SupplierID = reader.GetInt32(2);
dCartItem.OnSale = reader.GetBoolean(3);
dCartItem.Description = reader.GetString(4);
dCartItem.RetailPrice = reader.GetDecimal(5);
dCartItem.WholeSalePrice = reader.GetDecimal(6);
dCartItem.ProductPhotoURL = reader.GetString(7);
dCartItem.BrandID = reader.GetInt32(8);
dCartItem.BrandName = reader.GetString(9);
dCartItem.BrandPhotoURL = reader.GetString(10);
dCartItem.SupplierName = reader.GetString(11);
dCartItem.UserID = reader.GetInt32(12);
dCartItem.InStockQuantity = reader.GetInt32(13);
dCartItem.CartItemQuantity = reader.GetInt32(14);
cartItems.Add(dCartItem);
}
}
}
}
catch (Exception exception)
{
Logger.LogError(exception);
}
return(cartItems);
}
public DataCartItems Map(ModelCart mCartItem)
{
DataCartItems dCartItem = new DataCartItems();
dCartItem.ProductID = mCartItem.ProductID;
dCartItem.SupplierID = mCartItem.SupplierID;
dCartItem.BrandID = mCartItem.BrandID;
dCartItem.UserID = mCartItem.UserID;
dCartItem.InStockQuantity = mCartItem.InStockQuantity;
dCartItem.CartItemQuantity = mCartItem.CartItemQuantity;
dCartItem.RetailPrice = mCartItem.RetailPrice;
dCartItem.WholeSalePrice = mCartItem.WholeSalePrice;
dCartItem.ProductName = mCartItem.ProductName;
dCartItem.BrandName = mCartItem.BrandName;
dCartItem.SupplierName = mCartItem.SupplierName;
dCartItem.ProductPhotoURL = mCartItem.ProductPhotoURL;
dCartItem.Description = mCartItem.Description;
dCartItem.OnSale = mCartItem.OnSale;
return(dCartItem);
}
