/// <summary>: obtém o id de determinado status ativo!
/// <response>: o id do status buscado.
public int GetStatusIdByName(string status_name)
{
ItemStatus status = new ItemStatus();
cmd = new NpgsqlCommand(getStatusNameById, conn);
cmd.Parameters.AddWithValue("@its_name", status_name);
reader = cmd.ExecuteReader();
if (reader.Read())
{
status.SetId((int)reader["its_id"]);
}
reader.Close();
return(status.GetId());
}
/// <summary>: obtém o status atual do item!
/// <response>: o id do status buscado.
public int CurrentStatus(int request_item_id)
{
ItemStatus status = new ItemStatus();
cmd = new NpgsqlCommand(currentStatus, conn);
cmd.Parameters.AddWithValue("@request_item.itm_id", request_item_id);
reader = cmd.ExecuteReader();
if (reader.Read())
{
status.its_id = (int)reader["its_id"];
}
reader.Close();
return(status.GetId());
}
/// <summary>Retorna o id do status se o nome é informado</sumary>
public int GetStatusIdByName(string status_name)
{
connection = db.GetCon();
connection.Open();
ItemStatus status = new ItemStatus();
ItemStatusDao dao = new ItemStatusDao(connection, null);
try
{
status.SetId(dao.GetStatusIdByName(status_name));
}
finally
{
connection.Close();
db.Close();
}
return(status.GetId());
}
