// Insert Product \ public int InsertProduct(CProduct Product) { try { SqlConnection Connection = null; if (OpenDBConnection(ref Connection) == 0) { SqlCommand Command = new SqlCommand("uspAddProduct", Connection); int intID = -1; SetParameter(ref Command, "@intProductID", 0, SqlDbType.Int, Direction: ParameterDirection.Output); SetParameter(ref Command, "@strTitle", Product.Title, SqlDbType.VarChar); SetParameter(ref Command, "@strDescription", Product.Description, SqlDbType.VarChar); SetParameter(ref Command, "@intPrice", Product.Price, SqlDbType.Int); SetParameter(ref Command, "@intStatusID", Product.StatusID, SqlDbType.Int); SetParameter(ref Command, "@intCategoryID", Product.CategoryID, SqlDbType.Int); Command.ExecuteReader(); intID = (int)Command.Parameters["@intProductID"].Value; Product.ProductID = intID; CloseDBConnection(ref Connection); return(0); // Success } else { return(-1); } } catch (Exception ex) { throw new Exception(ex.Message); } }
// Update Product \ public int UpdateProduct(CProduct Product) { try { SqlConnection Connection = null; if (OpenDBConnection(ref Connection) == 0) { SqlCommand cm = new SqlCommand("uspEditProduct", Connection); SetParameter(ref cm, "@intProductID", Product.ProductID, SqlDbType.Int); SetParameter(ref cm, "@intCategoryID", Product.CategoryID, SqlDbType.Int); SetParameter(ref cm, "@strTitle", Product.Title, SqlDbType.VarChar); SetParameter(ref cm, "@strDescription", Product.Description, SqlDbType.VarChar); SetParameter(ref cm, "@intPrice", Product.Price, SqlDbType.Int); SetParameter(ref cm, "@intStatusID", Product.StatusID, SqlDbType.Int); cm.ExecuteReader(); CloseDBConnection(ref Connection); return(0); // Success } else { return(-1); // No database connection } } catch (Exception ex) { throw new Exception(ex.Message); } }
// Get Product List \ public List <CProduct> GetProducts(int intProductID = 0, int intCategoryID = -1) { SqlConnection Connection = new SqlConnection(); List <CProduct> ProductList = new List <CProduct>(); try { if (OpenDBConnection(ref Connection) == 0) { SqlDataAdapter da = new SqlDataAdapter("uspSelectProduct", Connection); da.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure; DataSet ds = new DataSet(); int intStatusID; if (intProductID != 0) { SetParameter(ref da, "@intProductID", intProductID, SqlDbType.Int); } if (intCategoryID > -1) { SetParameter(ref da, "@intCategoryID", intCategoryID, SqlDbType.Int); } try { da.Fill(ds); foreach (DataTable dt in ds.Tables) { foreach (DataRow dr in dt.Rows) { CProduct Product = new CProduct(); Product.ProductID = Convert.ToInt32((dr["intProductID"])); Product.Title = (dr["strTitle"]).ToString(); Product.Description = (dr["strDescription"]).ToString(); Product.Price = Convert.ToDouble((dr["intPrice"])); Product.CategoryID = Convert.ToInt32((dr["intCategoryID"])); Product.PrimaryImage = GetPrimaryImage(Product.ProductID); Product.intStockAmount = Convert.ToInt32((dr["intStockAmount"])); ProductList.Add(Product); } } } finally { CloseDBConnection(ref Connection); } } return(ProductList); } catch (Exception ex) { throw new Exception(ex.Message); } }
public List <CProduct> GetCart(int intUserID) { try { SqlConnection Connection = null; CProduct Product = new CProduct(); List <CProduct> Cart = new List <CProduct>(); int intProductID = 0; if (OpenDBConnection(ref Connection) == 0) { SqlDataAdapter da = new SqlDataAdapter("uspGetCart", Connection); da.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure; DataSet ds = new DataSet(); SetParameter(ref da, "@intUserID", intUserID, SqlDbType.Int); da.Fill(ds); foreach (DataTable dt in ds.Tables) { foreach (DataRow dr in dt.Rows) { intProductID = (int)dr["intProductID"]; Product = GetProduct(intProductID); Cart.Add(Product); } } } CloseDBConnection(ref Connection); return(Cart); } catch (Exception ex) { throw new Exception(ex.Message); } }
public void Products() { CProduct ProductList = new CProduct(); }
// Get Product List \ public List <CProduct> GetProducts(int intProductID = 0) { SqlConnection Connection = new SqlConnection(); List <CProduct> ProductList = new List <CProduct>(); try { if (OpenDBConnection(ref Connection) == 0) { SqlDataAdapter da = new SqlDataAdapter("uspSelectProduct", Connection); da.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure; DataSet ds = new DataSet(); int intCategoryID; int intStatusID; if (intProductID != 0) { SetParameter(ref da, "@intProductID", intProductID, SqlDbType.Int); } try { da.Fill(ds); foreach (DataTable dt in ds.Tables) { foreach (DataRow dr in dt.Rows) { CProduct Product = new CProduct(); Product.ProductID = Convert.ToInt32((dr["intProductID"])); Product.Title = (dr["strTitle"]).ToString(); Product.Description = (dr["strDescription"]).ToString(); Product.Price = Convert.ToDouble((dr["intPrice"])); intStatusID = Convert.ToInt32((dr["intStatusID"])); intCategoryID = Convert.ToInt32((dr["intCategoryID"])); Product.PrimaryImage = GetPrimaryImage(Product.ProductID); switch (intStatusID) { case 0: Product.StatusID = StatusTypes.Unknown; break; case 1: Product.StatusID = StatusTypes.Active; break; case 2: Product.StatusID = StatusTypes.Sold; break; case 3: Product.StatusID = StatusTypes.Closed; break; } switch (intCategoryID) { case 0: Product.CategoryID = ProductTypes.Unknown; break; case 1: Product.CategoryID = ProductTypes.Necklace; break; case 2: Product.CategoryID = ProductTypes.Bracelet; break; case 3: Product.CategoryID = ProductTypes.Earring; break; case 4: Product.CategoryID = ProductTypes.Ring; break; case 5: Product.CategoryID = ProductTypes.Other; break; } ProductList.Add(Product); } } } finally { CloseDBConnection(ref Connection); } } return(ProductList); } catch (Exception ex) { throw new Exception(ex.Message); } }