public InventoryMaster GetInventoryItem(int id) { try { InventoryMaster item = new InventoryMaster(); using (SqlConnection con = new SqlConnection(connectionString)) { string sqlQuery = "SELECT * FROM InventoryMaster WHERE InventoryID= " + id; SqlCommand cmd = new SqlCommand(sqlQuery, con); con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { item.InventoryID = Convert.ToInt32(rdr["InventoryID"]); item.ItemName = rdr["Name"].ToString(); item.StockQty = Convert.ToInt32(rdr["Quantity"]); item.ReorderQty = Convert.ToInt32(rdr["ReorderQty"]); item.PriorityStatus = Convert.ToInt32(rdr["PriorityStatus"]); } } return(item); } catch { throw; } }
public int UpdateInventory(InventoryMaster item) { try { using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("spUpdateEmployee", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@InventoryID", item.InventoryID); cmd.Parameters.AddWithValue("@Name", item.ItemName); cmd.Parameters.AddWithValue("@Quantity", item.StockQty); cmd.Parameters.AddWithValue("@ReorderQty", item.ReorderQty); cmd.Parameters.AddWithValue("@PriorityStatus", item.PriorityStatus); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } return(1); } catch { throw; } }
public IEnumerable <InventoryMaster> GetAllStock() { try { List <InventoryMaster> lstInventory = new List <InventoryMaster>(); using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("spGetAllEmployees", con); cmd.CommandType = CommandType.StoredProcedure; con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { InventoryMaster inventory = new InventoryMaster(); inventory.InventoryID = Convert.ToInt32(rdr["InventoryID"]); inventory.ItemName = rdr["Name"].ToString(); inventory.StockQty = Convert.ToInt32(rdr["Quantity"]); inventory.ReorderQty = Convert.ToInt32(rdr["ReorderQty"]); inventory.PriorityStatus = Convert.ToInt32(rdr["PriorityStatus"]); lstInventory.Add(inventory); } con.Close(); } return(lstInventory); } catch { throw; } }
public int Edit([FromBody] InventoryMaster item) { return(objemployee.UpdateInventory(item)); }
public int Create([FromBody] InventoryMaster item) { return(objemployee.AddInventory(item)); }