public int Add(int ProdID, string ItemName, double ItemPrice, int Stock, byte[] Image, string Category)
{
EShoppingDBConnect aEShoppingConn = new EShoppingDBConnect();
string sql = "Insert INTO Products values (@ProdId, @ItemName, @ItemPrice, @Stock, @Image, @Category)";
SqlParameter param1 = new SqlParameter("@ProdId", SqlDbType.Int);
param1.Value = ProdID;
SqlParameter param2 = new SqlParameter("@ItemName", SqlDbType.Text);
param2.Value = ItemName;
SqlParameter param3 = new SqlParameter("@ItemPrice", SqlDbType.Decimal);
param3.Value = ItemPrice;
SqlParameter param4 = new SqlParameter("@Stock", SqlDbType.Int);
param4.Value = Stock;
SqlParameter param5 = new SqlParameter("@Image", SqlDbType.Image);
param5.Value = Image;
SqlParameter param6 = new SqlParameter("@Category", SqlDbType.Text);
param6.Value = Category;
try
{
return(aEShoppingConn.ExecuteNonQuery(sql, CommandType.Text, param1, param2, param3, param4, param5, param6));
}
catch (Exception ex)
{
LastError = ex.Message;
return(-1);
}
}
public int Add(string Username, string Password, string Email, string Name, string Address, string City, int Zipcode, long PhNum)
{
EShoppingDBConnect aEShoppingConn = new EShoppingDBConnect();
string sql = "Insert INTO Customers values (@Username, @Password, @Email, @Name, @Address, @City, @Zipcode, @PhNum)";
SqlParameter param1 = new SqlParameter("@Username", SqlDbType.Text);
param1.Value = Username;
SqlParameter param2 = new SqlParameter("@Password", SqlDbType.Text);
param2.Value = Password;
SqlParameter param3 = new SqlParameter("@Email", SqlDbType.Text);
param3.Value = Email;
SqlParameter param4 = new SqlParameter("@Name", SqlDbType.Text);
param4.Value = Name;
SqlParameter param5 = new SqlParameter("@Address", SqlDbType.Text);
param5.Value = Address;
SqlParameter param6 = new SqlParameter("@City", SqlDbType.Text);
param6.Value = City;
SqlParameter param7 = new SqlParameter("@Zipcode", SqlDbType.Decimal);
param7.Value = Zipcode;
SqlParameter param8 = new SqlParameter("@PhNum", SqlDbType.Decimal);
param8.Value = PhNum;
try
{
return(aEShoppingConn.ExecuteNonQuery(sql, CommandType.Text, param1, param2, param3, param4, param5, param6, param7, param8));
}
catch (Exception ex)
{
LastError = ex.Message;
return(-1);
}
}
public int UpdateProduct(double newPrice, int newStock, int prodID)
{
try
{
EShoppingDBConnect aEShoppingConn = new EShoppingDBConnect();
string query = "update Products set Stock = @newStock, ItemPrice = @newPrice " +
"where ProdID = @ID";
SqlParameter param1 = new SqlParameter("@ID", SqlDbType.Int);
param1.Value = prodID;
SqlParameter param2 = new SqlParameter("@newPrice", SqlDbType.Decimal);
param2.Value = newPrice;
SqlParameter param3 = new SqlParameter("@newStock", SqlDbType.Int);
param3.Value = newStock;
return(aEShoppingConn.ExecuteNonQuery(query, CommandType.Text, param1, param2, param3));
}
catch (Exception ex)
{
LastError = ex.Message;
return(-1);
}
}
