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