public InventorySM Map(InventoryDM human)
{
InventorySM user = new InventorySM();
user.inventoryName = human.inventoryName;
user.inventoryPrice = human.inventoryPrice;
user.inventoryStock = human.inventoryStock;
user.inventoryID = human.inventoryID;
return(user);
}
public List <InventoryDM> DisplayInventory()
{
List <InventoryDM> inventoryList = new List <InventoryDM>();
SqlConnection myConnection = new SqlConnection(ConnectionString);
try
{
using (var conn = new SqlConnection(ConnectionString))
{
myConnection.Open();
using (SqlCommand cmd = new SqlCommand("DisplayInventory", myConnection))
{
cmd.Connection = myConnection;
cmd.CommandType = CommandType.StoredProcedure;
using (var reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
var cust = new InventoryDM();
if (!reader.IsDBNull(reader.GetOrdinal("inventoryID")))
{
cust.inventoryID = reader.GetInt32(reader.GetOrdinal("inventoryID"));
}
if (!reader.IsDBNull(reader.GetOrdinal("inventoryName")))
{
cust.inventoryName = reader.GetString(reader.GetOrdinal("inventoryName"));
}
if (!reader.IsDBNull(reader.GetOrdinal("inventoryPrice")))
{
cust.inventoryPrice = reader.GetDecimal(reader.GetOrdinal("inventoryPrice"));
}
if (!reader.IsDBNull(reader.GetOrdinal("inventoryStock")))
{
cust.inventoryStock = reader.GetInt32(reader.GetOrdinal("inventoryStock"));
}
inventoryList.Add(cust);
}
}
}
}
}
return(inventoryList);
}
catch (Exception e)
{
return(null);
}
}
public InventoryDM GetInventoryInfoByInventoryID(int id)
{
try
{
using (SqlConnection myConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("GetInventoryInfoByInventoryID", myConnection))
{
myConnection.Open();
var cust = new InventoryDM();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@inventoryID", id);
List <InventoryDM> inventoryList = new List <InventoryDM>();
using (var reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
if (!reader.IsDBNull(reader.GetOrdinal("inventoryID")))
{
cust.inventoryID = reader.GetInt32(reader.GetOrdinal("inventoryID"));
}
if (!reader.IsDBNull(reader.GetOrdinal("inventoryName")))
{
cust.inventoryName = reader.GetString(reader.GetOrdinal("inventoryName"));
}
if (!reader.IsDBNull(reader.GetOrdinal("inventoryPrice")))
{
cust.inventoryPrice = reader.GetDecimal(reader.GetOrdinal("inventoryPrice"));
}
if (!reader.IsDBNull(reader.GetOrdinal("inventoryStock")))
{
cust.inventoryStock = reader.GetInt32(reader.GetOrdinal("inventoryStock"));
}
inventoryList.Add(cust);
}
}
}
return(cust);
}
}
}
catch (Exception e)
{
return(null);
}
}
public void DeleteInventory(InventoryDM user)
{
try
{
using (SqlConnection myConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("DeleteInventory", myConnection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@inventoryName", user.inventoryName);
cmd.Parameters.AddWithValue("@inventoryPrice", user.inventoryPrice);
cmd.Parameters.AddWithValue("@inventoryStock", user.inventoryStock);
myConnection.Open();
cmd.ExecuteNonQuery();
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public void CreateInventory(InventoryDM user)
{
try
{
//Identify repetitive code and place within a method that can be called from anywhere.
//Make them as general enough so it can be use more than once
using (SqlConnection myConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("AddInventory", myConnection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@inventoryName", user.inventoryName);
cmd.Parameters.AddWithValue("@inventoryPrice", user.inventoryPrice);
cmd.Parameters.AddWithValue("@inventoryStock", user.inventoryStock);
myConnection.Open();
cmd.ExecuteNonQuery();
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
