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); } }