public Boolean updateInventoryPurchaseInfo(InventoryPurchaseInfo inventoryPurchaseInfo)
{
Boolean success = false;
using (OleDbConnection sqlconn = new OleDbConnection(database))
{
try
{
sqlconn.Open();
OleDbCommand cmd = sqlconn.CreateCommand();
String update = "UPDATE [INVENTORY_PURCHASE_INFO] SET [manufacturer_id] = @manufacturerId, [min_inventory] = @minInventory WHERE [inventory_id] = @inventoryId";
cmd.CommandText = update;
cmd.Parameters.Add("manufacturerId", OleDbType.Integer).Value = inventoryPurchaseInfo.manufacturerId;
cmd.Parameters.Add("minInventory", OleDbType.Integer).Value = inventoryPurchaseInfo.minInventory;
cmd.Parameters.Add("inventoryId", OleDbType.Integer).Value = inventoryPurchaseInfo.inventoryItemId;
int rows = cmd.ExecuteNonQuery();
if (rows == 1)
{
success = true;
}
return(success);
}
catch (OleDbException ex)
{
return(success);
}
finally
{
sqlconn.Close();
}
}
}
public List <InventoryPurchaseInfo> getAllInventoryPurchaseInfo()
{
List <InventoryPurchaseInfo> allInventoryPurchaseInfo = new List <InventoryPurchaseInfo>();
using (OleDbConnection sqlconn = new OleDbConnection(database))
{
try
{
sqlconn.Open();
OleDbCommand cmd = sqlconn.CreateCommand();
String select = "SELECT [inventory_item_id] FROM [INVENTORY_PURCHASE_INFO]";
cmd.CommandText = select;
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
InventoryPurchaseInfo purchaseInfo = getSingleInventoryPurchaseInfo((int)reader["inventory_item_id"]);
allInventoryPurchaseInfo.Add(purchaseInfo);
}
return(allInventoryPurchaseInfo);
}
catch (OleDbException ex)
{
return(allInventoryPurchaseInfo);
}
finally
{
sqlconn.Close();
}
}
}
public InventoryPurchaseInfo getSingleInventoryPurchaseInfo(int inventoryId)
{
InventoryPurchaseInfo inventoryPurchaseInfo = new InventoryPurchaseInfo();
using (OleDbConnection sqlconn = new OleDbConnection(database))
{
try
{
sqlconn.Open();
OleDbCommand cmd = sqlconn.CreateCommand();
String select = "SELECT * FROM [INVENTORY_PURCHASE_INFO] WHERE [inventory_id] = @inventoryId";
cmd.CommandText = select;
cmd.Parameters.Add("inventoryId", OleDbType.Integer).Value = inventoryId;
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
inventoryPurchaseInfo.inventoryItemId = (int)reader["inventory_item_id"];
inventoryPurchaseInfo.manufacturerId = (int)reader["manufacturer_id"];
inventoryPurchaseInfo.minInventory = (int)reader["min_inventory"];
}
return(inventoryPurchaseInfo);
}
catch (OleDbException ex)
{
return(inventoryPurchaseInfo);
}
finally
{
sqlconn.Close();
}
}
}
public static Boolean addNewInventoryPurchaseInfo(InventoryPurchaseInfo purchaseInfo)
{
ManufacturerDAO datalayer1 = new ManufacturerDAO();
Manufacturer existingManufacturer = datalayer1.getSingleManufacturer(purchaseInfo.manufacturerId);
if (existingManufacturer.manufacturerId != null)
{
InventoryPurchaseInfoDAO datalayer2 = new InventoryPurchaseInfoDAO();
return datalayer2.addNewInventoryPurchaseInfo(purchaseInfo);
}
else
{
return false;
}
}
public static Boolean addNewInventoryPurchaseInfo(InventoryPurchaseInfo purchaseInfo)
{
ManufacturerDAO datalayer1 = new ManufacturerDAO();
Manufacturer existingManufacturer = datalayer1.getSingleManufacturer(purchaseInfo.manufacturerId);
if (existingManufacturer.manufacturerId != null)
{
InventoryPurchaseInfoDAO datalayer2 = new InventoryPurchaseInfoDAO();
return(datalayer2.addNewInventoryPurchaseInfo(purchaseInfo));
}
else
{
return(false);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
Boolean success = false;
if (IsValid)
{
InventoryItem inventoryItem = new InventoryItem();
inventoryItem.setProductName(txtProductName.Text);
inventoryItem.setProductCount(Convert.ToInt32(txtProductCount.Text));
inventoryItem.setItemsOnHold(Convert.ToInt32(txtItemsOnHold.Text));
inventoryItem.setUnitPrice(Convert.ToDouble(txtUnitPrice.Text));
inventoryItem.setSalePrice(Convert.ToDouble(txtSalePrice.Text));
inventoryItem.setShortDescription(txtShortDescription.Text);
inventoryItem.setLongDescription(txtLongDescription.Text);
if (ImageFileUpload.PostedFile.ContentType == "image/jpeg" || ImageFileUpload.PostedFile.ContentType == "image/png")
{
String filename = Path.GetFileName(ImageFileUpload.FileName);
ImageFileUpload.SaveAs(Server.MapPath("~/Graphics/" + filename));
inventoryItem.setImageUrl(ImageFileUpload.FileName);
success = InventoryManager.insertNewItem(inventoryItem);
}
else
{
lblMsg.Text = "There is a problem with your image. It must be .jpg or .png. Please try again.";
}
if (success)
{
InventoryPurchaseInfo purchaseInfo = new InventoryPurchaseInfo();
InventoryItem item = InventoryManager.getItemByName(txtProductName.Text);
purchaseInfo.inventoryItemId = item.getInventoryId();
purchaseInfo.manufacturerId = Convert.ToInt32(ddlManufacturer.SelectedValue);
purchaseInfo.minInventory = Convert.ToInt32(txtMinumInventory.Text);
success = PurchaseManager.addNewInventoryPurchaseInfo(purchaseInfo);
}
if (success)
{
lblMsg.Text = "Item successfuly added.";
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
Boolean success = false;
if (IsValid)
{
InventoryItem inventoryItem = new InventoryItem();
inventoryItem.setProductName(txtProductName.Text);
inventoryItem.setProductCount(Convert.ToInt32(txtProductCount.Text));
inventoryItem.setItemsOnHold(Convert.ToInt32(txtItemsOnHold.Text));
inventoryItem.setUnitPrice(Convert.ToDouble(txtUnitPrice.Text));
inventoryItem.setSalePrice(Convert.ToDouble(txtSalePrice.Text));
inventoryItem.setShortDescription(txtShortDescription.Text);
inventoryItem.setLongDescription(txtLongDescription.Text);
if (ImageFileUpload.PostedFile.ContentType == "image/jpeg" || ImageFileUpload.PostedFile.ContentType == "image/png")
{
String filename = Path.GetFileName(ImageFileUpload.FileName);
ImageFileUpload.SaveAs(Server.MapPath("~/Graphics/" + filename));
inventoryItem.setImageUrl(ImageFileUpload.FileName);
success = InventoryManager.insertNewItem(inventoryItem);
}
else
{
lblMsg.Text = "There is a problem with your image. It must be .jpg or .png. Please try again.";
}
if (success)
{
InventoryPurchaseInfo purchaseInfo = new InventoryPurchaseInfo();
InventoryItem item = InventoryManager.getItemByName(txtProductName.Text);
purchaseInfo.inventoryItemId = item.getInventoryId();
purchaseInfo.manufacturerId = Convert.ToInt32(ddlManufacturer.SelectedValue);
purchaseInfo.minInventory = Convert.ToInt32(txtMinumInventory.Text);
success = PurchaseManager.addNewInventoryPurchaseInfo(purchaseInfo);
}
if (success)
{
lblMsg.Text = "Item successfuly added.";
}
}
}
public Boolean addNewInventoryPurchaseInfo(InventoryPurchaseInfo purchaseInfo)
{
Boolean success = false;
using (OleDbConnection sqlconn = new OleDbConnection(database))
{
try
{
sqlconn.Open();
OleDbCommand cmd = sqlconn.CreateCommand();
String insert = "INSERT INTO [INVENTORY_PURCHASE_INFO] ([inventory_item_id], [manufacturer_id], [min_inventory]) VALUES " +
"(@inventoryItemId, @manufacturerId, @minInventory)";
cmd.CommandText = insert;
cmd.Parameters.Add("inventoryItemId", OleDbType.Integer).Value = purchaseInfo.inventoryItemId;
cmd.Parameters.Add("manufacturerId", OleDbType.Integer).Value = purchaseInfo.manufacturerId;
cmd.Parameters.Add("minInventory", OleDbType.Integer).Value = purchaseInfo.minInventory;
int rows = cmd.ExecuteNonQuery();
if (rows == 1)
{
success = true;
}
return(success);
}
catch (OleDbException ex)
{
return(success);
}
finally
{
sqlconn.Close();
}
}
}
public Boolean addNewInventoryPurchaseInfo(InventoryPurchaseInfo purchaseInfo)
{
Boolean success = false;
using (OleDbConnection sqlconn = new OleDbConnection(database))
{
try
{
sqlconn.Open();
OleDbCommand cmd = sqlconn.CreateCommand();
String insert = "INSERT INTO [INVENTORY_PURCHASE_INFO] ([inventory_item_id], [manufacturer_id], [min_inventory]) VALUES " +
"(@inventoryItemId, @manufacturerId, @minInventory)";
cmd.CommandText = insert;
cmd.Parameters.Add("inventoryItemId", OleDbType.Integer).Value = purchaseInfo.inventoryItemId;
cmd.Parameters.Add("manufacturerId", OleDbType.Integer).Value = purchaseInfo.manufacturerId;
cmd.Parameters.Add("minInventory", OleDbType.Integer).Value = purchaseInfo.minInventory;
int rows = cmd.ExecuteNonQuery();
if (rows == 1)
{
success = true;
}
return success;
}
catch (OleDbException ex)
{
return success;
}
finally
{
sqlconn.Close();
}
}
}
public List <InventoryPurchaseInfo> getItemsBelowMinInventory()
{
List <InventoryPurchaseInfo> inventoryPurchaseInfo = new List <InventoryPurchaseInfo>();
using (OleDbConnection sqlconn = new OleDbConnection(database))
{
try
{
sqlconn.Open();
OleDbCommand cmd = sqlconn.CreateCommand();
String select = "SELECT [INVENTORY_PURCHASE_INFO].inventory_item_id, [INVENTORY_PURCHASE_INFO].manufacturer_id, [INVENTORY_PURCHASE_INFO].min_inventory " +
"FROM [INVENTORY_PURCHASE_INFO] INNER JOIN [INVENTORY_ITEM] ON ([INVENTORY_PURCHASE_INFO].inventory_item_id = [INVENTORY_ITEM].inventory_id) " +
"WHERE [INVENTORY_PURCHASE_INFO].min_inventory > [INVENTORY_ITEM].product_count ORDER BY [INVENTORY_PURCHASE_INFO].manufacturer_id";
cmd.CommandText = select;
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
InventoryPurchaseInfo info = new InventoryPurchaseInfo();
info.inventoryItemId = (int)reader["inventory_item_id"];
info.manufacturerId = (int)reader["manufacturer_id"];
info.minInventory = (int)reader["min_inventory"];
inventoryPurchaseInfo.Add(info);
}
return(inventoryPurchaseInfo);
}
catch (OleDbException ex)
{
return(inventoryPurchaseInfo);
}
finally
{
sqlconn.Close();
}
}
}
public static Boolean updateInventoryPurchaseInfo(InventoryPurchaseInfo purchaseInfo)
{
InventoryPurchaseInfoDAO datalayer = new InventoryPurchaseInfoDAO();
return datalayer.updateInventoryPurchaseInfo(purchaseInfo);
}
public Boolean updateInventoryPurchaseInfo(InventoryPurchaseInfo inventoryPurchaseInfo)
{
Boolean success = false;
using(OleDbConnection sqlconn = new OleDbConnection(database))
{
try
{
sqlconn.Open();
OleDbCommand cmd = sqlconn.CreateCommand();
String update = "UPDATE [INVENTORY_PURCHASE_INFO] SET [manufacturer_id] = @manufacturerId, [min_inventory] = @minInventory WHERE [inventory_id] = @inventoryId";
cmd.CommandText = update;
cmd.Parameters.Add("manufacturerId", OleDbType.Integer).Value = inventoryPurchaseInfo.manufacturerId;
cmd.Parameters.Add("minInventory", OleDbType.Integer).Value = inventoryPurchaseInfo.minInventory;
cmd.Parameters.Add("inventoryId", OleDbType.Integer).Value = inventoryPurchaseInfo.inventoryItemId;
int rows = cmd.ExecuteNonQuery();
if (rows == 1)
{
success = true;
}
return success;
}
catch (OleDbException ex)
{
return success;
}
finally
{
sqlconn.Close();
}
}
}
public InventoryPurchaseInfo getSingleInventoryPurchaseInfo(int inventoryId)
{
InventoryPurchaseInfo inventoryPurchaseInfo = new InventoryPurchaseInfo();
using (OleDbConnection sqlconn = new OleDbConnection(database))
{
try
{
sqlconn.Open();
OleDbCommand cmd = sqlconn.CreateCommand();
String select = "SELECT * FROM [INVENTORY_PURCHASE_INFO] WHERE [inventory_id] = @inventoryId";
cmd.CommandText = select;
cmd.Parameters.Add("inventoryId", OleDbType.Integer).Value = inventoryId;
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
inventoryPurchaseInfo.inventoryItemId = (int)reader["inventory_item_id"];
inventoryPurchaseInfo.manufacturerId = (int)reader["manufacturer_id"];
inventoryPurchaseInfo.minInventory = (int)reader["min_inventory"];
}
return inventoryPurchaseInfo;
}
catch (OleDbException ex)
{
return inventoryPurchaseInfo;
}
finally
{
sqlconn.Close();
}
}
}
public List<InventoryPurchaseInfo> getItemsBelowMinInventory()
{
List<InventoryPurchaseInfo> inventoryPurchaseInfo = new List<InventoryPurchaseInfo>();
using (OleDbConnection sqlconn = new OleDbConnection(database))
{
try
{
sqlconn.Open();
OleDbCommand cmd = sqlconn.CreateCommand();
String select = "SELECT [INVENTORY_PURCHASE_INFO].inventory_item_id, [INVENTORY_PURCHASE_INFO].manufacturer_id, [INVENTORY_PURCHASE_INFO].min_inventory " +
"FROM [INVENTORY_PURCHASE_INFO] INNER JOIN [INVENTORY_ITEM] ON ([INVENTORY_PURCHASE_INFO].inventory_item_id = [INVENTORY_ITEM].inventory_id) " +
"WHERE [INVENTORY_PURCHASE_INFO].min_inventory > [INVENTORY_ITEM].product_count ORDER BY [INVENTORY_PURCHASE_INFO].manufacturer_id";
cmd.CommandText = select;
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
InventoryPurchaseInfo info = new InventoryPurchaseInfo();
info.inventoryItemId = (int)reader["inventory_item_id"];
info.manufacturerId = (int)reader["manufacturer_id"];
info.minInventory = (int)reader["min_inventory"];
inventoryPurchaseInfo.Add(info);
}
return inventoryPurchaseInfo;
}
catch (OleDbException ex)
{
return inventoryPurchaseInfo;
}
finally
{
sqlconn.Close();
}
}
}
public static Boolean updateInventoryPurchaseInfo(InventoryPurchaseInfo purchaseInfo)
{
InventoryPurchaseInfoDAO datalayer = new InventoryPurchaseInfoDAO();
return(datalayer.updateInventoryPurchaseInfo(purchaseInfo));
}
