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